os_locations_hierarchy

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ANCESTOR_ID BIGINT 19 null
os_supply_locations.IDENTIFIER FK_OS_LOC_HIERARCHY_ANCESTORR
DESCENDANT_ID BIGINT 19 null
os_supply_locations.IDENTIFIER FK_OS_LOC_HIERARCHY_DESCR

Indexes

Constraint Name Type Sort Column(s)
FK_OS_LOC_HIERARCHY_DESC Performance Asc DESCENDANT_ID
OS_SUPPLY_LOC_HIERARCHY_UQ Must be unique Asc/Asc ANCESTOR_ID + DESCENDANT_ID

Relationships

Close relationships within degrees of separation