MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_status_type:/tablelist/okayapi_lvyou_jee_status_type.html
-- MySQL Table okayapi_lvyou_jee_status_type
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_status_type` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`status_name` varchar(64) NULL COMMENT '状态名',
`apllication_scope` varchar(64) NULL COMMENT '使用范围',
`okayapi_lvyou_jee_status_type_status` int(11) NULL COMMENT '记录状态:0禁用,1启用',
KEY `status_name` (`status_name`),
KEY `apllication_scope` (`apllication_scope`),
KEY `okayapi_lvyou_jee_status_type_status` (`okayapi_lvyou_jee_status_type_status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-状态类型表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-3 of 3 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
status_name | varchar(64) | 否 | 状态名 | |||
apllication_scope | varchar(64) | 是 | 使用范围 | |||
okayapi_lvyou_jee_status_type_status | int(11) | 是 | 记录状态:0禁用,1启用 |