|
ColumnName |
DataType |
PrimaryKey |
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_AcceptComment |
VARCHAR(253) |
NN |
|||||
|
CiAdvancedAlarmState_Accepted |
BIT |
NN |
|||||
|
CiAdvancedAlarmState_AcceptTime |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState_AcceptUser |
VARCHAR(63) |
NN |
|||||
|
CiAdvancedAlarmState_ActiveSubCondition |
VARCHAR(31) |
NN |
|||||
|
CiAdvancedAlarmState_AreaOfInterest |
VARCHAR(253) |
NN |
|||||
|
CiAdvancedAlarmState_AreaOfInterestId |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_CanAccept |
BIT |
NN |
|||||
|
CiAdvancedAlarmState_CanDisable |
BIT |
NN |
|||||
|
CiAdvancedAlarmState_CanRemove |
BIT |
NN |
|||||
|
CiAdvancedAlarmState_CanRespond |
BIT |
NN |
|||||
|
CiAdvancedAlarmState_CanUnaccept |
BIT |
NN |
|||||
|
CiAdvancedAlarmState_ConditionActiveTime |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState_CondName |
VARCHAR(23) |
NN |
|||||
|
CiAdvancedAlarmState_Cookie |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_CurrSuppressingAlarmId |
INTEGER |
NN |
|||||
|
CiAdvancedAlarmState_CurrSuppressingCond |
VARCHAR(127) |
NN |
|||||
|
CiAdvancedAlarmState_CurrSuppressingConsDesc |
VARCHAR(63) |
NN |
|||||
|
CiAdvancedAlarmState_CurrSuppressingConsType |
TINYINT |
NN |
|||||
|
CiAdvancedAlarmState_Disabled |
BIT |
NN |
|||||
|
CiAdvancedAlarmState_DisabledBy |
VARCHAR(253) |
NN |
|||||
|
CiAdvancedAlarmState_DisabledEndTime |
TIMESTAMP |
NN |
|||||
|
CiAdvancedAlarmState_DisableTime |
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 Id |
| idxId | Index | Id |
| idxParentGroupId | Index | ParentGroupId |
|
idxFullName |
Index | FullName |
| idxConsParentAlarmObjId | Index | ConsParentAlarmObjId |
| idxCiAdvancedAlarmState_Id | Index | CiAdvancedAlarmState_Id |
See Also
Published June 2018