+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_cmdb_mgmt_field:/tablelist/okayapi_cmdb_mgmt_field.html


-- MySQL Table okayapi_cmdb_mgmt_field
-- From: OkayAPI.com
CREATE TABLE `okayapi_cmdb_mgmt_field` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_cmdb_mgmt_field_name` varchar(20) NOT NULL COMMENT '',
    `alias` varchar(20) NOT NULL COMMENT '',
    `readme` longtext NOT NULL COMMENT '',
    `okayapi_cmdb_mgmt_field_type` smallint(6) NOT NULL COMMENT '',
    `is_multi` tinyint(1) NOT NULL COMMENT '',
    `required` tinyint(1) NOT NULL COMMENT '',
    `table_id` varchar(20) NOT NULL COMMENT '',
    KEY `okayapi_cmdb_mgmt_field_name` (`okayapi_cmdb_mgmt_field_name`),
    KEY `alias` (`alias`),
    KEY `readme` (`readme`),
    KEY `okayapi_cmdb_mgmt_field_type` (`okayapi_cmdb_mgmt_field_type`),
    KEY `is_multi` (`is_multi`),
    KEY `required` (`required`),
    KEY `table_id` (`table_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CMDB管理-字段';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-7 of 7 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_cmdb_mgmt_field_namevarchar(20)
aliasvarchar(20)
readmelongtext
okayapi_cmdb_mgmt_field_typesmallint(6)
is_multitinyint(1)
requiredtinyint(1)
table_idvarchar(20)Normal Index

Guess You Like

MySQL Table Design okayapi_cmdb_auth_group

MySQL Table Design okayapi_cmdb_auth_group_permissions

MySQL Table Design okayapi_cmdb_auth_permission

MySQL Table Design okayapi_cmdb_c_test_person

MySQL Table Design okayapi_cmdb_django_admin_log

MySQL Table Design okayapi_cmdb_django_content_type

MySQL Table Design okayapi_cmdb_django_migrations

MySQL Table Design okayapi_cmdb_django_session

MySQL Table Design okayapi_cmdb_mgmt_department

MySQL Table Design okayapi_cmdb_mgmt_department_permissions

MySQL Table Design okayapi_cmdb_mgmt_permission

MySQL Table Design okayapi_cmdb_mgmt_restpwverifycode

MySQL Table Design okayapi_cmdb_mgmt_table

MySQL Table Design okayapi_cmdb_mgmt_user

MySQL Table Design okayapi_cmdb_mgmt_user_departments

MySQL Table Design okayapi_cmdb_mgmt_user_groups

MySQL Table Design okayapi_cmdb_mgmt_user_permissions

MySQL Table Design okayapi_cmdb_mgmt_user_user_permissions

TOP ↑