okayapi_openant_bbs_plate - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_bbs_plate：/tablelist/okayapi_openant_bbs_plate.html


-- MySQL Table okayapi_openant_bbs_plate
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_bbs_plate` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `plate_id` int(11) NOT NULL COMMENT '',
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `admin_ids` text NOT NULL COMMENT '',
    `is_view` tinyint(1) NOT NULL COMMENT '',
    `is_menu` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `label` varchar(28) NOT NULL COMMENT '',
    `allow_posting` tinyint(1) NOT NULL COMMENT '是否允许发帖',
    `date_added` datetime NOT NULL COMMENT '',
    KEY `plate_id` (`plate_id`),
    KEY `user_id` (`user_id`),
    KEY `admin_ids` (`admin_ids`),
    KEY `is_view` (`is_view`),
    KEY `is_menu` (`is_menu`),
    KEY `label` (`label`),
    KEY `allow_posting` (`allow_posting`),
    KEY `date_added` (`date_added`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-论坛版块';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
plate_id	int(11)		否
user_id	int(11)	0	否		0
admin_ids	text		是
is_view	tinyint(1)		否
is_menu	tinyint(1)	0	否		0
label	varchar(28)		否
allow_posting	tinyint(1)		否	是否允许发帖
date_added	datetime		否