MySQL Create Table SQL
Table Structure: okayapi_bi_datasource:/tablelist/okayapi_bi_datasource.html
-- MySQL Table okayapi_bi_datasource
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_datasource` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NULL COMMENT '',
`code` varchar(255) NULL COMMENT '',
`driver` varchar(255) NULL COMMENT '',
`url` longtext NULL COMMENT '',
`username` varchar(255) NULL COMMENT '',
`password` varchar(255) NULL COMMENT '',
`minconn` int(11) NULL COMMENT '',
`maxconn` int(11) NULL COMMENT '',
`initconn` int(11) NULL COMMENT '',
`timeoutvalue` int(11) NULL COMMENT '',
`waittime` int(11) NULL COMMENT '',
`orgi` varchar(32) NULL COMMENT '',
KEY `name` (`name`),
KEY `code` (`code`),
KEY `driver` (`driver`),
KEY `url` (`url`),
KEY `username` (`username`),
KEY `password` (`password`),
KEY `minconn` (`minconn`),
KEY `maxconn` (`maxconn`),
KEY `initconn` (`initconn`),
KEY `timeoutvalue` (`timeoutvalue`),
KEY `waittime` (`waittime`),
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-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(255) | 是 | ||||
code | varchar(255) | 是 | ||||
driver | varchar(255) | 是 | ||||
url | longtext | 是 | ||||
username | varchar(255) | 是 | ||||
password | varchar(255) | 是 | ||||
minconn | int(11) | 是 | ||||
maxconn | int(11) | 是 | ||||
initconn | int(11) | 是 | ||||
timeoutvalue | int(11) | 是 | ||||
waittime | int(11) | 是 | ||||
orgi | varchar(32) | 是 |