container.copy_bucket_item

↑ container schema

Cascading Deletes: Deleting rows from this table will cascade to: container.copy_bucket.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('container.copy_bucket_item_id_seq'::regclass)

bucket FK

integer

No

→ container.copy_bucket(id)

target_copy

integer

No

pos

integer

Yes

create_time

timestamp with time zone

No

now()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

bucket

container.copy_bucket(id)

CASCADE

CASCADE

DEFERRED

copy_bucket_item_bucket_fkey

Indexes

Index Method Definition

copy_bucket_item_pkey PK

btree

CREATE UNIQUE INDEX copy_bucket_item_pkey ON container.copy_bucket_item USING btree (id)

copy_bucket_item_bucket_idx

btree

CREATE INDEX copy_bucket_item_bucket_idx ON container.copy_bucket_item USING btree (bucket)

Triggers

Trigger Timing Event Level Function

inherit_copy_bucket_item_target_copy_fkey

AFTER

INSERT OR UPDATE

ROW

evergreen.container_copy_bucket_item_target_copy_inh_fkey()

Trigger Bodies

inherit_copy_bucket_item_target_copy_fkey

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

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

Referenced By

The following tables have foreign keys pointing to container.copy_bucket_item (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

container.copy_bucket_item_note

item

id

copy_bucket_item_note_item_fkey
Previous
Next