+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_article:/tablelist/okayapi_eduwind_ew_article.html


-- MySQL Table okayapi_eduwind_ew_article
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_article` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `uid` int(11) NOT NULL COMMENT '用户ID',
    `entityId` int(11) NOT NULL DEFAULT '0' COMMENT 'EntityId',
    `categoryId` int(11) NOT NULL DEFAULT '0' COMMENT '分类表Id',
    `title` varchar(255) NOT NULL COMMENT '标题',
    `face` varchar(255) NOT NULL DEFAULT 'http://placehold.it/210x140' COMMENT '封面',
    `content` text NOT NULL COMMENT '内容',
    `addTime` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
    `upTime` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
    `keyWord` varchar(255) NOT NULL COMMENT '关键字',
    `commentNum` int(11) NOT NULL DEFAULT '0' COMMENT '评论数',
    `viewNum` int(11) NOT NULL DEFAULT '0' COMMENT '阅读数',
    `okayapi_eduwind_ew_article_status` int(11) NOT NULL DEFAULT '0' COMMENT '状态',
    `isTop` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否置顶',
    KEY `uid` (`uid`),
    KEY `entityId` (`entityId`),
    KEY `categoryId` (`categoryId`),
    KEY `title` (`title`),
    KEY `face` (`face`),
    KEY `content` (`content`),
    KEY `addTime` (`addTime`),
    KEY `upTime` (`upTime`),
    KEY `keyWord` (`keyWord`),
    KEY `commentNum` (`commentNum`),
    KEY `viewNum` (`viewNum`),
    KEY `okayapi_eduwind_ew_article_status` (`okayapi_eduwind_ew_article_status`),
    KEY `isTop` (`isTop`),
    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-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
uidint(11)用户ID
entityIdint(11)0EntityId0
categoryIdint(11)0分类表Id0
titlevarchar(255)标题
facevarchar(255)http://placehold.it/210x140封面http://placehold.it/210x140
contenttext内容
addTimeint(10)0添加时间0
upTimeint(10)0更新时间0
keyWordvarchar(255)关键字
commentNumint(11)0评论数0
viewNumint(11)0阅读数0
okayapi_eduwind_ew_article_statusint(11)0状态0
isToptinyint(1)0是否置顶0

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_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

MySQL Table Design okayapi_eduwind_ew_cms_people

TOP ↑