23 lines
958 B
SQL
23 lines
958 B
SQL
CREATE TABLE IF NOT EXISTS `data_alarm_log` (
|
|
`id` bigint(20) NOT NULL,
|
|
`ts` datetime DEFAULT NULL,
|
|
`alarm_value` varchar(20) DEFAULT NULL,
|
|
`level` tinyint(4) DEFAULT NULL,
|
|
`tenant_id` bigint(20) DEFAULT NULL,
|
|
`application_id` bigint(20) DEFAULT NULL,
|
|
`indicator_id` bigint(20) DEFAULT NULL,
|
|
`monitor_point_id` bigint(20) DEFAULT NULL,
|
|
`alarm_key` varchar(20) DEFAULT NULL,
|
|
`alarm_type` tinyint(4) DEFAULT NULL,
|
|
`status` tinyint(4) DEFAULT NULL,
|
|
`alarm_rule_id` bigint(20) DEFAULT NULL,
|
|
`device_id` bigint(20) DEFAULT NULL,
|
|
`whether_push` tinyint(4) DEFAULT NULL,
|
|
`alarm_msg` varchar(128) DEFAULT NULL,
|
|
`alarm_device_type` tinyint(4) DEFAULT NULL,
|
|
`trigger_type` tinyint(4) DEFAULT NULL,
|
|
`alarm_object` tinyint(4) DEFAULT '1',
|
|
`application_ids` varchar(128) DEFAULT NULL,
|
|
`trigger_elements` varchar(128) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |