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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
uid | int(11) | 否 | 用户ID | |||
entityId | int(11) | 0 | 否 | EntityId | 0 | |
categoryId | int(11) | 0 | 否 | 分类表Id | 0 | |
title | varchar(255) | 否 | 标题 | |||
face | varchar(255) | http://placehold.it/210x140 | 否 | 封面 | http://placehold.it/210x140 | |
content | text | 是 | 内容 | |||
addTime | int(10) | 0 | 否 | 添加时间 | 0 | |
upTime | int(10) | 0 | 否 | 更新时间 | 0 | |
keyWord | varchar(255) | 是 | 关键字 | |||
commentNum | int(11) | 0 | 否 | 评论数 | 0 | |
viewNum | int(11) | 0 | 否 | 阅读数 | 0 | |
okayapi_eduwind_ew_article_status | int(11) | 0 | 否 | 状态 | 0 | |
isTop | tinyint(1) | 0 | 否 | 是否置顶 | 0 |