permission.grp_perm_map

Cascading Deletes: Deleting rows from this table will cascade to: permission.grp_tree.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('permission.grp_perm_map_id_seq'::regclass)
grp FK	`integer`	No		→ permission.grp_tree(id)
perm FK	`integer`	No		→ permission.perm_list(id)
depth	`integer`	No
grantable	`boolean`	No	false

id PK

integer

nextval('permission.grp_perm_map_id_seq'::regclass)

grp FK

integer

→ permission.grp_tree(id)

perm FK

integer

→ permission.perm_list(id)

depth

integer

grantable

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
`grp`	permission.grp_tree(id)	CASCADE	NO ACTION	DEFERRED	`grp_perm_map_grp_fkey`
`perm`	permission.perm_list(id)	RESTRICT	CASCADE	DEFERRED	`grp_perm_map_perm_fkey`

grp

permission.grp_tree(id)

CASCADE

NO ACTION

DEFERRED

grp_perm_map_grp_fkey

perm

permission.perm_list(id)

RESTRICT

CASCADE

DEFERRED

grp_perm_map_perm_fkey

Unique Constraints

perm_grp_once: (grp, perm)

Indexes

Index Method Definition

Index	Method	Definition
`grp_perm_map_pkey` PK	btree	`CREATE UNIQUE INDEX grp_perm_map_pkey ON permission.grp_perm_map USING btree (id)`
`perm_grp_once` UNIQUE	btree	`CREATE UNIQUE INDEX perm_grp_once ON permission.grp_perm_map USING btree (grp, perm)`

grp_perm_map_pkey PK

btree

CREATE UNIQUE INDEX grp_perm_map_pkey ON permission.grp_perm_map USING btree (id)

perm_grp_once UNIQUE

btree

CREATE UNIQUE INDEX perm_grp_once ON permission.grp_perm_map USING btree (grp, perm)