okayapi_lvyou_jee_article_section - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_article_section：/tablelist/okayapi_lvyou_jee_article_section.html


-- MySQL Table okayapi_lvyou_jee_article_section
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_article_section` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `pid` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_lvyou_jee_article_section_names` varchar(50) NOT NULL COMMENT '',
    `e_names` varchar(50) NOT NULL COMMENT '',
    `memo` varchar(50) NOT NULL COMMENT '',
    `model` smallint(1) NOT NULL DEFAULT '0' COMMENT '',
    `sort` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_lvyou_jee_article_section_status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '',
    KEY `pid` (`pid`),
    KEY `okayapi_lvyou_jee_article_section_names` (`okayapi_lvyou_jee_article_section_names`),
    KEY `e_names` (`e_names`),
    KEY `memo` (`memo`),
    KEY `model` (`model`),
    KEY `sort` (`sort`),
    KEY `okayapi_lvyou_jee_article_section_status` (`okayapi_lvyou_jee_article_section_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-7 of 7 results.

Field Name	Field Type	Default	IS NULL	Demo Data
pid	int(11)	0	否	0
okayapi_lvyou_jee_article_section_names	varchar(50)		否
e_names	varchar(50)		否
memo	varchar(50)		是
model	smallint(1)	0	否	0
sort	int(11)	0	否	0
okayapi_lvyou_jee_article_section_status	tinyint(2)	1	否	1