CiAdvancedAlarm
- Last UpdatedJul 18, 2023
- 3 minute read
|
ColumnName |
DataType |
Primary |
NotNull |
Flags |
Default Value |
Comment |
AutoInc |
|---|---|---|---|---|---|---|---|
|
Abstract |
BIT |
NN |
|||||
|
AccessControlList |
INTEGER |
NN |
|||||
|
AckTime |
TIMESTAMP |
NN |
|||||
|
ACLAsText |
VARCHAR(253) |
NN |
|||||
|
AcqError |
SMALLINT |
NN |
|||||
|
AlarmArea |
INTEGER |
NN |
|||||
|
AlarmCanDisable |
BIT |
NN |
|||||
|
AlarmCanLocate |
BIT |
NN |
|||||
|
AlarmCanRespond |
BIT |
NN |
|||||
|
AlarmCanUnaccept |
BIT |
NN |
|||||
|
AlarmCategory |
SMALLINT |
NN |
|||||
|
AlarmDesc |
VARCHAR(31) |
NN |
|||||
|
AlarmDisabled |
BIT |
NN |
|||||
|
AlarmEnableConfirm |
TINYINT |
NN |
|||||
|
AlarmHandlerMethod |
INTEGER |
NN |
|||||
|
AlarmHandlerObjectId |
INTEGER |
NN |
|||||
|
AlarmLastUpdateTime |
TIMESTAMP |
NN |
|||||
|
AlarmPrivilege |
SMALLINT |
NN |
|||||
|
AlarmRedirection |
BIT |
NN |
|||||
|
AlarmRemovable |
BIT |
NN |
|||||
|
AlarmSeverity |
SMALLINT |
NN |
|||||
|
AlarmSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
AlarmSource |
INTEGER |
NN |
|||||
|
AlarmSourceValid |
BIT |
NN |
|||||
|
AlarmState |
INTEGER |
NN |
|||||
|
AlarmType |
VARCHAR(23) |
NN |
|||||
|
AlarmViewClass |
VARCHAR(23) |
NN |
|||||
|
AlarmViewId |
INTEGER |
NN |
|||||
|
AlarmViewLink |
INTEGER |
NN |
|||||
|
AlarmViewName |
VARCHAR(254) |
NN |
|||||
|
AlmUnspSeverity |
SMALLINT |
NN |
|||||
|
AlmUnspSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
AlmUnspState |
INTEGER |
NN |
|||||
|
AlmUnspStateDesc |
VARCHAR(31) |
NN |
|||||
|
Background |
INTEGER |
NN |
|||||
|
Blink |
BIT |
NN |
|||||
|
CiAdvancedAlarmState |
VARCHAR(253) |
NN |
|||||
|
CiAdvancedAlarmState |
BIT |
NN |
|||||
|
CiAdvancedAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState |
VARCHAR(63) |
NN |
|||||
|
CiAdvancedAlarmState |
VARCHAR(31) |
NN |
|||||
|
CiAdvancedAlarmState |
VARCHAR(253) |
NN |
|||||
|
CiAdvancedAlarmState |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState |
BIT |
NN |
|||||
|
CiAdvancedAlarmState |
BIT |
NN |
|||||
|
CiAdvancedAlarmState |
BIT |
NN |
|||||
|
CiAdvancedAlarmState |
BIT |
NN |
|||||
|
CiAdvancedAlarmState |
BIT |
NN |
|||||
|
CiAdvancedAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState |
VARCHAR(23) |
NN |
|||||
|
CiAdvancedAlarmState |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState |
VARCHAR(127) |
NN |
|||||
|
CiAdvancedAlarmState |
VARCHAR(63) |
NN |
|||||
|
CiAdvancedAlarmState |
TINYINT |
NN |
|||||
|
CiAdvancedAlarmState |
BIT |
NN |
|||||
|
CiAdvancedAlarmState |
VARCHAR(253) |
NN |
|||||
|
CiAdvancedAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState_EvtSeqNumberClear |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_EvtSeqNumberSet |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_Id |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_InactiveTime |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState_LastUpdateTime |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState_Message |
VARCHAR(253) |
NN |
|||||
|
CiAdvancedAlarmState_OrigSuppressingAlarmId |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_OrigSuppressingCond |
VARCHAR(127) |
NN |
|||||
|
CiAdvancedAlarmState_OrigSuppressingConsDesc |
VARCHAR(63) |
NN |
|||||
|
CiAdvancedAlarmState_OrigSuppressingConsType |
TINYINT |
NN |
|||||
|
CiAdvancedAlarmState_ReceiptTime |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState_Response |
VARCHAR(253) |
NN |
|||||
|
CiAdvancedAlarmState_ResponseTime |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState_ResponseUser |
VARCHAR(63) |
NN |
|||||
|
CiAdvancedAlarmState_ResponsibleEntity |
VARCHAR(127) |
NN |
|||||
|
CiAdvancedAlarmState_ResponsibleEntityType |
TINYINT |
NN |
|||||
|
CiAdvancedAlarmState_Severity |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_SeverityDesc |
VARCHAR(31) |
NN |
|||||
|
CiAdvancedAlarmState_State |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_StateDesc |
VARCHAR(31) |
NN |
|||||
|
CiAdvancedAlarmState_SubConditionActiveTime |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState_SuppressedAlarmCount |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_VisibleTime |
TIMESTAMP |
NN |
|||||
|
ColourPalette |
INTEGER |
NN |
|||||
|
Comment |
VARCHAR(254) |
NN |
|||||
|
ConditionActiveTime |
TIMESTAMP |
NN |
|||||
|
ConfigTime |
TIMESTAMP |
NN |
|||||
|
ConfigUser |
VARCHAR(63) |
NN |
|||||
|
ConfigValid |
BIT |
NN |
|||||
|
ConfigVersion |
INTEGER |
NN |
|||||
|
ConsAlarmsType |
TINYINT |
NN |
|||||
|
ConsAlarmsTypeDesc |
VARCHAR(63) |
NN |
|||||
|
ConsParentAlarmCond |
INTEGER |
NN |
|||||
|
ConsParentAlarmObjId |
INTEGER |
NN |
|||||
|
CustomFilters |
VARCHAR(253) |
NN |
|||||
|
DataTimestamp |
TIMESTAMP |
NN |
|||||
|
Delay |
INTEGER |
NN |
|||||
|
DeltaTime |
INTEGER |
NN |
|||||
|
Description |
VARCHAR(254) |
NN |
|||||
|
DisableTime |
TIMESTAMP |
NN |
|||||
|
DisplayName |
VARCHAR(79) |
NN |
|||||
|
DisplayTime |
TIMESTAMP |
NN |
|||||
|
DocumentContent |
INTEGER |
NN |
|||||
|
Equipment |
VARCHAR(254) |
NN |
|||||
|
ExcludeFromExclCtrl |
BIT |
NN |
|||||
|
ExclusiveCtrlActive |
BIT |
NN |
|||||
|
ExclusiveCtrlUser |
VARCHAR(254) |
NN |
|||||
|
Foreground |
INTEGER |
NN |
|||||
|
FullName |
VARCHAR(254) |
NN |
|||||
|
HelpPage |
VARCHAR(64) |
NN |
|||||
|
HelpViewClass |
VARCHAR(23) |
NN |
|||||
|
HelpViewId |
INTEGER |
NN |
|||||
|
HelpViewLink |
INTEGER |
NN |
|||||
|
HelpViewName |
VARCHAR(254) |
NN |
|||||
|
Historian |
TINYINT |
NN |
|||||
|
Id |
INTEGER |
NN |
|||||
|
InvariantRecordId |
VARCHAR(40) |
NN |
|||||
|
Latched |
BIT |
NN |
|||||
|
MarkerColourBad |
INTEGER |
NN |
|||||
|
MarkerColourGood |
INTEGER |
NN |
|||||
|
MemoryUsage |
INTEGER |
NN |
|||||
|
MobileHelpViewId |
INTEGER |
NN |
|||||
|
Name |
VARCHAR(63) |
NN |
|||||
|
NoteText |
VARCHAR(253) |
NN |
|||||
|
NoteTextLong |
INTEGER |
NN |
|||||
|
NoteTime |
TIMESTAMP |
NN |
|||||
|
ObjectLink |
INTEGER |
NN |
|||||
|
OffTime |
TIMESTAMP |
NN |
|||||
|
OnTime |
TIMESTAMP |
NN |
|||||
|
PagingEnabled |
BIT |
NN |
|||||
|
PagingGroup |
VARCHAR(80) |
NN |
|||||
|
ParentGroupId |
INTEGER |
NN |
|||||
|
ParentGroupName |
VARCHAR(254) |
NN |
|||||
|
Priority |
SMALLINT |
NN |
|||||
|
Quality |
INTEGER |
NN |
|||||
|
Rights |
INTEGER |
NN |
|||||
|
StateNumeric |
SMALLINT |
NN |
|||||
|
StoredDynMetadataFields |
INTEGER |
NN |
|||||
|
SummaryRecordId |
INTEGER |
NN |
|||||
|
SuppressingAlarmId |
INTEGER |
NN |
|||||
|
SuppressingCondition |
VARCHAR(127) |
NN |
|||||
|
SuppressingConsType |
TINYINT |
NN |
|||||
|
SuppressingConsTypeDesc |
VARCHAR(63) |
NN |
|||||
|
TypeDesc |
VARCHAR(63) |
NN |
|||||
|
TypeName |
VARCHAR(63) |
NN |
|||||
|
TypeNum |
SMALLINT |
NN |
|||||
|
UserLocation |
VARCHAR(20) |
NN |
|||||
|
UserMethods |
BIT |
NN |
|||||
|
UsrAlmSeverity |
SMALLINT |
NN |
|||||
|
UsrAlmSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
UsrAlmState |
INTEGER |
NN |
|||||
|
UsrAlmStateDesc |
VARCHAR(31) |
NN |
|||||
|
UsrAlmUnspSeverity |
SMALLINT |
NN |
|||||
|
UsrAlmUnspSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
UsrAlmUnspState |
INTEGER |
NN |
|||||
|
UsrAlmUnspStateDesc |
VARCHAR(31) |
NN |
|||||
|
WSAlmSeverity |
SMALLINT |
NN |
|||||
|
WSAlmSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
WSAlmState |
INTEGER |
NN |
|||||
|
WSAlmStateDesc |
VARCHAR(31) |
NN |
|||||
|
WSAlmUnspSeverity |
SMALLINT |
NN |
|||||
|
WSAlmUnspSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
WSAlmUnspState |
INTEGER |
NN |
|||||
|
WSAlmUnspStateDesc |
VARCHAR(31) |
NN |
|
IndexName |
IndexType |
Columns |
|---|---|---|
|
pkCiAdvancedAlarm |
Index |
Id |
|
idxId |
Index |
Id |
|
idxParentGroupId |
Index |
ParentGroupId |
|
idxFullName |
Index |
FullName |
|
idxConsParentAlarmObjId |
Index |
ConsParentAlarmObjId |
|
idxCiAdvancedAlarmState_Id |
Index |
CiAdvancedAlarmState_Id |