okayapi_eduwind_ew_chapter - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_chapter：/tablelist/okayapi_eduwind_ew_chapter.html


-- MySQL Table okayapi_eduwind_ew_chapter
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_chapter` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `courseId` int(11) NOT NULL COMMENT '',
    `userId` int(11) NOT NULL COMMENT '',
    `weight` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_eduwind_ew_chapter_number` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `lessonNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `title` char(255) NOT NULL COMMENT '',
    `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `courseId` (`courseId`),
    KEY `userId` (`userId`),
    KEY `weight` (`weight`),
    KEY `okayapi_eduwind_ew_chapter_number` (`okayapi_eduwind_ew_chapter_number`),
    KEY `lessonNum` (`lessonNum`),
    KEY `title` (`title`),
    KEY `addTime` (`addTime`),
    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-7 of 7 results.

Field Name	Field Type	Default	IS NULL	Demo Data
courseId	int(11)		否
userId	int(11)		否
weight	int(11)	0	否	0
okayapi_eduwind_ew_chapter_number	int(11)	0	否	0
lessonNum	int(11)	0	否	0
title	char(255)		否
addTime	int(11)	0	否	0