asset.copy_note

↑ asset schema

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('asset.copy_note_id_seq'::regclass)

owning_copy

bigint

No

creator FK

bigint

No

→ actor.usr(id)

create_date

timestamp with time zone

Yes

now()

pub

boolean

No

false

title

text

No

value

text

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

creator

actor.usr(id)

SET NULL

NO ACTION

DEFERRED

asset_copy_note_creator_fkey

Indexes

Index Method Definition

copy_note_pkey PK

btree

CREATE UNIQUE INDEX copy_note_pkey ON asset.copy_note USING btree (id)

asset_copy_note_creator_idx

btree

CREATE INDEX asset_copy_note_creator_idx ON asset.copy_note USING btree (creator)

asset_copy_note_owning_copy_idx

btree

CREATE INDEX asset_copy_note_owning_copy_idx ON asset.copy_note USING btree (owning_copy)

Triggers

Trigger Timing Event Level Function

inherit_asset_copy_note_copy_fkey

AFTER

INSERT OR UPDATE

ROW

evergreen.asset_copy_note_owning_copy_inh_fkey()

Trigger Bodies

inherit_asset_copy_note_copy_fkey

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

BEGIN
        PERFORM 1 FROM asset.copy WHERE id = NEW.owning_copy;
        IF NOT FOUND THEN
                RAISE foreign_key_violation USING MESSAGE = FORMAT(
                        $$Referenced asset.copy id not found, owning_copy:%s$$, NEW.owning_copy
                );
        END IF;
        RETURN NEW;
END;
Previous
Next