MySQL Create Table SQL
Table Structure: okayapi_qi_ace_sys_dict_item：/tablelist/okayapi_qi_ace_sys_dict_item.html
-- MySQL Table okayapi_qi_ace_sys_dict_item
-- From: OkayAPI.com
CREATE TABLE `okayapi_qi_ace_sys_dict_item` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dict_id` int(11) NULL COMMENT '',
`okayapi_qi_ace_sys_dict_item_value` varchar(100) NULL COMMENT '',
`label` varchar(100) NULL COMMENT '',
`okayapi_qi_ace_sys_dict_item_type` varchar(100) NULL COMMENT '',
`description` varchar(100) NULL COMMENT '',
`sort` int(10) NULL DEFAULT '0' COMMENT '排序（升序）',
`create_time` datetime NULL COMMENT '创建时间',
`remarks` varchar(255) NULL COMMENT '',
`del_flag` char(1) NULL DEFAULT '0' COMMENT '',
KEY `dict_id` (`dict_id`),
KEY `okayapi_qi_ace_sys_dict_item_value` (`okayapi_qi_ace_sys_dict_item_value`),
KEY `label` (`label`),
KEY `okayapi_qi_ace_sys_dict_item_type` (`okayapi_qi_ace_sys_dict_item_type`),
KEY `description` (`description`),
KEY `sort` (`sort`),
KEY `create_time` (`create_time`),
KEY `remarks` (`remarks`),
KEY `del_flag` (`del_flag`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'qi后台管理系统-字典项';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-9 of 9 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| dict_id | int(11) | 否 | ||||
| okayapi_qi_ace_sys_dict_item_value | varchar(100) | 是 | Normal Index | |||
| label | varchar(100) | 是 | Normal Index | |||
| okayapi_qi_ace_sys_dict_item_type | varchar(100) | 是 | ||||
| description | varchar(100) | 是 | ||||
| sort | int(10) | 0 | 否 | 排序（升序） | 0 | |
| create_time | datetime | 否 | 创建时间 | |||
| remarks | varchar(255) | 是 | ||||
| del_flag | char(1) | 0 | 是 | Normal Index | 0 |
