+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
typevarchar(255)
parameterstext
throwablevarchar(255)
usernamevarchar(255)
usermailvarchar(255)
filenamevarchar(255)
orgivarchar(255)
errortext
dataprocesstimebigint(20)
dataformatimebigint(20)
queryparsetimebigint(20)
executetimebigint(20)
classnamevarchar(255)
starttimedatetime
endtimedatetime
detailtypevarchar(255)
urltext
reportdicvarchar(255)
dataidvarchar(32)
datanamevarchar(255)
datatypevarchar(32)
reportnamevarchar(255)
ipvarchar(255)
hostnamevarchar(255)
statuesvarchar(255)
methodnametext
linenumbervarchar(255)
querytimeint(255)
optextvarchar(255)
field6varchar(255)
field7varchar(255)
field8varchar(255)
flowidvarchar(32)
useridvarchar(255)
namevarchar(32)
funtypevarchar(32)
fundescvarchar(255)
triggerwarningvarchar(32)
triggertimevarchar(32)
createdatedatetime

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_datasource

MySQL Table Design okayapi_bi_datatable

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 ↑