+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
namevarchar(255)
reporttypevarchar(32)
titlevarchar(255)
orgivarchar(32)
objectcountint(11)
dicidvarchar(32)
createtimetimestampCURRENT_TIMESTAMPCURRENT_TIMESTAMP
descriptionlongtext
htmllongtext
reportpackagevarchar(255)
useaclvarchar(32)
statusvarchar(32)
rolenametext
useridtext
blacklisttext
reportcontenttext
reportmodelvarchar(32)

Guess You Like

MySQL Table Design okayapi_bi_crm_contacts

MySQL Table Design okayapi_bi_account

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_report

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 ↑