alertconf_unitgroup


Description

Links an specific alert configuration to the unitgroup that will be subject of alert generation

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idunitgroup int4 10 null
unitgroup.idunitgroup FK_alertconf_unitgroup_unitgroup R
idalertconf int4 10 null
alertconf.idalertconf FK_alertconf_unitgroup_alertconf R
aef_id int4 10 √ null
idbranch int4 10 √ null
branch.idbranch Implied Constraint R
idalertconf_unitgroup serial 10 √ √ nextval('sec_idalertconf_unitgroup'::regclass)

Indexes

Constraint Name Type Sort Column(s)
PK_alertconf_unitgroup Primary key Asc/Asc idunitgroup + idalertconf
idx_alertconf_unitgroup Performance Asc idalertconf

Relationships

Close relationships within degrees of separation