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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
function_id | bigint(20) | 是 | ||||
detection_config_id | bigint(20) | 是 | ||||
anomaly_feedback_id | bigint(20) | 是 | ||||
metric_id | bigint(20) | 是 | ||||
start_time | bigint(20) | 否 | ||||
end_time | bigint(20) | 否 | ||||
collection | varchar(200) | 是 | ||||
metric | varchar(200) | 是 | ||||
dimensions | varchar(1023) | 是 | ||||
notified | tinyint(1) | 0 | 是 | 0 | ||
base_id | bigint(20) | 否 | ||||
version | int(10) | 是 |