MySQL Create Table SQL
Table Structure: okayapi_bi_metadata：/tablelist/okayapi_bi_metadata.html
-- MySQL Table okayapi_bi_metadata
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_metadata` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NULL COMMENT '',
`groupid` varchar(255) NULL COMMENT '',
`userid` varchar(255) NULL COMMENT '',
`mimeid` varchar(255) NULL COMMENT '',
`indexfield` varchar(32) NULL COMMENT '',
`plugin` varchar(32) NULL COMMENT '',
`orgi` varchar(32) NULL COMMENT '',
KEY `name` (`name`),
KEY `groupid` (`groupid`),
KEY `userid` (`userid`),
KEY `mimeid` (`mimeid`),
KEY `indexfield` (`indexfield`),
KEY `plugin` (`plugin`),
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-7 of 7 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| name | varchar(255) | 是 | ||||
| groupid | varchar(255) | 是 | ||||
| userid | varchar(255) | 是 | ||||
| mimeid | varchar(255) | 是 | ||||
| indexfield | varchar(32) | 是 | ||||
| plugin | varchar(32) | 是 | ||||
| orgi | varchar(32) | 是 |
