vandelay.import_item_attr_definition

↑ vandelay schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.org_unit.

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('vandelay.import_item_attr_definition_id_seq'::regclass)

owner FK

integer

No

→ actor.org_unit(id)

name

text

No

tag

text

No

keep

boolean

No

false

owning_lib

text

Yes

circ_lib

text

Yes

call_number

text

Yes

copy_number

text

Yes

status

text

Yes

location

text

Yes

circulate

text

Yes

deposit

text

Yes

deposit_amount

text

Yes

ref

text

Yes

holdable

text

Yes

price

text

Yes

barcode

text

Yes

circ_modifier

text

Yes

circ_as_type

text

Yes

alert_message

text

Yes

opac_visible

text

Yes

pub_note_title

text

Yes

pub_note

text

Yes

priv_note_title

text

Yes

priv_note

text

Yes

internal_id

text

Yes

stat_cat_data

text

Yes

parts_data

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

CASCADE

CASCADE

DEFERRED

import_item_attr_definition_owner_fkey

Unique Constraints

  • vand_import_item_attr_def_idx: (owner, name)

Indexes

Index Method Definition

import_item_attr_definition_pkey PK

btree

CREATE UNIQUE INDEX import_item_attr_definition_pkey ON vandelay.import_item_attr_definition USING btree (id)

vand_import_item_attr_def_idx UNIQUE

btree

CREATE UNIQUE INDEX vand_import_item_attr_def_idx ON vandelay.import_item_attr_definition USING btree (owner, name)

Referenced By

The following tables have foreign keys pointing to vandelay.import_item_attr_definition (2 referencing table(s)):

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

vandelay.bib_queue

item_attr_def

id

bib_queue_item_attr_def_fkey

vandelay.import_item

definition

id

import_item_definition_fkey
Previous
Next