MySQL Create Table SQL
Table Structure: okayapi_eduwind_ew_nav：/tablelist/okayapi_eduwind_ew_nav.html
-- MySQL Table okayapi_eduwind_ew_nav
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_nav` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` char(32) NULL COMMENT '',
`activeRule` char(255) NULL COMMENT '',
`weight` int(11) NULL DEFAULT '0' COMMENT '',
`url` char(255) NULL COMMENT '',
`location` char(32) NULL DEFAULT 'top' COMMENT '',
`displayRule` varchar(45) NULL DEFAULT 'return true;' COMMENT '',
KEY `title` (`title`),
KEY `activeRule` (`activeRule`),
KEY `weight` (`weight`),
KEY `url` (`url`),
KEY `location` (`location`),
KEY `displayRule` (`displayRule`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'EW在线教育-导航';
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 |
|---|---|---|---|---|---|---|
| title | char(32) | 否 | ||||
| activeRule | char(255) | 否 | ||||
| weight | int(11) | 0 | 否 | 0 | ||
| url | char(255) | 否 | ||||
| location | char(32) | top | 否 | top | ||
| displayRule | varchar(45) | return true; | 是 | return true; |
