MySQL Create Table SQL
Table Structure: okayapi_bi_project:/tablelist/okayapi_bi_project.html
-- MySQL Table okayapi_bi_project
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_project` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NULL COMMENT '',
`orgi` varchar(255) NULL COMMENT '',
`code` varchar(255) NULL COMMENT '',
`demo` varchar(255) NULL COMMENT '',
`contexturl` longtext NULL COMMENT '',
`multilang` smallint(6) NULL COMMENT '',
`langtype` varchar(255) NULL COMMENT '',
`packagename` varchar(255) NULL COMMENT '',
`dbid` varchar(255) NULL COMMENT '',
KEY `name` (`name`),
KEY `orgi` (`orgi`),
KEY `code` (`code`),
KEY `demo` (`demo`),
KEY `contexturl` (`contexturl`),
KEY `multilang` (`multilang`),
KEY `langtype` (`langtype`),
KEY `packagename` (`packagename`),
KEY `dbid` (`dbid`),
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 |
---|---|---|---|---|---|---|
name | varchar(255) | 是 | ||||
orgi | varchar(255) | 是 | ||||
code | varchar(255) | 是 | ||||
demo | varchar(255) | 是 | ||||
contexturl | longtext | 是 | ||||
multilang | smallint(6) | 否 | ||||
langtype | varchar(255) | 是 | ||||
packagename | varchar(255) | 是 | ||||
dbid | varchar(255) | 是 |