permission.grp_tree_display_entry

↑ permission schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: grp_tree_display_entry_grp_fkey, grp_tree_display_entry_org_fkey, grp_tree_display_entry_parent_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('permission.grp_tree_display_entry_id_seq'::regclass)

position

integer

No

org FK

integer

No

→ actor.org_unit(id)

grp FK

integer

No

→ permission.grp_tree(id)

parent FK

integer

Yes

→ permission.grp_tree_display_entry(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

grp

permission.grp_tree(id)

NO ACTION

NO ACTION

DEFERRED

grp_tree_display_entry_grp_fkey

org

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

grp_tree_display_entry_org_fkey

parent

permission.grp_tree_display_entry(id)

NO ACTION

NO ACTION

DEFERRED

grp_tree_display_entry_parent_fkey

Unique Constraints

  • pgtde_once_per_org: (org, grp)

Indexes

Index Method Definition

grp_tree_display_entry_pkey PK

btree

CREATE UNIQUE INDEX grp_tree_display_entry_pkey ON permission.grp_tree_display_entry USING btree (id)

pgtde_once_per_org UNIQUE

btree

CREATE UNIQUE INDEX pgtde_once_per_org ON permission.grp_tree_display_entry USING btree (org, grp)

Referenced By

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

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

permission.grp_tree_display_entry

parent

id

grp_tree_display_entry_parent_fkey
Previous
Next