+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_pinot_merged_anomaly_result_index:/tablelist/okayapi_pinot_merged_anomaly_result_index.html


-- MySQL Table okayapi_pinot_merged_anomaly_result_index
-- From: OkayAPI.com
CREATE TABLE `okayapi_pinot_merged_anomaly_result_index` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `function_id` bigint(20) NULL COMMENT '',
    `detection_config_id` bigint(20) NULL COMMENT '',
    `anomaly_feedback_id` bigint(20) NULL COMMENT '',
    `metric_id` bigint(20) NULL COMMENT '',
    `start_time` bigint(20) NULL COMMENT '',
    `end_time` bigint(20) NULL COMMENT '',
    `collection` varchar(200) NULL COMMENT '',
    `metric` varchar(200) NULL COMMENT '',
    `dimensions` varchar(1023) NULL COMMENT '',
    `notified` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `base_id` bigint(20) NULL COMMENT '',
    `version` int(10) NULL COMMENT '',
    KEY `function_id` (`function_id`),
    KEY `detection_config_id` (`detection_config_id`),
    KEY `anomaly_feedback_id` (`anomaly_feedback_id`),
    KEY `metric_id` (`metric_id`),
    KEY `start_time` (`start_time`),
    KEY `end_time` (`end_time`),
    KEY `collection` (`collection`),
    KEY `metric` (`metric`),
    KEY `dimensions` (`dimensions`),
    KEY `notified` (`notified`),
    KEY `base_id` (`base_id`),
    KEY `version` (`version`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'OLAP存储分析-合并结果';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-12 of 12 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
function_idbigint(20)
detection_config_idbigint(20)
anomaly_feedback_idbigint(20)
metric_idbigint(20)
start_timebigint(20)
end_timebigint(20)
collectionvarchar(200)
metricvarchar(200)
dimensionsvarchar(1023)
notifiedtinyint(1)00
base_idbigint(20)
versionint(10)

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_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_dataset_config_index

TOP ↑