permission.usr_object_perm_map

↑ permission schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.usr.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('permission.usr_object_perm_map_id_seq'::regclass)

usr FK

integer

No

→ actor.usr(id)

perm FK

integer

No

→ permission.perm_list(id)

object_type

text

No

object_id

text

No

grantable

boolean

No

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

perm

permission.perm_list(id)

RESTRICT

CASCADE

DEFERRED

usr_object_perm_map_perm_fkey

usr

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

usr_object_perm_map_usr_fkey

Unique Constraints

  • perm_usr_obj_once: (usr, perm, object_type, object_id)

Indexes

Index Method Definition

usr_object_perm_map_pkey PK

btree

CREATE UNIQUE INDEX usr_object_perm_map_pkey ON permission.usr_object_perm_map USING btree (id)

perm_usr_obj_once UNIQUE

btree

CREATE UNIQUE INDEX perm_usr_obj_once ON permission.usr_object_perm_map USING btree (usr, perm, object_type, object_id)

uopm_usr_idx

btree

CREATE INDEX uopm_usr_idx ON permission.usr_object_perm_map USING btree (usr)
Previous
Next