action.curbside

↑ action schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.usr, actor.org_unit, actor.usr, actor.usr.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: curbside_delivery_staff_fkey, curbside_org_fkey, curbside_patron_fkey, curbside_stage_staff_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('action.curbside_id_seq'::regclass)

patron FK

integer

No

→ actor.usr(id)

org FK

integer

No

→ actor.org_unit(id)

slot

timestamp with time zone

Yes

staged

timestamp with time zone

Yes

stage_staff FK

integer

Yes

→ actor.usr(id)

arrival

timestamp with time zone

Yes

delivered

timestamp with time zone

Yes

delivery_staff FK

integer

Yes

→ actor.usr(id)

notes

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

delivery_staff

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

curbside_delivery_staff_fkey

org

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

curbside_org_fkey

patron

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

curbside_patron_fkey

stage_staff

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

curbside_stage_staff_fkey

Indexes

Index Method Definition

curbside_pkey PK

btree

CREATE UNIQUE INDEX curbside_pkey ON action.curbside USING btree (id)
Previous
Next