+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
namevarchar(255)
codevarchar(255)
drivervarchar(255)
urllongtext
usernamevarchar(255)
passwordvarchar(255)
minconnint(11)
maxconnint(11)
initconnint(11)
timeoutvalueint(11)
waittimeint(11)
orgivarchar(32)

Guess You Like

MySQL Table Design okayapi_bi_crm_contacts

MySQL Table Design okayapi_bi_account

MySQL Table Design okayapi_bi_analyzereport

MySQL Table Design okayapi_bi_auth

MySQL Table Design okayapi_bi_blacklist

MySQL Table Design okayapi_bi_category

MySQL Table Design okayapi_bi_datatable

MySQL Table Design okayapi_bi_log_report

MySQL Table Design okayapi_bi_log_request

MySQL Table Design okayapi_bi_metadata

MySQL Table Design okayapi_bi_project

MySQL Table Design okayapi_bi_role

MySQL Table Design okayapi_bi_role_group

MySQL Table Design okayapi_pinot_generic_json_entity

MySQL Table Design okayapi_pinot_anomaly_function_index

MySQL Table Design okayapi_pinot_job_index

MySQL Table Design okayapi_pinot_task_index

MySQL Table Design okayapi_pinot_raw_anomaly_result_index

MySQL Table Design okayapi_pinot_merged_anomaly_result_index

MySQL Table Design okayapi_pinot_dataset_config_index

TOP ↑