+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_comment:/tablelist/okayapi_eduwind_ew_comment.html


-- MySQL Table okayapi_eduwind_ew_comment
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_comment` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` char(255) NOT NULL COMMENT '标题',
    `content` text NOT NULL COMMENT '内容',
    `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '发表时间',
    `ew_rate` int(11) NOT NULL DEFAULT '0' COMMENT '评分',
    `userId` int(11) NOT NULL COMMENT '发表者id',
    `commentableEntityId` int(11) NOT NULL DEFAULT '0' COMMENT '评论对象id',
    `entityId` int(11) NOT NULL DEFAULT '0' COMMENT 'Entity对象Id',
    `referId` int(11) NOT NULL DEFAULT '0' COMMENT '引用回复',
    `voteUpNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `voteDownNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `deleteTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `title` (`title`),
    KEY `content` (`content`),
    KEY `addTime` (`addTime`),
    KEY `ew_rate` (`ew_rate`),
    KEY `userId` (`userId`),
    KEY `commentableEntityId` (`commentableEntityId`),
    KEY `entityId` (`entityId`),
    KEY `referId` (`referId`),
    KEY `voteUpNum` (`voteUpNum`),
    KEY `voteDownNum` (`voteDownNum`),
    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-12 of 12 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlechar(255)标题
contenttext内容
addTimeint(11)0发表时间0
ew_rateint(11)0评分0
userIdint(11)发表者idNormal Index
commentableEntityIdint(11)0评论对象id0
entityIdint(11)0Entity对象Id0
referIdint(11)0引用回复0
voteUpNumint(11)00
voteDownNumint(11)00
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 ↑