okayapi_bi_role - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_bi_role：/tablelist/okayapi_bi_role.html


-- MySQL Table okayapi_bi_role
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_role` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `rolemap` varchar(255) NULL COMMENT '',
    `orgi` varchar(32) NULL COMMENT '',
    `updatetime` timestamp NULL COMMENT '',
    `createtime` timestamp NULL COMMENT '',
    `creater` varchar(32) NULL COMMENT '',
    `description` varchar(32) NULL COMMENT '',
    `name` varchar(255) NULL COMMENT '',
    `groupid` varchar(255) NULL COMMENT '',
    `userid` varchar(255) NULL COMMENT '',
    KEY `rolemap` (`rolemap`),
    KEY `orgi` (`orgi`),
    KEY `updatetime` (`updatetime`),
    KEY `createtime` (`createtime`),
    KEY `creater` (`creater`),
    KEY `description` (`description`),
    KEY `name` (`name`),
    KEY `groupid` (`groupid`),
    KEY `userid` (`userid`),
    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 Name	Field Type	IS NULL
rolemap	varchar(255)	是
orgi	varchar(32)	是
updatetime	timestamp	是
createtime	timestamp	是
creater	varchar(32)	是
description	varchar(32)	是
name	varchar(255)	是
groupid	varchar(255)	是
userid	varchar(255)	是