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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_cmdb_mgmt_field_name | varchar(20) | 否 | ||||
alias | varchar(20) | 是 | ||||
readme | longtext | 是 | ||||
okayapi_cmdb_mgmt_field_type | smallint(6) | 否 | ||||
is_multi | tinyint(1) | 否 | ||||
required | tinyint(1) | 否 | ||||
table_id | varchar(20) | 否 | Normal Index |