okayapi_studyabc_cet - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_studyabc_cet：/tablelist/okayapi_studyabc_cet.html


-- MySQL Table okayapi_studyabc_cet
-- From: OkayAPI.com
CREATE TABLE `okayapi_studyabc_cet` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `cettitle` varchar(255) NOT NULL COMMENT '',
    `cetdate` date NOT NULL COMMENT '',
    `idate` date NOT NULL COMMENT '',
    `suri` varchar(255) NOT NULL COMMENT '',
    `okayapi_studyabc_cet_type` int(1) NOT NULL DEFAULT '1' COMMENT '1=>cet4,2=>cet6',
    `has_desc` int(1) NOT NULL DEFAULT '0' COMMENT '1=>has,0=>dont',
    KEY `cettitle` (`cettitle`),
    KEY `cetdate` (`cetdate`),
    KEY `idate` (`idate`),
    KEY `suri` (`suri`),
    KEY `okayapi_studyabc_cet_type` (`okayapi_studyabc_cet_type`),
    KEY `has_desc` (`has_desc`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '学英语社区-英文等级';

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
cettitle	varchar(255)		否
cetdate	date		否
idate	date		否
suri	varchar(255)		否
okayapi_studyabc_cet_type	int(1)	1	否	1=>cet4,2=>cet6	Normal Index	1
has_desc	int(1)	0	否	1=>has,0=>dont	Normal Index	0