actor.org_unit_custom_tree

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
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

id PK

integer

nextval('actor.org_unit_custom_tree_id_seq'::regclass)

active

boolean

Yes

false

purpose

actor.org_unit_custom_tree_purpose

'opac'::actor.org_unit_custom_tree_purpose

(id)

Index Method Definition

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)`

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)

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
actor.org_unit_custom_tree_node	`tree`	`id`	`org_unit_custom_tree_node_tree_fkey`

tree

id

org_unit_custom_tree_node_tree_fkey