action.hold_notification

↑ action schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('action.hold_notification_id_seq'::regclass)

hold FK

integer

No

→ action.hold_request(id)

notify_staff FK

integer

Yes

→ actor.usr(id)

notify_time

timestamp with time zone

No

now()

method

text

No

note

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

hold

action.hold_request(id)

CASCADE

NO ACTION

DEFERRED

hold_notification_hold_fkey

notify_staff

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

hold_notification_notify_staff_fkey

Indexes

Index Method Definition

hold_notification_pkey PK

btree

CREATE UNIQUE INDEX hold_notification_pkey ON action.hold_notification USING btree (id)

ahn_hold_idx

btree

CREATE INDEX ahn_hold_idx ON action.hold_notification USING btree (hold)

ahn_notify_staff_idx

btree

CREATE INDEX ahn_notify_staff_idx ON action.hold_notification USING btree (notify_staff)
Previous
Next