os_pvs_hierarchy

10423 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ANCESTOR_ID BIGINT 19 null
catissue_permissible_value.identifier FK_PV_HIERARCHY_ANCESTORR
DESCENDANT_ID BIGINT 19 null
catissue_permissible_value.identifier FK_PV_HIERARCHY_DESCENDANTR

Indexes

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

Relationships

Close relationships within degrees of separation