MySQL Create Table SQL
Table Structure: okayapi_report：/tablelist/okayapi_report.html
-- MySQL Table okayapi_report
-- From: OkayAPI.com
CREATE TABLE `okayapi_report` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0' COMMENT '举报用户id',
`okayapi_report_type` varchar(50) NOT NULL COMMENT '类别',
`target_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`reason` varchar(255) NOT NULL COMMENT '举报理由',
`url` varchar(255) NOT NULL COMMENT '',
`report_time` int(11) NOT NULL DEFAULT '0' COMMENT '举报时间',
`report_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否处理',
KEY `uid` (`uid`),
KEY `okayapi_report_type` (`okayapi_report_type`),
KEY `target_id` (`target_id`),
KEY `reason` (`reason`),
KEY `url` (`url`),
KEY `report_time` (`report_time`),
KEY `report_status` (`report_status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '投诉举报';
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 |
|---|---|---|---|---|---|---|
| uid | int(11) | 0 | 是 | 举报用户id | 0 | |
| okayapi_report_type | varchar(50) | 是 | 类别 | |||
| target_id | int(11) | 0 | 是 | ID | 0 | |
| reason | varchar(255) | 是 | 举报理由 | |||
| url | varchar(255) | 是 | ||||
| report_time | int(11) | 0 | 是 | 举报时间 | 0 | |
| report_status | tinyint(1) | 0 | 否 | 是否处理 | 0 |
