MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_advert_area：/tablelist/okayapi_lvyou_jee_advert_area.html
-- MySQL Table okayapi_lvyou_jee_advert_area
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_advert_area` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_lvyou_jee_advert_area_names` varchar(50) NOT NULL COMMENT '',
`names_en` varchar(50) NOT NULL COMMENT '',
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '',
`okayapi_lvyou_jee_advert_area_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
KEY `okayapi_lvyou_jee_advert_area_names` (`okayapi_lvyou_jee_advert_area_names`),
KEY `names_en` (`names_en`),
KEY `sort` (`sort`),
KEY `okayapi_lvyou_jee_advert_area_status` (`okayapi_lvyou_jee_advert_area_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-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| okayapi_lvyou_jee_advert_area_names | varchar(50) | 否 | ||||
| names_en | varchar(50) | 否 | ||||
| sort | int(11) | 0 | 否 | 0 | ||
| okayapi_lvyou_jee_advert_area_status | tinyint(1) | 1 | 否 | 1 |
