vandelay.import_item

↑ vandelay schema

Cascading Deletes: Deleting rows from this table will cascade to: vandelay.import_item_attr_definition, vandelay.queued_bib_record.

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('vandelay.import_item_id_seq'::regclass)

record FK

bigint

No

→ vandelay.queued_bib_record(id)

definition FK

bigint

No

→ vandelay.import_item_attr_definition(id)

import_error FK

text

Yes

→ vandelay.import_error(code)

error_detail

text

Yes

imported_as

bigint

Yes

import_time

timestamp with time zone

Yes

owning_lib

integer

Yes

circ_lib

integer

Yes

call_number

text

Yes

copy_number

integer

Yes

status

integer

Yes

location

integer

Yes

circulate

boolean

Yes

deposit

boolean

Yes

deposit_amount

numeric(8,2)

Yes

ref

boolean

Yes

holdable

boolean

Yes

price

numeric(8,2)

Yes

barcode

text

Yes

circ_modifier

text

Yes

circ_as_type

text

Yes

alert_message

text

Yes

pub_note

text

Yes

priv_note

text

Yes

stat_cat_data

text

Yes

parts_data

text

Yes

opac_visible

boolean

Yes

internal_id

bigint

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

definition

vandelay.import_item_attr_definition(id)

CASCADE

NO ACTION

DEFERRED

import_item_definition_fkey

import_error

vandelay.import_error(code)

SET NULL

CASCADE

DEFERRED

import_item_import_error_fkey

record

vandelay.queued_bib_record(id)

CASCADE

NO ACTION

DEFERRED

import_item_record_fkey

Indexes

Index Method Definition

import_item_pkey PK

btree

CREATE UNIQUE INDEX import_item_pkey ON vandelay.import_item USING btree (id)

import_item_record_idx

btree

CREATE INDEX import_item_record_idx ON vandelay.import_item USING btree (record)

Triggers

Trigger Timing Event Level Function

inherit_import_item_imported_as_fkey

AFTER

INSERT OR UPDATE

ROW

evergreen.vandelay_import_item_imported_as_inh_fkey()

Trigger Bodies

inherit_import_item_imported_as_fkey

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

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