MySQL Create Table SQL
Table Structure: okayapi_bi_datatable：/tablelist/okayapi_bi_datatable.html
-- MySQL Table okayapi_bi_datatable
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_datatable` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`orgi` varchar(255) NULL COMMENT '',
`typeid` varchar(255) NULL COMMENT '',
`ename` varchar(255) NULL COMMENT '',
`cname` varchar(255) NULL COMMENT '',
`typename` varchar(255) NULL COMMENT '',
`demo` varchar(255) NULL COMMENT '',
KEY `orgi` (`orgi`),
KEY `typeid` (`typeid`),
KEY `ename` (`ename`),
KEY `cname` (`cname`),
KEY `typename` (`typename`),
KEY `demo` (`demo`),
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-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| orgi | varchar(255) | 是 | ||||
| typeid | varchar(255) | 是 | ||||
| ename | varchar(255) | 是 | ||||
| cname | varchar(255) | 是 | ||||
| typename | varchar(255) | 是 | ||||
| demo | varchar(255) | 是 |
