MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_area：/tablelist/okayapi_lvyou_jee_area.html
-- MySQL Table okayapi_lvyou_jee_area
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_area` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(11) NULL COMMENT '',
`paths` varchar(100) NULL COMMENT '',
`levels` int(11) NULL COMMENT '',
`sort` int(11) NULL COMMENT '',
`okayapi_lvyou_jee_area_names` varchar(100) NULL COMMENT '',
`names_en` varchar(100) NULL COMMENT '',
KEY `pid` (`pid`),
KEY `paths` (`paths`),
KEY `levels` (`levels`),
KEY `sort` (`sort`),
KEY `okayapi_lvyou_jee_area_names` (`okayapi_lvyou_jee_area_names`),
KEY `names_en` (`names_en`),
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-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| pid | int(11) | 是 | ||||
| paths | varchar(100) | 是 | ||||
| levels | int(11) | 是 | ||||
| sort | int(11) | 是 | ||||
| okayapi_lvyou_jee_area_names | varchar(100) | 是 | ||||
| names_en | varchar(100) | 是 |
