os_supply_locations

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_locations_hierarchy.ANCESTOR_ID FK_OS_LOC_HIERARCHY_ANCESTORR
os_locations_hierarchy.DESCENDANT_ID FK_OS_LOC_HIERARCHY_DESCR
os_supplies.LOCATION_ID FK_SUPPLY_LOCATIONR
os_supply_locations.PARENT_ID FK_SUPPLY_LOC_PARENTR
NAME VARCHAR 64 null
SITE_ID BIGINT 19 null
catissue_site.IDENTIFIER FK_SUPPLY_LOC_SITER
PARENT_ID BIGINT 19 √ null
os_supply_locations.IDENTIFIER FK_SUPPLY_LOC_PARENTR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SUPPLY_LOC_PARENT Performance Asc PARENT_ID
FK_SUPPLY_LOC_SITE Performance Asc SITE_ID

Relationships

Close relationships within degrees of separation