+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlechar(255)标题
courseIdint(11)所属课程idNormal Index
weightint(11)0重量,用于课时排序,weight小的在前0
addTimeint(11)0添加时间0
upTimeint(11)0最新修改时间0
mediaIdint(11)00
mediaSourcechar(32)课时来源
mediaUrichar(255)
mediaNamechar(255)
viewNumint(11)0点击0
introductiontext简介
entityIdint(11)00
userIdint(11)0用户id0
mediaTypechar(32)videovideo
okayapi_eduwind_ew_lesson_statusint(11)00
isFreetinyint(1)00
okayapi_eduwind_ew_lesson_numberint(11)00
chapterIdint(11)00
durationint(11)00

Guess You Like

MySQL Table Design okayapi_course_apply

MySQL Table Design okayapi_studyabc_articles

MySQL Table Design okayapi_studyabc_articles_content

MySQL Table Design okayapi_studyabc_cet

MySQL Table Design okayapi_studyabc_cetdesc

MySQL Table Design okayapi_studyabc_tinyenglish

MySQL Table Design okayapi_eduwind_AuthAssignment

MySQL Table Design okayapi_eduwind_AuthItem

MySQL Table Design okayapi_eduwind_AuthItemChild

MySQL Table Design okayapi_eduwind_Rights

MySQL Table Design okayapi_eduwind_YiiSession

MySQL Table Design okayapi_eduwind_ew_announcement

MySQL Table Design okayapi_eduwind_ew_answer

MySQL Table Design okayapi_eduwind_ew_area

MySQL Table Design okayapi_eduwind_ew_article

MySQL Table Design okayapi_eduwind_ew_bottom_text

MySQL Table Design okayapi_eduwind_ew_carousel

MySQL Table Design okayapi_eduwind_ew_category

MySQL Table Design okayapi_eduwind_ew_chapter

MySQL Table Design okayapi_eduwind_ew_city

TOP ↑