openapi.perm_set_perm_map

Cascading Deletes: Rows in this table will be automatically deleted when rows are deleted from: permission.perm_list, openapi.perm_set.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('openapi.perm_set_perm_map_id_seq'::regclass)
perm_set FK	`integer`	No		→ openapi.perm_set(id)
perm FK	`integer`	No		→ permission.perm_list(id)

id PK

integer

nextval('openapi.perm_set_perm_map_id_seq'::regclass)

perm_set FK

integer

perm FK

integer

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`perm`	permission.perm_list(id)	CASCADE	CASCADE	No	`perm_set_perm_map_perm_fkey`
`perm_set`	openapi.perm_set(id)	CASCADE	CASCADE	No	`perm_set_perm_map_perm_set_fkey`

perm

CASCADE

perm_set_perm_map_perm_fkey

perm_set

CASCADE

perm_set_perm_map_perm_set_fkey

Index Method Definition

Index	Method	Definition
`perm_set_perm_map_pkey` PK	btree	`CREATE UNIQUE INDEX perm_set_perm_map_pkey ON openapi.perm_set_perm_map USING btree (id)`

perm_set_perm_map_pkey PK

btree

CREATE UNIQUE INDEX perm_set_perm_map_pkey ON openapi.perm_set_perm_map USING btree (id)