+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_course_post:/tablelist/okayapi_eduwind_ew_course_post.html


-- MySQL Table okayapi_eduwind_ew_course_post
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_course_post` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `courseId` int(11) NOT NULL COMMENT '',
    `lessonId` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `title` varchar(128) NOT NULL COMMENT '帖子标题',
    `content` text NOT NULL COMMENT '帖子内容',
    `upTime` int(11) NOT NULL COMMENT '更新时间',
    `addTime` int(11) NOT NULL COMMENT '添加时间',
    `userId` int(11) NOT NULL COMMENT '发表者id',
    `commentNum` int(11) NOT NULL DEFAULT '0' COMMENT '回帖总数',
    `viewNum` int(11) NOT NULL DEFAULT '0' COMMENT '浏览总数',
    `voteNum` int(11) NOT NULL DEFAULT '0' COMMENT '投票总数',
    `isTop` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否置顶',
    `isDigest` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否精华帖',
    `voteUpNum` int(11) NOT NULL DEFAULT '0' COMMENT '赞',
    `voteDownNum` int(11) NOT NULL DEFAULT '0' COMMENT '赞',
    `commentableEntityId` int(11) NOT NULL DEFAULT '0' COMMENT '评论对象id',
    `entityId` int(11) NOT NULL DEFAULT '0' COMMENT 'Entity对象Id',
    `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `deleteTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `courseId` (`courseId`),
    KEY `lessonId` (`lessonId`),
    KEY `title` (`title`),
    KEY `content` (`content`),
    KEY `upTime` (`upTime`),
    KEY `addTime` (`addTime`),
    KEY `userId` (`userId`),
    KEY `commentNum` (`commentNum`),
    KEY `viewNum` (`viewNum`),
    KEY `voteNum` (`voteNum`),
    KEY `isTop` (`isTop`),
    KEY `isDigest` (`isDigest`),
    KEY `voteUpNum` (`voteUpNum`),
    KEY `voteDownNum` (`voteDownNum`),
    KEY `commentableEntityId` (`commentableEntityId`),
    KEY `entityId` (`entityId`),
    KEY `deleted` (`deleted`),
    KEY `deleteTime` (`deleteTime`),
    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-18 of 18 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
courseIdint(11)
lessonIdint(11)00
titlevarchar(128)帖子标题
contenttext帖子内容
upTimeint(11)更新时间
addTimeint(11)添加时间
userIdint(11)发表者idNormal Index
commentNumint(11)0回帖总数0
viewNumint(11)0浏览总数0
voteNumint(11)0投票总数0
isToptinyint(1)0是否置顶0
isDigesttinyint(1)0是否精华帖0
voteUpNumint(11)00
voteDownNumint(11)00
commentableEntityIdint(11)0评论对象id0
entityIdint(11)0Entity对象Id0
deletedtinyint(1)00
deleteTimeint(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 ↑