MySQL Create Table SQL
Table Structure: okayapi_bi_blacklist:/tablelist/okayapi_bi_blacklist.html
-- MySQL Table okayapi_bi_blacklist
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_blacklist` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NULL COMMENT '',
`roles` varchar(255) NULL COMMENT '',
`groupid` varchar(255) NULL COMMENT '',
`userid` varchar(255) NULL COMMENT '',
`listtype` varchar(255) NULL COMMENT '',
`usernames` varchar(255) NULL COMMENT '',
`ipstart` varchar(255) NULL COMMENT '',
`ipend` varchar(255) NULL COMMENT '',
`iproles` varchar(255) NULL COMMENT '',
`timelimit` varchar(255) NULL COMMENT '',
`orgi` varchar(32) NULL COMMENT '',
KEY `name` (`name`),
KEY `roles` (`roles`),
KEY `groupid` (`groupid`),
KEY `userid` (`userid`),
KEY `listtype` (`listtype`),
KEY `usernames` (`usernames`),
KEY `ipstart` (`ipstart`),
KEY `ipend` (`ipend`),
KEY `iproles` (`iproles`),
KEY `timelimit` (`timelimit`),
KEY `orgi` (`orgi`),
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-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(255) | 是 | ||||
roles | varchar(255) | 是 | ||||
groupid | varchar(255) | 是 | ||||
userid | varchar(255) | 是 | ||||
listtype | varchar(255) | 是 | ||||
usernames | varchar(255) | 是 | ||||
ipstart | varchar(255) | 是 | ||||
ipend | varchar(255) | 是 | ||||
iproles | varchar(255) | 是 | ||||
timelimit | varchar(255) | 是 | ||||
orgi | varchar(32) | 是 |