action.emergency_closing_circulation

Cascading Deletes: Deleting rows from this table will cascade to: action.circulation, action.emergency_closing.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('action.emergency_closing_circulation_id_seq'::regclass)
emergency_closing FK	`integer`	No		→ action.emergency_closing(id)
circulation FK	`integer`	No		→ action.circulation(id)
original_due_date	`timestamp with time zone`	Yes
process_time	`timestamp with time zone`	Yes

id PK

bigint

nextval('action.emergency_closing_circulation_id_seq'::regclass)

emergency_closing FK

integer

→ action.emergency_closing(id)

circulation FK

integer

→ action.circulation(id)

original_due_date

timestamp with time zone

Yes

process_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
`circulation`	action.circulation(id)	CASCADE	NO ACTION	DEFERRED	`emergency_closing_circulation_circulation_fkey`
`emergency_closing`	action.emergency_closing(id)	CASCADE	NO ACTION	DEFERRED	`emergency_closing_circulation_emergency_closing_fkey`

circulation

action.circulation(id)

CASCADE

NO ACTION

DEFERRED

emergency_closing_circulation_circulation_fkey

emergency_closing

action.emergency_closing(id)

CASCADE

NO ACTION

DEFERRED

emergency_closing_circulation_emergency_closing_fkey

Indexes

Index Method Definition

Index	Method	Definition
`emergency_closing_circulation_pkey` PK	btree	`CREATE UNIQUE INDEX emergency_closing_circulation_pkey ON action.emergency_closing_circulation USING btree (id)`
`emergency_closing_circulation_circulation_idx`	btree	`CREATE INDEX emergency_closing_circulation_circulation_idx ON action.emergency_closing_circulation USING btree (circulation)`
`emergency_closing_circulation_emergency_closing_idx`	btree	`CREATE INDEX emergency_closing_circulation_emergency_closing_idx ON action.emergency_closing_circulation USING btree (emergency_closing)`

emergency_closing_circulation_pkey PK

btree

CREATE UNIQUE INDEX emergency_closing_circulation_pkey ON action.emergency_closing_circulation USING btree (id)

emergency_closing_circulation_circulation_idx

btree

CREATE INDEX emergency_closing_circulation_circulation_idx ON action.emergency_closing_circulation USING btree (circulation)

emergency_closing_circulation_emergency_closing_idx

btree

CREATE INDEX emergency_closing_circulation_emergency_closing_idx ON action.emergency_closing_circulation USING btree (emergency_closing)