MySQL Create Table SQL
Table Structure: okayapi_bi_category:/tablelist/okayapi_bi_category.html
-- MySQL Table okayapi_bi_category
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_category` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NULL COMMENT '',
`description` varchar(255) NULL COMMENT '',
`code` varchar(255) NULL COMMENT '',
`groupid` varchar(255) NULL COMMENT '',
`createtime` varchar(255) NULL COMMENT '',
`userid` varchar(255) NULL COMMENT '',
`previewtemplet` varchar(255) NULL COMMENT '',
`blocklisttemplet` varchar(255) NULL COMMENT '',
`datasource` varchar(255) NULL COMMENT '',
`fullcontentview` varchar(255) NULL COMMENT '',
`defaultcate` smallint(6) NULL COMMENT '',
`mlt` smallint(6) NULL COMMENT '',
`mltfield` varchar(255) NULL COMMENT '',
`mltcount` int(11) NULL COMMENT '',
`mltntp` int(11) NULL COMMENT '',
`rulename` varchar(255) NULL COMMENT '',
`facetfield` longtext NULL COMMENT '',
`facetquery` longtext NULL COMMENT '',
`facetdate` longtext NULL COMMENT '',
`seclev` varchar(50) NULL COMMENT '',
`orgi` varchar(32) NULL COMMENT '',
KEY `name` (`name`),
KEY `description` (`description`),
KEY `code` (`code`),
KEY `groupid` (`groupid`),
KEY `createtime` (`createtime`),
KEY `userid` (`userid`),
KEY `previewtemplet` (`previewtemplet`),
KEY `blocklisttemplet` (`blocklisttemplet`),
KEY `datasource` (`datasource`),
KEY `fullcontentview` (`fullcontentview`),
KEY `defaultcate` (`defaultcate`),
KEY `mlt` (`mlt`),
KEY `mltfield` (`mltfield`),
KEY `mltcount` (`mltcount`),
KEY `mltntp` (`mltntp`),
KEY `rulename` (`rulename`),
KEY `facetfield` (`facetfield`),
KEY `facetquery` (`facetquery`),
KEY `facetdate` (`facetdate`),
KEY `seclev` (`seclev`),
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-21 of 21 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(255) | 是 | ||||
description | varchar(255) | 是 | ||||
code | varchar(255) | 是 | ||||
groupid | varchar(255) | 是 | ||||
createtime | varchar(255) | 是 | ||||
userid | varchar(255) | 是 | ||||
previewtemplet | varchar(255) | 是 | ||||
blocklisttemplet | varchar(255) | 是 | ||||
datasource | varchar(255) | 是 | ||||
fullcontentview | varchar(255) | 是 | ||||
defaultcate | smallint(6) | 是 | ||||
mlt | smallint(6) | 是 | ||||
mltfield | varchar(255) | 是 | ||||
mltcount | int(11) | 是 | ||||
mltntp | int(11) | 是 | ||||
rulename | varchar(255) | 是 | ||||
facetfield | longtext | 是 | ||||
facetquery | longtext | 是 | ||||
facetdate | longtext | 是 | ||||
seclev | varchar(50) | 是 | ||||
orgi | varchar(32) | 是 |