MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_system_info:/tablelist/okayapi_lvyou_jee_system_info.html
-- MySQL Table okayapi_lvyou_jee_system_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_system_info` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_lvyou_jee_system_info_value` varchar(50) NULL COMMENT '',
`okayapi_lvyou_jee_system_info_name` varchar(50) NULL COMMENT '',
`pid` int(11) NULL COMMENT '',
`okayapi_lvyou_jee_system_info_level` int(11) NULL COMMENT '',
`info` varchar(100) NULL COMMENT '',
KEY `okayapi_lvyou_jee_system_info_value` (`okayapi_lvyou_jee_system_info_value`),
KEY `okayapi_lvyou_jee_system_info_name` (`okayapi_lvyou_jee_system_info_name`),
KEY `pid` (`pid`),
KEY `okayapi_lvyou_jee_system_info_level` (`okayapi_lvyou_jee_system_info_level`),
KEY `info` (`info`),
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-5 of 5 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_lvyou_jee_system_info_value | varchar(50) | 是 | ||||
okayapi_lvyou_jee_system_info_name | varchar(50) | 是 | ||||
pid | int(11) | 是 | ||||
okayapi_lvyou_jee_system_info_level | int(11) | 是 | ||||
info | varchar(100) | 是 |