action.emergency_closing_hold

↑ action schema

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

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('action.emergency_closing_hold_id_seq'::regclass)

emergency_closing FK

integer

No

→ action.emergency_closing(id)

hold FK

integer

No

→ action.hold_request(id)

original_shelf_expire_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

emergency_closing

action.emergency_closing(id)

CASCADE

NO ACTION

DEFERRED

emergency_closing_hold_emergency_closing_fkey

hold

action.hold_request(id)

CASCADE

NO ACTION

DEFERRED

emergency_closing_hold_hold_fkey

Indexes

Index Method Definition

emergency_closing_hold_pkey PK

btree

CREATE UNIQUE INDEX emergency_closing_hold_pkey ON action.emergency_closing_hold USING btree (id)

emergency_closing_hold_emergency_closing_idx

btree

CREATE INDEX emergency_closing_hold_emergency_closing_idx ON action.emergency_closing_hold USING btree (emergency_closing)

emergency_closing_hold_hold_idx

btree

CREATE INDEX emergency_closing_hold_hold_idx ON action.emergency_closing_hold USING btree (hold)
Previous
Next