Attachment 1448402 Details for Bug 1567344 – alarm_events

alarm_events

alarm_events.table.txt (text/plain), 1.55 KB, created by Rupesh Patel on 2018-06-06 18:05:52 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Rupesh Patel

Created: 2018-06-06 18:05:52 UTC

Size: 1.55 KB

patch

obsolete

>*************************** 1. row ***************************
>       Table: alarm_events
>Create Table: CREATE TABLE `alarm_events` (
>  `event_id` int(11) NOT NULL AUTO_INCREMENT,
>  `alarm_id_key` int(11) NOT NULL,
>  `acknowledged` enum('yes','no') COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
>  `certainty` float DEFAULT NULL,
>  `LastAlarmType` char(32) COLLATE latin1_general_ci DEFAULT NULL,
>  `state_change` enum('yes','no') COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
>  `assigned_fault_id` int(11) DEFAULT NULL,
>  `site_index` int(11) DEFAULT NULL,
>  `fault_id` int(11) DEFAULT NULL,
>  `risk_id` int(11) DEFAULT NULL,
>  `damage_id` int(11) DEFAULT NULL,
>  `FromTime` datetime DEFAULT NULL,
>  `ToTime` datetime DEFAULT NULL,
>  `LastTimeRed` datetime DEFAULT NULL,
>  `LastTimeYellow` datetime DEFAULT NULL,
>  `LastTimeBlue` datetime DEFAULT NULL,
>  `CountRed` int(11) DEFAULT NULL,
>  `CountYellow` int(11) DEFAULT NULL,
>  `CountBlue` int(11) DEFAULT NULL,
>  `MeasurementKey` varchar(128) COLLATE latin1_general_ci DEFAULT NULL,
>  `ConditionKey` varchar(128) COLLATE latin1_general_ci DEFAULT NULL,
>  `FaultFreq` double DEFAULT NULL,
>  `FaultIntervalWidth` double DEFAULT NULL,
>  `AlarmType` varchar(32) COLLATE latin1_general_ci DEFAULT NULL,
>  `AckStatus` varchar(10) COLLATE latin1_general_ci DEFAULT NULL,
>  PRIMARY KEY (`event_id`),
>  UNIQUE KEY `event_id` (`event_id`),
>  UNIQUE KEY `remote_primary_idx` (`site_index`,`alarm_id_key`),
>  KEY `assigned_fault_idx` (`assigned_fault_id`)
>) ENGINE=MyISAM AUTO_INCREMENT=126 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

Actions: View

Attachments on bug 1567344: 1448402 | 1448403 | 1448404 | 1448405 | 1448406