+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_bi_auth:/tablelist/okayapi_bi_auth.html


-- MySQL Table okayapi_bi_auth
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_auth` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `resourceid` varchar(32) NULL COMMENT '资源id',
    `resourcetype` varchar(10) NULL COMMENT '资源类型 1 报表  2模型',
    `resourcedic` varchar(32) NULL COMMENT '',
    `authread` varchar(45) NULL COMMENT '操作权限 1读',
    `authtype` varchar(255) NULL COMMENT '',
    `ownerid` varchar(32) NULL COMMENT '所有者id',
    `ownertype` varchar(10) NULL COMMENT '所有者类型',
    `orgi` varchar(16) NULL COMMENT 'orgi',
    `dataid` varchar(32) NULL COMMENT '',
    KEY `resourceid` (`resourceid`),
    KEY `resourcetype` (`resourcetype`),
    KEY `resourcedic` (`resourcedic`),
    KEY `authread` (`authread`),
    KEY `authtype` (`authtype`),
    KEY `ownerid` (`ownerid`),
    KEY `ownertype` (`ownertype`),
    KEY `orgi` (`orgi`),
    KEY `dataid` (`dataid`),
    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-9 of 9 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
resourceidvarchar(32)资源id
resourcetypevarchar(10)资源类型 1 报表 2模型
resourcedicvarchar(32)
authreadvarchar(45)操作权限 1读
authtypevarchar(255)
owneridvarchar(32)所有者id
ownertypevarchar(10)所有者类型
orgivarchar(16)orgi
dataidvarchar(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_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_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 ↑