MySQL Create Table SQL
Table Structure: okayapi_eduwind_ew_lesson:/tablelist/okayapi_eduwind_ew_lesson.html
-- MySQL Table okayapi_eduwind_ew_lesson
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_lesson` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` char(255) NOT NULL COMMENT '标题',
`courseId` int(11) NOT NULL COMMENT '所属课程id',
`weight` int(11) NOT NULL DEFAULT '0' COMMENT '重量,用于课时排序,weight小的在前',
`addTime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
`upTime` int(11) NOT NULL DEFAULT '0' COMMENT '最新修改时间',
`mediaId` int(11) NOT NULL DEFAULT '0' COMMENT '',
`mediaSource` char(32) NOT NULL COMMENT '课时来源',
`mediaUri` char(255) NOT NULL COMMENT '',
`mediaName` char(255) NOT NULL COMMENT '',
`viewNum` int(11) NOT NULL DEFAULT '0' COMMENT '点击',
`introduction` text NOT NULL COMMENT '简介',
`entityId` int(11) NOT NULL DEFAULT '0' COMMENT '',
`userId` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
`mediaType` char(32) NOT NULL DEFAULT 'video' COMMENT '',
`okayapi_eduwind_ew_lesson_status` int(11) NOT NULL DEFAULT '0' COMMENT '',
`isFree` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`okayapi_eduwind_ew_lesson_number` int(11) NOT NULL DEFAULT '0' COMMENT '',
`chapterId` int(11) NOT NULL DEFAULT '0' COMMENT '',
`duration` int(11) NOT NULL DEFAULT '0' COMMENT '',
KEY `title` (`title`),
KEY `courseId` (`courseId`),
KEY `weight` (`weight`),
KEY `addTime` (`addTime`),
KEY `upTime` (`upTime`),
KEY `mediaId` (`mediaId`),
KEY `mediaSource` (`mediaSource`),
KEY `mediaUri` (`mediaUri`),
KEY `mediaName` (`mediaName`),
KEY `viewNum` (`viewNum`),
KEY `introduction` (`introduction`),
KEY `entityId` (`entityId`),
KEY `userId` (`userId`),
KEY `mediaType` (`mediaType`),
KEY `okayapi_eduwind_ew_lesson_status` (`okayapi_eduwind_ew_lesson_status`),
KEY `isFree` (`isFree`),
KEY `okayapi_eduwind_ew_lesson_number` (`okayapi_eduwind_ew_lesson_number`),
KEY `chapterId` (`chapterId`),
KEY `duration` (`duration`),
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-19 of 19 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
title | char(255) | 否 | 标题 | |||
courseId | int(11) | 否 | 所属课程id | Normal Index | ||
weight | int(11) | 0 | 否 | 重量,用于课时排序,weight小的在前 | 0 | |
addTime | int(11) | 0 | 否 | 添加时间 | 0 | |
upTime | int(11) | 0 | 否 | 最新修改时间 | 0 | |
mediaId | int(11) | 0 | 否 | 0 | ||
mediaSource | char(32) | 否 | 课时来源 | |||
mediaUri | char(255) | 否 | ||||
mediaName | char(255) | 否 | ||||
viewNum | int(11) | 0 | 否 | 点击 | 0 | |
introduction | text | 是 | 简介 | |||
entityId | int(11) | 0 | 否 | 0 | ||
userId | int(11) | 0 | 否 | 用户id | 0 | |
mediaType | char(32) | video | 否 | video | ||
okayapi_eduwind_ew_lesson_status | int(11) | 0 | 否 | 0 | ||
isFree | tinyint(1) | 0 | 否 | 0 | ||
okayapi_eduwind_ew_lesson_number | int(11) | 0 | 否 | 0 | ||
chapterId | int(11) | 0 | 否 | 0 | ||
duration | int(11) | 0 | 否 | 0 |