action.emergency_closing

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: emergency_closing_creator_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action.emergency_closing_id_seq'::regclass)
creator FK	`integer`	No		→ actor.usr(id)
create_time	`timestamp with time zone`	No	now()
process_start_time	`timestamp with time zone`	Yes
process_end_time	`timestamp with time zone`	Yes
last_update_time	`timestamp with time zone`	Yes

id PK

integer

nextval('action.emergency_closing_id_seq'::regclass)

creator FK

integer

→ actor.usr(id)

create_time

timestamp with time zone

now()

process_start_time

timestamp with time zone

Yes

process_end_time

timestamp with time zone

Yes

last_update_time

timestamp with time zone

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`creator`	actor.usr(id)	CASCADE	NO ACTION	DEFERRED	`emergency_closing_creator_fkey`

creator

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

emergency_closing_creator_fkey

Indexes

Index Method Definition

Index	Method	Definition
`emergency_closing_pkey` PK	btree	`CREATE UNIQUE INDEX emergency_closing_pkey ON action.emergency_closing USING btree (id)`

emergency_closing_pkey PK

btree

CREATE UNIQUE INDEX emergency_closing_pkey ON action.emergency_closing USING btree (id)

Referenced By

The following tables have foreign keys pointing to action.emergency_closing (4 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action.emergency_closing_circulation	`emergency_closing`	`id`	`emergency_closing_circulation_emergency_closing_fkey`
action.emergency_closing_hold	`emergency_closing`	`id`	`emergency_closing_hold_emergency_closing_fkey`
action.emergency_closing_reservation	`emergency_closing`	`id`	`emergency_closing_reservation_emergency_closing_fkey`
actor.org_unit_closed	`emergency_closing`	`id`	`org_unit_closed_emergency_closing_fkey`