actor.org_unit_custom_tree_node

↑ actor schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.org_unit_custom_tree_node.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: org_unit_custom_tree_node_org_unit_fkey, org_unit_custom_tree_node_parent_node_fkey, org_unit_custom_tree_node_tree_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('actor.org_unit_custom_tree_node_id_seq'::regclass)

tree FK

integer

Yes

→ actor.org_unit_custom_tree(id)

org_unit FK

integer

No

→ actor.org_unit(id)

parent_node FK

integer

Yes

→ actor.org_unit_custom_tree_node(id)

sibling_order

integer

No

0

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

org_unit

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

org_unit_custom_tree_node_org_unit_fkey

parent_node

actor.org_unit_custom_tree_node(id)

CASCADE

NO ACTION

DEFERRED

org_unit_custom_tree_node_parent_node_fkey

tree

actor.org_unit_custom_tree(id)

NO ACTION

NO ACTION

DEFERRED

org_unit_custom_tree_node_tree_fkey

Unique Constraints

  • aouctn_once_per_org: (tree, org_unit)

Indexes

Index Method Definition

org_unit_custom_tree_node_pkey PK

btree

CREATE UNIQUE INDEX org_unit_custom_tree_node_pkey ON actor.org_unit_custom_tree_node USING btree (id)

aouctn_once_per_org UNIQUE

btree

CREATE UNIQUE INDEX aouctn_once_per_org ON actor.org_unit_custom_tree_node USING btree (tree, org_unit)

Referenced By

The following tables have foreign keys pointing to actor.org_unit_custom_tree_node (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

actor.org_unit_custom_tree_node

parent_node

id

org_unit_custom_tree_node_parent_node_fkey
Previous
Next