unitgroup


Description

Traceable units grouped together by name

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idunitgroup int4 10 null
_iddefaultgroup.idunitgroup Implied Constraint R
alertconf_unitgroup.idunitgroup FK_alertconf_unitgroup_unitgroup R
coverage_unitgroup.idunitgroup FK_coverage_unitgroup_unitgroup C
mvw_shipperconf.idunitgroup Implied Constraint R
report_unitgroup.idunitgroup fk_report_unitgroup_idunitgroup R
shipperconf_unitgroup.idunitgoup FK_sharedview_unitgroup_unitgroup R
unit_unitgroup.idunitgroup FK_unit_unitgroup_unitgroup R
vw_shared_units.idunitgroup Implied Constraint R
vw_shipperconf.idunitgroup Implied Constraint R
vw_shipperconf_all.idunitgroup Implied Constraint R
vw_shipperconf_extended.idunitgroup Implied Constraint R
vw_shipperconf_extended_all.owner_idunitgroup Implied Constraint R
vw_shipperconf_extended_all.shipper_idunitgroup Implied Constraint R
idclient int4 10 null
client.idclient FK_unitgroup_client R
alias varchar 50 null
description varchar 100 √ null
createbyuser int4 10 null
creationdate timestamp 29,6 null
lastmodifiedbyuser int4 10 null
lastmodificationdate timestamp 29,6 null
originatingsystem varchar 50 null
enabled bool 1 true
aef_id int4 10 √ null
idbranch int4 10 √ null
branch.idbranch Implied Constraint R
default_unitgroup bool 1 √ true

Indexes

Constraint Name Type Sort Column(s)
PK_idunitgroup Primary key Asc idunitgroup
idx_unitgroup Performance Asc idclient
UQ_unitgroup_idunitgroup Must be unique Asc idunitgroup

Relationships

Close relationships within degrees of separation