org_unit_custom_tree_node

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('actor.org_unit_custom_tree_node_id_seq'::regclass)
org_unit_custom_tree_node.parent_node org_unit_custom_tree_node_parent_node_fkey R
tree int4 10 √ null
org_unit_custom_tree.id org_unit_custom_tree_node_tree_fkey R
org_unit int4 10 null
org_unit.id org_unit_custom_tree_node_org_unit_fkey R
parent_node int4 10 √ null
org_unit_custom_tree_node.id org_unit_custom_tree_node_parent_node_fkey R
sibling_order int4 10 0

Indexes

Constraint Name Type Sort Column(s)
org_unit_custom_tree_node_pkey Primary key Asc id
aouctn_once_per_org Must be unique Asc/Asc tree + org_unit

Relationships

Close relationships within degrees of separation