actor.org_unit_closed

↑ actor schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('actor.org_unit_closed_id_seq'::regclass)
org_unit FK	`integer`	No		→ actor.org_unit(id)
close_start	`timestamp with time zone`	No
close_end	`timestamp with time zone`	No
full_day	`boolean`	No	false
multi_day	`boolean`	No	false
reason	`text`	Yes
emergency_closing FK	`integer`	Yes		→ action.emergency_closing(id)

id PK

integer

nextval('actor.org_unit_closed_id_seq'::regclass)

org_unit FK

integer

→ actor.org_unit(id)

close_start

timestamp with time zone

close_end

timestamp with time zone

full_day

boolean

false

multi_day

boolean

false

reason

text

Yes

emergency_closing FK

integer

Yes

→ action.emergency_closing(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`emergency_closing`	action.emergency_closing(id)	RESTRICT	NO ACTION	DEFERRED	`org_unit_closed_emergency_closing_fkey`
`org_unit`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`org_unit_closed_org_unit_fkey`

emergency_closing

action.emergency_closing(id)

RESTRICT

NO ACTION

DEFERRED

org_unit_closed_emergency_closing_fkey

org_unit

actor.org_unit(id)

NO ACTION

DEFERRED

org_unit_closed_org_unit_fkey

Indexes

Index Method Definition

Index	Method	Definition
`org_unit_closed_pkey` PK	btree	`CREATE UNIQUE INDEX org_unit_closed_pkey ON actor.org_unit_closed USING btree (id)`

org_unit_closed_pkey PK

btree

CREATE UNIQUE INDEX org_unit_closed_pkey ON actor.org_unit_closed USING btree (id)