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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
courseId | int(11) | 否 | ||||
lessonId | int(11) | 0 | 否 | 0 | ||
title | varchar(128) | 否 | 帖子标题 | |||
content | text | 否 | 帖子内容 | |||
upTime | int(11) | 是 | 更新时间 | |||
addTime | int(11) | 是 | 添加时间 | |||
userId | int(11) | 否 | 发表者id | Normal Index | ||
commentNum | int(11) | 0 | 否 | 回帖总数 | 0 | |
viewNum | int(11) | 0 | 否 | 浏览总数 | 0 | |
voteNum | int(11) | 0 | 否 | 投票总数 | 0 | |
isTop | tinyint(1) | 0 | 否 | 是否置顶 | 0 | |
isDigest | tinyint(1) | 0 | 否 | 是否精华帖 | 0 | |
voteUpNum | int(11) | 0 | 否 | 赞 | 0 | |
voteDownNum | int(11) | 0 | 否 | 赞 | 0 | |
commentableEntityId | int(11) | 0 | 否 | 评论对象id | 0 | |
entityId | int(11) | 0 | 否 | Entity对象Id | 0 | |
deleted | tinyint(1) | 0 | 否 | 0 | ||
deleteTime | int(11) | 0 | 否 | 0 |