+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_lesson_learn:/tablelist/okayapi_eduwind_ew_lesson_learn.html


-- MySQL Table okayapi_eduwind_ew_lesson_learn
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_lesson_learn` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `lessonId` int(11) NOT NULL COMMENT '',
    `userId` int(11) NOT NULL COMMENT '',
    `startTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `finishTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_eduwind_ew_lesson_learn_status` int(4) NOT NULL DEFAULT '0' COMMENT '',
    KEY `lessonId` (`lessonId`),
    KEY `userId` (`userId`),
    KEY `startTime` (`startTime`),
    KEY `finishTime` (`finishTime`),
    KEY `okayapi_eduwind_ew_lesson_learn_status` (`okayapi_eduwind_ew_lesson_learn_status`),
    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-5 of 5 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
lessonIdint(11)
userIdint(11)
startTimeint(11)00
finishTimeint(11)00
okayapi_eduwind_ew_lesson_learn_statusint(4)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 ↑