actor.usr_org_unit_opt_in

↑ actor schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: usr_org_unit_opt_in_opt_in_ws_fkey, usr_org_unit_opt_in_org_unit_fkey, usr_org_unit_opt_in_staff_fkey, usr_org_unit_opt_in_usr_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('actor.usr_org_unit_opt_in_id_seq'::regclass)
org_unit FK	`integer`	No		→ actor.org_unit(id)
usr FK	`integer`	No		→ actor.usr(id)
staff FK	`integer`	No		→ actor.usr(id)
opt_in_ts	`timestamp with time zone`	No	now()
opt_in_ws FK	`integer`	No		→ actor.workstation(id)

id PK

integer

nextval('actor.usr_org_unit_opt_in_id_seq'::regclass)

org_unit FK

integer

→ actor.org_unit(id)

usr FK

integer

→ actor.usr(id)

staff FK

integer

→ actor.usr(id)

opt_in_ts

timestamp with time zone

now()

opt_in_ws FK

integer

→ actor.workstation(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`opt_in_ws`	actor.workstation(id)	NO ACTION	NO ACTION	DEFERRED	`usr_org_unit_opt_in_opt_in_ws_fkey`
`org_unit`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`usr_org_unit_opt_in_org_unit_fkey`
`staff`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`usr_org_unit_opt_in_staff_fkey`
`usr`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`usr_org_unit_opt_in_usr_fkey`

opt_in_ws

actor.workstation(id)

NO ACTION

DEFERRED

usr_org_unit_opt_in_opt_in_ws_fkey

org_unit

actor.org_unit(id)

NO ACTION

DEFERRED

usr_org_unit_opt_in_org_unit_fkey

staff

actor.usr(id)

NO ACTION

DEFERRED

usr_org_unit_opt_in_staff_fkey

usr

actor.usr(id)

NO ACTION

DEFERRED

usr_org_unit_opt_in_usr_fkey

Unique Constraints

usr_opt_in_once_per_org_unit: (usr, org_unit)

Indexes

Index Method Definition

Index	Method	Definition
`usr_org_unit_opt_in_pkey` PK	btree	`CREATE UNIQUE INDEX usr_org_unit_opt_in_pkey ON actor.usr_org_unit_opt_in USING btree (id)`
`usr_opt_in_once_per_org_unit` UNIQUE	btree	`CREATE UNIQUE INDEX usr_opt_in_once_per_org_unit ON actor.usr_org_unit_opt_in USING btree (usr, org_unit)`
`usr_org_unit_opt_in_staff_idx`	btree	`CREATE INDEX usr_org_unit_opt_in_staff_idx ON actor.usr_org_unit_opt_in USING btree (staff)`

usr_org_unit_opt_in_pkey PK

btree

CREATE UNIQUE INDEX usr_org_unit_opt_in_pkey ON actor.usr_org_unit_opt_in USING btree (id)

usr_opt_in_once_per_org_unit UNIQUE

btree

CREATE UNIQUE INDEX usr_opt_in_once_per_org_unit ON actor.usr_org_unit_opt_in USING btree (usr, org_unit)

usr_org_unit_opt_in_staff_idx

btree

CREATE INDEX usr_org_unit_opt_in_staff_idx ON actor.usr_org_unit_opt_in USING btree (staff)