MySQL Create Table SQL
Table Structure: okayapi_zheng_cms_system:/tablelist/okayapi_zheng_cms_system.html
-- MySQL Table okayapi_zheng_cms_system
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_cms_system` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_zheng_cms_system_name` varchar(20) NULL COMMENT '系统名称',
`okayapi_zheng_cms_system_code` varchar(20) NULL COMMENT '别名',
`description` varchar(300) NULL COMMENT '描述',
`ctime` bigint(20) NULL COMMENT '创建时间',
`orders` bigint(20) NULL COMMENT '排序',
KEY `okayapi_zheng_cms_system_name` (`okayapi_zheng_cms_system_name`),
KEY `okayapi_zheng_cms_system_code` (`okayapi_zheng_cms_system_code`),
KEY `description` (`description`),
KEY `ctime` (`ctime`),
KEY `orders` (`orders`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'zheng敏捷开发-系统管理';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-5 of 5 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_zheng_cms_system_name | varchar(20) | 否 | 系统名称 | |||
okayapi_zheng_cms_system_code | varchar(20) | 是 | 别名 | |||
description | varchar(300) | 是 | 描述 | |||
ctime | bigint(20) | 是 | 创建时间 | |||
orders | bigint(20) | 是 | 排序 |