actor.org_unit_custom_tree

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('actor.org_unit_custom_tree_id_seq'::regclass)

active

boolean

Yes

false

purpose

actor.org_unit_custom_tree_purpose

No

'opac'::actor.org_unit_custom_tree_purpose

Primary Key

(id)

Unique Constraints

  • org_unit_custom_tree_purpose_key: (purpose)

Indexes

Index Method Definition

org_unit_custom_tree_pkey PK

btree

CREATE UNIQUE INDEX org_unit_custom_tree_pkey ON actor.org_unit_custom_tree USING btree (id)

org_unit_custom_tree_purpose_key UNIQUE

btree

CREATE UNIQUE INDEX org_unit_custom_tree_purpose_key ON actor.org_unit_custom_tree USING btree (purpose)

Referenced By

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

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

actor.org_unit_custom_tree_node

tree

id

org_unit_custom_tree_node_tree_fkey