MySQL Create Table SQL
Table Structure: okayapi_srcms_comment：/tablelist/okayapi_srcms_comment.html
-- MySQL Table okayapi_srcms_comment
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_comment` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` varchar(255) NOT NULL COMMENT '评论用户',
`post_id` int(255) NOT NULL COMMENT '评论报告',
`content` varchar(255) NOT NULL COMMENT '评论内容',
KEY `user_id` (`user_id`),
KEY `post_id` (`post_id`),
KEY `content` (`content`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'SRCMS-报告评论';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| user_id | varchar(255) | 否 | 评论用户 | |||
| post_id | int(255) | 否 | 评论报告 | |||
| content | varchar(255) | 否 | 评论内容 |
