permission.usr_work_ou_map

↑ permission schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('permission.usr_work_ou_map_id_seq'::regclass)

usr FK

integer

No

→ actor.usr(id)

work_ou FK

integer

No

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

usr

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

usr_work_ou_map_usr_fkey

work_ou

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

usr_work_ou_map_work_ou_fkey

Unique Constraints

  • usr_work_ou_once: (usr, work_ou)

Indexes

Index Method Definition

usr_work_ou_map_pkey PK

btree

CREATE UNIQUE INDEX usr_work_ou_map_pkey ON permission.usr_work_ou_map USING btree (id)

usr_work_ou_once UNIQUE

btree

CREATE UNIQUE INDEX usr_work_ou_once ON permission.usr_work_ou_map USING btree (usr, work_ou)
Previous
Next