alarm_type
EntityType Dependent
Logical Entity Name alarm_type
Default Table Name alarm_type
Definition
Note

alarm_type Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
al_db_site(PK)(FK) CHAR(16) NO
al_db_id(PK)(FK) UNSIGNEDINT NO
al_type_code(PK) UNSIGNEDINT NO
severity_lev_db_site(FK) CHAR(16) NO
severity_lev_db_id(FK) UNSIGNEDINT NO
severity_lev_type_code(FK) UNSIGNEDINT NO
name VARCHAR(254) NO
user_tag_ident VARCHAR(254) YES
gmt_last_updated DATETIME(19:29) YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) UNSIGNEDINT YES
rstat_type_code(FK) SHORT YES

alarm_type Keys
Key Name Key Type Keys
PK__alarm_type__6B24EA82 PrimaryKey al_db_site,al_db_id,al_type_code

alarm_type Relationships
Parent Entity Child Entity Type Foreign Keys
row_status_type alarm_type Non-Identifying rstat_type_code
site_database alarm_type Identifying al_db_site,al_db_id
severity_level_type alarm_type Non-Identifying severity_lev_db_site,severity_lev_db_id,severity_lev_type_code
site_database alarm_type Non-Identifying last_upd_db_site,last_upd_db_id
alarm_type blob_alarm Identifying al_db_site,al_db_idal_type_code,
alarm_type blob_area_alarm Non-Identifying al_db_site,al_db_id,al_type_code
alarm_type mevent_num_alarm Identifying al_db_site,al_db_id,al_type_code
alarm_type mloc_test_alrm_rg Non-Identifying al_db_site,al_db_id,al_type_code
alarm_type num_alarm_reg Non-Identifying al_db_site,al_db_id,al_type_code
alarm_type sp_ampl_alarm Identifying al_db_site,al_db_id,al_type_code
alarm_type spa_alarm_reg Non-Identifying al_db_site,al_db_id,al_type_code
alarm_type test_bres_alarm Identifying al_db_site,al_db_id,al_type_code
alarm_type test_nres_alarm Identifying al_db_site,al_db_id,al_type_code