MySQL Create Table SQL
Table Structure: okayapi_zd_wiki_page_comment：/tablelist/okayapi_zd_wiki_page_comment.html
-- MySQL Table okayapi_zd_wiki_page_comment
-- From: OkayAPI.com
CREATE TABLE `okayapi_zd_wiki_page_comment` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`page_id` bigint(20) NULL COMMENT '页面ID',
`parent_id` bigint(20) NULL COMMENT '父评论ID',
`content` varchar(512) NULL COMMENT '评论内容',
`zan_num` int(11) NULL DEFAULT '0' COMMENT '赞的数量',
`create_user_id` bigint(20) NULL COMMENT '创建人ID',
`create_user_name` varchar(20) NULL COMMENT '创建人名字',
`del_flag` tinyint(4) NULL DEFAULT '0' COMMENT '0=有效 1=删除',
KEY `page_id` (`page_id`),
KEY `parent_id` (`parent_id`),
KEY `content` (`content`),
KEY `zan_num` (`zan_num`),
KEY `create_user_id` (`create_user_id`),
KEY `create_user_name` (`create_user_name`),
KEY `del_flag` (`del_flag`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'WIKI-WIKI页面评论';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-7 of 7 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| page_id | bigint(20) | 是 | 页面ID | |||
| parent_id | bigint(20) | 是 | 父评论ID | |||
| content | varchar(512) | 是 | 评论内容 | |||
| zan_num | int(11) | 0 | 否 | 赞的数量 | 0 | |
| create_user_id | bigint(20) | 是 | 创建人ID | |||
| create_user_name | varchar(20) | 是 | 创建人名字 | |||
| del_flag | tinyint(4) | 0 | 是 | 0=有效 1=删除 | 0 |
