alarm_action

Logical Entity Name | alarm_action
Default Table Name | alarm_action
Definition | This table is used by alarmact and alarmdist modules. Alarmact makes insertion into the table specifying a specific action for the alarmdist to act on. Alarmdist updates the entry with the status of the action

alarm_action Columns

ColumnName | Domain | Datatype | NULL | Definition
event_id |  | NUMBER(15, 0) | NO |
alarm_action |  | VARCHAR2(15) | NO |
action_state |  | VARCHAR2(15) | NO |
modcount |  | NUMBER(8, 0) | NO |
mod_time |  | DATE | YES |

alarm_action Primary and Unique Keys

Key Name | Key Type | Keys
alarm_actionkey01 | PrimaryKey | event_id, alarm_action, action_state, modcount

alarm_action Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred

alarm_action Check Constraints

Check Constraint Name | CheckConstraint