okayapi_bi_role_group - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_bi_role_group：/tablelist/okayapi_bi_role_group.html


-- MySQL Table okayapi_bi_role_group
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_role_group` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(32) NULL COMMENT '',
    `parentid` varchar(32) NULL COMMENT '',
    `creater` varchar(32) NULL COMMENT '',
    `orgi` varchar(32) NULL COMMENT '',
    `createtime` timestamp NULL COMMENT '',
    KEY `name` (`name`),
    KEY `parentid` (`parentid`),
    KEY `creater` (`creater`),
    KEY `orgi` (`orgi`),
    KEY `createtime` (`createtime`),
    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-5 of 5 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
name	varchar(32)		是
parentid	varchar(32)		是
creater	varchar(32)		是
orgi	varchar(32)		是
createtime	timestamp		是

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_blacklist

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_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