action.hold_request_reset_reason_entry

↑ 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_request_reset_reason_entry_hold_fkey, hold_request_reset_reason_entry_requestor_fkey, hold_request_reset_reason_entry_requestor_workstation_fkey, hold_request_reset_reason_entry_reset_reason_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('action.hold_request_reset_reason_entry_id_seq'::regclass)

hold FK

integer

Yes

→ action.hold_request(id)

reset_reason FK

integer

Yes

→ action.hold_request_reset_reason(id)

note

text

Yes

reset_time

timestamp with time zone

Yes

previous_copy

bigint

Yes

requestor FK

integer

Yes

→ actor.usr(id)

requestor_workstation FK

integer

Yes

→ actor.workstation(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

hold

action.hold_request(id)

CASCADE

NO ACTION

DEFERRED

hold_request_reset_reason_entry_hold_fkey

requestor

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

hold_request_reset_reason_entry_requestor_fkey

requestor_workstation

actor.workstation(id)

NO ACTION

NO ACTION

DEFERRED

hold_request_reset_reason_entry_requestor_workstation_fkey

reset_reason

action.hold_request_reset_reason(id)

NO ACTION

NO ACTION

DEFERRED

hold_request_reset_reason_entry_reset_reason_fkey

Indexes

Index Method Definition

hold_request_reset_reason_entry_pkey PK

btree

CREATE UNIQUE INDEX hold_request_reset_reason_entry_pkey ON action.hold_request_reset_reason_entry USING btree (id)

ahrrre_hold_idx

btree

CREATE INDEX ahrrre_hold_idx ON action.hold_request_reset_reason_entry USING btree (hold)

Triggers

Trigger Timing Event Level Function

action_hold_request_reset_reason_entry_previous_copy_trig

AFTER

INSERT OR UPDATE

ROW

evergreen.fake_fkey_tgr()

Trigger Bodies

action_hold_request_reset_reason_entry_previous_copy_trig

Function: evergreen.fake_fkey_tgr()
Timing: AFTER INSERT OR UPDATE ROW

DECLARE
    copy_id BIGINT;
BEGIN
    EXECUTE 'SELECT ($1).' || quote_ident(TG_ARGV[0]) INTO copy_id USING NEW;
    IF copy_id IS NOT NULL THEN
        PERFORM * FROM asset.copy WHERE id = copy_id;
        IF NOT FOUND THEN
            RAISE EXCEPTION 'Key (%.%=%) does not exist in asset.copy', TG_TABLE_SCHEMA, TG_TABLE_NAME, copy_id;
        END IF;
    END IF;
    RETURN NULL;
END;
Previous
Next