|
ColumnName |
DataType |
PrimaryKey |
NotNull |
Flags |
Default |
Comment |
|---|---|---|---|---|---|---|
| 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 | ||||
| CiMultiDigAlarmState_AcceptComment | VARCHAR(253) | NN | ||||
| CiMultiDigAlarmState_Accepted | BIT | NN | ||||
| CiMultiDigAlarmState_AcceptTime | TIMESTAMP | NN | ||||
| CiMultiDigAlarmState_AcceptUser | VARCHAR(63) | NN | ||||
| CiMultiDigAlarmState_ActiveSubCondition | VARCHAR(31) | NN | ||||
| CiMultiDigAlarmState_AreaOfInterest | VARCHAR(253) | NN | ||||
| CiMultiDigAlarmState_AreaOfInterestId | INTEGER | NN | ||||
| CiMultiDigAlarmState_CanAccept | BIT | NN | ||||
| CiMultiDigAlarmState_CanDisable | BIT | NN | ||||
| CiMultiDigAlarmState_CanRemove | BIT | NN | ||||
| CiMultiDigAlarmState_CanRespond | BIT | NN | ||||
| CiMultiDigAlarmState_CanUnaccept | BIT | NN | ||||
| CiMultiDigAlarmState_ConditionActiveTime | TIMESTAMP | NN | ||||
| CiMultiDigAlarmState_CondName | VARCHAR(23) | NN | ||||
| CiMultiDigAlarmState_Cookie | INTEGER | NN | ||||
| CiMultiDigAlarmState_CurrSuppressingAlarmId | INTEGER | NN | ||||
| CiMultiDigAlarmState_CurrSuppressingCond | VARCHAR(127) | NN | ||||
| CiMultiDigAlarmState_CurrSuppressingConsDesc | VARCHAR(63) | NN | ||||
| CiMultiDigAlarmState_CurrSuppressingConsType | TINYINT | NN | ||||
| CiMultiDigAlarmState_Disabled | BIT | NN | ||||
| CiMultiDigAlarmState_DisabledBy | VARCHAR(253) | NN | ||||
| CiMultiDigAlarmState_DisabledEndTime | TIMESTAMP | NN | ||||
| CiMultiDigAlarmState_DisableTime | TIMESTAMP | NN | ||||
| CiMultiDigAlarmState_EvtSeqNumberClear | INTEGER | NN | ||||
| CiMultiDigAlarmState_EvtSeqNumberSet | INTEGER | NN | ||||
| CiMultiDigAlarmState_Id | INTEGER | NN | ||||
| CiMultiDigAlarmState_InactiveTime | TIMESTAMP | NN | ||||
| CiMultiDigAlarmState_LastUpdateTime | TIMESTAMP | NN | ||||
| CiMultiDigAlarmState_Message | VARCHAR(253) | NN | ||||
| CiMultiDigAlarmState_OrigSuppressingAlarmId | INTEGER | NN | ||||
| CiMultiDigAlarmState_OrigSuppressingCond | VARCHAR(127) | NN | ||||
| CiMultiDigAlarmState_OrigSuppressingConsDesc | VARCHAR(63) | NN | ||||
| CiMultiDigAlarmState_OrigSuppressingConsType | TINYINT | NN | ||||
| CiMultiDigAlarmState_ReceiptTime | TIMESTAMP | NN | ||||
| CiMultiDigAlarmState_Response | VARCHAR(253) | NN | ||||
| CiMultiDigAlarmState_ResponseTime | TIMESTAMP | NN | ||||
| CiMultiDigAlarmState_ResponseUser | VARCHAR(63) | NN | ||||
| CiMultiDigAlarmState_ResponsibleEntity | VARCHAR(127) | NN | ||||
| CiMultiDigAlarmState_ResponsibleEntityType | TINYINT | NN | ||||
| CiMultiDigAlarmState_Severity | INTEGER | NN | ||||
| CiMultiDigAlarmState_SeverityDesc | VARCHAR(31) | NN | ||||
| CiMultiDigAlarmState_State | INTEGER | NN | ||||
| CiMultiDigAlarmState_StateDesc | VARCHAR(31) | NN | ||||
| CiMultiDigAlarmState_SubConditionActiveTime | TIMESTAMP | NN | ||||
| CiMultiDigAlarmState_SuppressedAlarmCount | INTEGER | NN | ||||
| CiMultiDigAlarmState_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 | ||||
| CurrentStateDesc | VARCHAR(15) | NN | ||||
| CurrentStateIndex | SMALLINT | 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 | ||||
| NoteUser | VARCHAR(63) | NN | ||||
| ObjectLink | INTEGER | NN | ||||
| OffTime | TIMESTAMP | NN | ||||
| OldStateDesc | VARCHAR(15) | NN | ||||
| OldStateIndex | SMALLINT | NN | ||||
| OnTime | TIMESTAMP | NN | ||||
| PagingEnabled | BIT | NN | ||||
| PagingGroup | VARCHAR(80) | NN | ||||
| ParentGroupId | INTEGER | NN | ||||
| ParentGroupName | VARCHAR(254) | NN | ||||
| Priority | SMALLINT | NN | ||||
| Quality | INTEGER | NN | ||||
| ReActivateEnabled | BIT | NN | ||||
| Rights | INTEGER | NN | ||||
| StateDescriptions | VARCHAR(253) | NN | ||||
| StateNumeric | SMALLINT | NN | ||||
| States | VARCHAR(253) | NN | ||||
| StoredDynMetadataFields | INTEGER | NN | ||||
| SummaryRecordId | INTEGER | NN | ||||
| SuppressingAlarmId | INTEGER | NN | ||||
| SuppressingCondition | VARCHAR(127) | NN | ||||
| SuppressingConsType | TINYINT | NN | ||||
| SuppressingConsTypeDesc | VARCHAR(63) | NN | ||||
| SuppressionGroup | SMALLINT | NN | ||||
| SuppressionLevel | SMALLINT | 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 |
IndexName |
Columns |
|---|---|---|
| pkCiMultiStateDigAlarm | Index | Id Id |
| idxId | Index | Id |
| idxParentGroupId | Index | ParentGroupId |
| idxFullName | Index | FullName |
| idxConsParentAlarmObjId | Index | ConsParentAlarmObjId |
| idxCiMultiDigAlarmState_Id | Index | CiMultiDigAlarmState_Id |
See Also
Published June 2018