MySQL Create Table SQL
Table Structure: okayapi_bi_analyzereport:/tablelist/okayapi_bi_analyzereport.html
-- MySQL Table okayapi_bi_analyzereport
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_analyzereport` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NULL COMMENT '',
`reporttype` varchar(32) NULL COMMENT '',
`title` varchar(255) NULL COMMENT '',
`orgi` varchar(32) NULL COMMENT '',
`objectcount` int(11) NULL COMMENT '',
`dicid` varchar(32) NULL COMMENT '',
`createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
`description` longtext NULL COMMENT '',
`html` longtext NULL COMMENT '',
`reportpackage` varchar(255) NULL COMMENT '',
`useacl` varchar(32) NULL COMMENT '',
`status` varchar(32) NULL COMMENT '',
`rolename` text NULL COMMENT '',
`userid` text NULL COMMENT '',
`blacklist` text NULL COMMENT '',
`reportcontent` text NULL COMMENT '',
`reportmodel` varchar(32) NULL COMMENT '',
KEY `name` (`name`),
KEY `reporttype` (`reporttype`),
KEY `title` (`title`),
KEY `orgi` (`orgi`),
KEY `objectcount` (`objectcount`),
KEY `dicid` (`dicid`),
KEY `createtime` (`createtime`),
KEY `description` (`description`),
KEY `html` (`html`),
KEY `reportpackage` (`reportpackage`),
KEY `useacl` (`useacl`),
KEY `status` (`status`),
KEY `rolename` (`rolename`),
KEY `userid` (`userid`),
KEY `blacklist` (`blacklist`),
KEY `reportcontent` (`reportcontent`),
KEY `reportmodel` (`reportmodel`),
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-17 of 17 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(255) | 是 | ||||
reporttype | varchar(32) | 是 | ||||
title | varchar(255) | 是 | ||||
orgi | varchar(32) | 是 | ||||
objectcount | int(11) | 是 | ||||
dicid | varchar(32) | 是 | ||||
createtime | timestamp | CURRENT_TIMESTAMP | 否 | CURRENT_TIMESTAMP | ||
description | longtext | 是 | ||||
html | longtext | 是 | ||||
reportpackage | varchar(255) | 是 | ||||
useacl | varchar(32) | 是 | ||||
status | varchar(32) | 是 | ||||
rolename | text | 是 | ||||
userid | text | 是 | ||||
blacklist | text | 是 | ||||
reportcontent | text | 是 | ||||
reportmodel | varchar(32) | 是 |