+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_zheng_cms_comment:/tablelist/okayapi_zheng_cms_comment.html


-- MySQL Table okayapi_zheng_cms_comment
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_cms_comment` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `pid` int(10) NOT NULL COMMENT '回复楼中楼编号回复楼中楼编号',
    `article_id` int(10) NOT NULL COMMENT '文章编号',
    `user_id` int(10) NOT NULL COMMENT '用户编号',
    `content` text NOT NULL COMMENT '评论内容',
    `okayapi_zheng_cms_comment_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(-1:不通过,0:未审核,1:通过)',
    `ip` varchar(30) NOT NULL COMMENT '评论人ip地址',
    `agent` varchar(200) NOT NULL COMMENT '评论人终端信息',
    `system_id` int(11) NOT NULL COMMENT '所属系统',
    `ctime` bigint(20) NOT NULL COMMENT '创建时间',
    KEY `pid` (`pid`),
    KEY `article_id` (`article_id`),
    KEY `user_id` (`user_id`),
    KEY `content` (`content`),
    KEY `okayapi_zheng_cms_comment_status` (`okayapi_zheng_cms_comment_status`),
    KEY `ip` (`ip`),
    KEY `agent` (`agent`),
    KEY `system_id` (`system_id`),
    KEY `ctime` (`ctime`),
    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-9 of 9 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
pidint(10)回复楼中楼编号回复楼中楼编号
article_idint(10)文章编号Normal Index
user_idint(10)用户编号
contenttext评论内容
okayapi_zheng_cms_comment_statustinyint(4)1状态(-1:不通过,0:未审核,1:通过)1
ipvarchar(30)评论人ip地址
agentvarchar(200)评论人终端信息
system_idint(11)所属系统
ctimebigint(20)创建时间

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

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