action.emergency_closing_reservation

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

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

Columns

Column Type Nullable Default Notes

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

id PK

bigint

nextval('action.emergency_closing_reservation_id_seq'::regclass)

emergency_closing FK

integer

→ action.emergency_closing(id)

reservation FK

integer

→ booking.reservation(id)

original_end_time

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
`emergency_closing`	action.emergency_closing(id)	CASCADE	NO ACTION	DEFERRED	`emergency_closing_reservation_emergency_closing_fkey`
`reservation`	booking.reservation(id)	CASCADE	NO ACTION	DEFERRED	`emergency_closing_reservation_reservation_fkey`

emergency_closing

action.emergency_closing(id)

CASCADE

NO ACTION

DEFERRED

emergency_closing_reservation_emergency_closing_fkey

reservation

booking.reservation(id)

CASCADE

NO ACTION

DEFERRED

emergency_closing_reservation_reservation_fkey

Indexes

Index Method Definition

Index	Method	Definition
`emergency_closing_reservation_pkey` PK	btree	`CREATE UNIQUE INDEX emergency_closing_reservation_pkey ON action.emergency_closing_reservation USING btree (id)`
`emergency_closing_reservation_emergency_closing_idx`	btree	`CREATE INDEX emergency_closing_reservation_emergency_closing_idx ON action.emergency_closing_reservation USING btree (emergency_closing)`
`emergency_closing_reservation_reservation_idx`	btree	`CREATE INDEX emergency_closing_reservation_reservation_idx ON action.emergency_closing_reservation USING btree (reservation)`

emergency_closing_reservation_pkey PK

btree

CREATE UNIQUE INDEX emergency_closing_reservation_pkey ON action.emergency_closing_reservation USING btree (id)

emergency_closing_reservation_emergency_closing_idx

btree

CREATE INDEX emergency_closing_reservation_emergency_closing_idx ON action.emergency_closing_reservation USING btree (emergency_closing)

emergency_closing_reservation_reservation_idx

btree

CREATE INDEX emergency_closing_reservation_reservation_idx ON action.emergency_closing_reservation USING btree (reservation)