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;