MySQL Create Table SQL
Table Structure: okayapi_zd_wiki_page_zan：/tablelist/okayapi_zd_wiki_page_zan.html
-- MySQL Table okayapi_zd_wiki_page_zan
-- From: OkayAPI.com
CREATE TABLE `okayapi_zd_wiki_page_zan` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`page_id` bigint(20) NULL COMMENT '页面ID',
`comment_id` bigint(20) NULL COMMENT '评论ID',
`create_user_id` bigint(20) NULL COMMENT '创建人ID',
`create_user_name` varchar(20) NULL COMMENT '创建人名字',
`yn` tinyint(4) NULL COMMENT '是否有效 0=无效 1=有效',
KEY `page_id` (`page_id`),
KEY `comment_id` (`comment_id`),
KEY `create_user_id` (`create_user_id`),
KEY `create_user_name` (`create_user_name`),
KEY `yn` (`yn`),
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-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| page_id | bigint(20) | 是 | 页面ID | |||
| comment_id | bigint(20) | 是 | 评论ID | |||
| create_user_id | bigint(20) | 是 | 创建人ID | |||
| create_user_name | varchar(20) | 是 | 创建人名字 | |||
| yn | tinyint(4) | 是 | 是否有效 0=无效 1=有效 |
