MySQL Create Table SQL
Table Structure: okayapi_bi_log_report:/tablelist/okayapi_bi_log_report.html
-- MySQL Table okayapi_bi_log_report
-- From: OkayAPI.com
CREATE TABLE `okayapi_bi_log_report` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) NULL COMMENT '',
`parameters` text NULL COMMENT '',
`throwable` varchar(255) NULL COMMENT '',
`username` varchar(255) NULL COMMENT '',
`usermail` varchar(255) NULL COMMENT '',
`filename` varchar(255) NULL COMMENT '',
`orgi` varchar(255) NULL COMMENT '',
`error` text NULL COMMENT '',
`dataprocesstime` bigint(20) NULL COMMENT '',
`dataformatime` bigint(20) NULL COMMENT '',
`queryparsetime` bigint(20) NULL COMMENT '',
`executetime` bigint(20) NULL COMMENT '',
`classname` varchar(255) NULL COMMENT '',
`starttime` datetime NULL COMMENT '',
`endtime` datetime NULL COMMENT '',
`detailtype` varchar(255) NULL COMMENT '',
`url` text NULL COMMENT '',
`reportdic` varchar(255) NULL COMMENT '',
`dataid` varchar(32) NULL COMMENT '',
`dataname` varchar(255) NULL COMMENT '',
`datatype` varchar(32) NULL COMMENT '',
`reportname` varchar(255) NULL COMMENT '',
`ip` varchar(255) NULL COMMENT '',
`hostname` varchar(255) NULL COMMENT '',
`statues` varchar(255) NULL COMMENT '',
`methodname` text NULL COMMENT '',
`linenumber` varchar(255) NULL COMMENT '',
`querytime` int(255) NULL COMMENT '',
`optext` varchar(255) NULL COMMENT '',
`field6` varchar(255) NULL COMMENT '',
`field7` varchar(255) NULL COMMENT '',
`field8` varchar(255) NULL COMMENT '',
`flowid` varchar(32) NULL COMMENT '',
`userid` varchar(255) NULL COMMENT '',
`name` varchar(32) NULL COMMENT '',
`funtype` varchar(32) NULL COMMENT '',
`fundesc` varchar(255) NULL COMMENT '',
`triggerwarning` varchar(32) NULL COMMENT '',
`triggertime` varchar(32) NULL COMMENT '',
`createdate` datetime NULL COMMENT '',
KEY `type` (`type`),
KEY `parameters` (`parameters`),
KEY `throwable` (`throwable`),
KEY `username` (`username`),
KEY `usermail` (`usermail`),
KEY `filename` (`filename`),
KEY `orgi` (`orgi`),
KEY `error` (`error`),
KEY `dataprocesstime` (`dataprocesstime`),
KEY `dataformatime` (`dataformatime`),
KEY `queryparsetime` (`queryparsetime`),
KEY `executetime` (`executetime`),
KEY `classname` (`classname`),
KEY `starttime` (`starttime`),
KEY `endtime` (`endtime`),
KEY `detailtype` (`detailtype`),
KEY `url` (`url`),
KEY `reportdic` (`reportdic`),
KEY `dataid` (`dataid`),
KEY `dataname` (`dataname`),
KEY `datatype` (`datatype`),
KEY `reportname` (`reportname`),
KEY `ip` (`ip`),
KEY `hostname` (`hostname`),
KEY `statues` (`statues`),
KEY `methodname` (`methodname`),
KEY `linenumber` (`linenumber`),
KEY `querytime` (`querytime`),
KEY `optext` (`optext`),
KEY `field6` (`field6`),
KEY `field7` (`field7`),
KEY `field8` (`field8`),
KEY `flowid` (`flowid`),
KEY `userid` (`userid`),
KEY `name` (`name`),
KEY `funtype` (`funtype`),
KEY `fundesc` (`fundesc`),
KEY `triggerwarning` (`triggerwarning`),
KEY `triggertime` (`triggertime`),
KEY `createdate` (`createdate`),
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-40 of 40 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
type | varchar(255) | 是 | ||||
parameters | text | 是 | ||||
throwable | varchar(255) | 是 | ||||
username | varchar(255) | 是 | ||||
usermail | varchar(255) | 是 | ||||
filename | varchar(255) | 是 | ||||
orgi | varchar(255) | 是 | ||||
error | text | 是 | ||||
dataprocesstime | bigint(20) | 是 | ||||
dataformatime | bigint(20) | 是 | ||||
queryparsetime | bigint(20) | 是 | ||||
executetime | bigint(20) | 是 | ||||
classname | varchar(255) | 是 | ||||
starttime | datetime | 是 | ||||
endtime | datetime | 是 | ||||
detailtype | varchar(255) | 是 | ||||
url | text | 是 | ||||
reportdic | varchar(255) | 是 | ||||
dataid | varchar(32) | 是 | ||||
dataname | varchar(255) | 是 | ||||
datatype | varchar(32) | 是 | ||||
reportname | varchar(255) | 是 | ||||
ip | varchar(255) | 是 | ||||
hostname | varchar(255) | 是 | ||||
statues | varchar(255) | 是 | ||||
methodname | text | 是 | ||||
linenumber | varchar(255) | 是 | ||||
querytime | int(255) | 是 | ||||
optext | varchar(255) | 是 | ||||
field6 | varchar(255) | 是 | ||||
field7 | varchar(255) | 是 | ||||
field8 | varchar(255) | 是 | ||||
flowid | varchar(32) | 是 | ||||
userid | varchar(255) | 是 | ||||
name | varchar(32) | 是 | ||||
funtype | varchar(32) | 是 | ||||
fundesc | varchar(255) | 是 | ||||
triggerwarning | varchar(32) | 是 | ||||
triggertime | varchar(32) | 是 | ||||
createdate | datetime | 是 |