+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_zheng_cms_article:/tablelist/okayapi_zheng_cms_article.html


-- MySQL Table okayapi_zheng_cms_article
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_cms_article` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `topic_id` int(11) NOT NULL COMMENT '所属专题',
    `title` varchar(200) NOT NULL COMMENT '文章标题',
    `author` varchar(50) NOT NULL COMMENT '文章原作者',
    `fromurl` varchar(300) NOT NULL COMMENT '转载来源网址',
    `image` varchar(300) NOT NULL COMMENT '封面图',
    `keywords` varchar(100) NOT NULL COMMENT '关键字',
    `description` varchar(500) NOT NULL COMMENT '简介',
    `okayapi_zheng_cms_article_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '类型(1:普通,2:热门...)',
    `allowcomments` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否允许评论(0:不允许,1:允许)',
    `okayapi_zheng_cms_article_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(-1:不通过,0未审核,1:通过)',
    `content` mediumtext NOT NULL COMMENT '内容',
    `user_id` int(10) NOT NULL COMMENT '发布人id',
    `readnumber` int(10) NOT NULL DEFAULT '0' COMMENT '阅读数量',
    `top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶等级',
    `system_id` int(11) NOT NULL COMMENT '所属系统',
    `ctime` bigint(20) NOT NULL COMMENT '创建时间',
    `orders` bigint(20) NOT NULL COMMENT '排序',
    KEY `topic_id` (`topic_id`),
    KEY `title` (`title`),
    KEY `author` (`author`),
    KEY `fromurl` (`fromurl`),
    KEY `image` (`image`),
    KEY `keywords` (`keywords`),
    KEY `description` (`description`),
    KEY `okayapi_zheng_cms_article_type` (`okayapi_zheng_cms_article_type`),
    KEY `allowcomments` (`allowcomments`),
    KEY `okayapi_zheng_cms_article_status` (`okayapi_zheng_cms_article_status`),
    KEY `content` (`content`),
    KEY `user_id` (`user_id`),
    KEY `readnumber` (`readnumber`),
    KEY `top` (`top`),
    KEY `system_id` (`system_id`),
    KEY `ctime` (`ctime`),
    KEY `orders` (`orders`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'zheng敏捷开发-文章表';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-17 of 17 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
topic_idint(11)所属专题
titlevarchar(200)文章标题
authorvarchar(50)文章原作者
fromurlvarchar(300)转载来源网址
imagevarchar(300)封面图
keywordsvarchar(100)关键字
descriptionvarchar(500)简介
okayapi_zheng_cms_article_typetinyint(4)1类型(1:普通,2:热门...)1
allowcommentstinyint(4)1是否允许评论(0:不允许,1:允许)1
okayapi_zheng_cms_article_statustinyint(4)1状态(-1:不通过,0未审核,1:通过)1
contentmediumtext内容
user_idint(10)发布人id
readnumberint(10)0阅读数量0
topint(11)0置顶等级0
system_idint(11)所属系统
ctimebigint(20)创建时间
ordersbigint(20)排序Normal Index

Guess You Like

MySQL Table Design okayapi_logs

MySQL Table Design okayapi_app_version

MySQL Table Design okayapi_tea

MySQL Table Design okayapi_tea_swiper

MySQL Table Design okayapi_tea_moment

MySQL Table Design okayapi_tea_order

MySQL Table Design okayapi_tea_user

MySQL Table Design okayapi_tea_shopcar

MySQL Table Design okayapi_zheng_cms_article_category

MySQL Table Design okayapi_zheng_cms_article_tag

MySQL Table Design okayapi_zheng_cms_category

MySQL Table Design okayapi_zheng_cms_comment

MySQL Table Design okayapi_zheng_cms_page

MySQL Table Design okayapi_zheng_cms_setting

MySQL Table Design okayapi_zheng_cms_system

MySQL Table Design okayapi_zheng_cms_tag

MySQL Table Design okayapi_zheng_cms_topic

MySQL Table Design okayapi_zheng_pay_in_order

MySQL Table Design okayapi_zheng_pay_in_order_detail

MySQL Table Design okayapi_zheng_pay_mch

TOP ↑