permission.grp_tree

↑ permission schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('permission.grp_tree_id_seq'::regclass)
name	`text`	No
parent FK	`integer`	Yes		→ permission.grp_tree(id)
usergroup	`boolean`	No	true
perm_interval	`interval`	No	'3 years'::interval
description	`text`	Yes
application_perm	`text`	Yes
hold_priority	`integer`	No	0
mfa_allowed	`boolean`	No	false
mfa_required	`boolean`	No	false

id PK

integer

nextval('permission.grp_tree_id_seq'::regclass)

name

text

parent FK

integer

Yes

→ permission.grp_tree(id)

usergroup

boolean

true

perm_interval

interval

'3 years'::interval

description

text

Yes

application_perm

text

Yes

hold_priority

integer

mfa_allowed

boolean

false

mfa_required

boolean

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`parent`	permission.grp_tree(id)	RESTRICT	NO ACTION	DEFERRED	`grp_tree_parent_fkey`

parent

permission.grp_tree(id)

RESTRICT

NO ACTION

DEFERRED

grp_tree_parent_fkey

Unique Constraints

grp_tree_name_key: (name)

Indexes

Index Method Definition

Index	Method	Definition
`grp_tree_pkey` PK	btree	`CREATE UNIQUE INDEX grp_tree_pkey ON permission.grp_tree USING btree (id)`
`grp_tree_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX grp_tree_name_key ON permission.grp_tree USING btree (name)`
`grp_tree_parent_idx`	btree	`CREATE INDEX grp_tree_parent_idx ON permission.grp_tree USING btree (parent)`

grp_tree_pkey PK

btree

CREATE UNIQUE INDEX grp_tree_pkey ON permission.grp_tree USING btree (id)

grp_tree_name_key UNIQUE

btree

CREATE UNIQUE INDEX grp_tree_name_key ON permission.grp_tree USING btree (name)

grp_tree_parent_idx

btree

CREATE INDEX grp_tree_parent_idx ON permission.grp_tree USING btree (parent)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
actor.usr	`profile`	`id`	`actor_usr_profile_fkey`
config.circ_matrix_matchpoint	`grp`	`id`	`circ_matrix_matchpoint_grp_fkey`
config.hold_matrix_matchpoint	`requestor_grp`	`id`	`hold_matrix_matchpoint_requestor_grp_fkey`
config.hold_matrix_matchpoint	`usr_grp`	`id`	`hold_matrix_matchpoint_usr_grp_fkey`
permission.group_mfa_factor_map	`grp`	`id`	`group_mfa_factor_map_grp_fkey`
permission.grp_penalty_threshold	`grp`	`id`	`grp_penalty_threshold_grp_fkey`
permission.grp_perm_map	`grp`	`id`	`grp_perm_map_grp_fkey`
permission.grp_tree	`parent`	`id`	`grp_tree_parent_fkey`
permission.grp_tree_display_entry	`grp`	`id`	`grp_tree_display_entry_grp_fkey`
permission.usr_grp_map	`grp`	`id`	`usr_grp_map_grp_fkey`