|
ColumnName |
DataType |
PrimaryKey |
NotNull |
Flags |
Default |
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 | |||||
| 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 | |||||
| NoteUser | VARCHAR(63) | 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 | |||||
| WSAlmUnspStateDesc | VARCHAR(31) | NN |
|
IndexName |
IndexType |
Columns |
|---|---|---|
| pkCAlarmObject | Index | Id
Id |
| idxId | Index | Id |
| idxParentGroupId | Index | ParentGroupId |
| idxFullName | Index | FullName |
| idxConsParentAlarmObjId | Index | ConsParentAlarmObjId |
See Also
Published June 2018