+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
namevarchar(255)
rolesvarchar(255)
groupidvarchar(255)
useridvarchar(255)
listtypevarchar(255)
usernamesvarchar(255)
ipstartvarchar(255)
ipendvarchar(255)
iprolesvarchar(255)
timelimitvarchar(255)
orgivarchar(32)

Guess You Like

MySQL Table Design okayapi_bi_crm_contacts

MySQL Table Design okayapi_bi_account

MySQL Table Design okayapi_bi_analyzereport

MySQL Table Design okayapi_bi_auth

MySQL Table Design okayapi_bi_category

MySQL Table Design okayapi_bi_datasource

MySQL Table Design okayapi_bi_datatable

MySQL Table Design okayapi_bi_log_report

MySQL Table Design okayapi_bi_log_request

MySQL Table Design okayapi_bi_metadata

MySQL Table Design okayapi_bi_project

MySQL Table Design okayapi_bi_role

MySQL Table Design okayapi_bi_role_group

MySQL Table Design okayapi_pinot_generic_json_entity

MySQL Table Design okayapi_pinot_anomaly_function_index

MySQL Table Design okayapi_pinot_job_index

MySQL Table Design okayapi_pinot_task_index

MySQL Table Design okayapi_pinot_raw_anomaly_result_index

MySQL Table Design okayapi_pinot_merged_anomaly_result_index

MySQL Table Design okayapi_pinot_dataset_config_index

TOP ↑