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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
resourceid | varchar(32) | 是 | 资源id | |||
resourcetype | varchar(10) | 是 | 资源类型 1 报表 2模型 | |||
resourcedic | varchar(32) | 是 | ||||
authread | varchar(45) | 是 | 操作权限 1读 | |||
authtype | varchar(255) | 是 | ||||
ownerid | varchar(32) | 是 | 所有者id | |||
ownertype | varchar(10) | 是 | 所有者类型 | |||
orgi | varchar(16) | 是 | orgi | |||
dataid | varchar(32) | 是 |