Chapter 27. Schema vandelay

Table of Contents

Tables in vandelay
authority_attr_definition
authority_match
authority_queue
bib_attr_definition
bib_match
bib_queue
import_bib_trash_fields
import_bib_trash_group
import_error
import_item
import_item_attr_definition
match_set
match_set_point
match_set_quality
merge_profile
queue
queued_authority_record
queued_authority_record_attr
queued_bib_record
queued_bib_record_attr
queued_record
Functions in vandelay

Below are the tables, views and functions for vandelay

Tables in vandelay

authority_attr_definition

  • id serial PRIMARY KEY
  • code text UNIQUE NOT NULL
  • description text
  • xpath text NOT NULL
  • remove text NOT NULL DEFAULT ''::text

Tables referencing via foreign key constraints

  • vandelay.queued_authority_record_attr

authority_match

  • id bigserial PRIMARY KEY
  • queued_record bigint REFERENCES vandelay.table.queued-authority-record
  • eg_record bigint REFERENCES authority.table.record-entry
  • quality integer NOT NULL
  • match_score integer NOT NULL

authority_queue

  • id bigint PRIMARY KEY DEFAULT nextval('vandelay.queue_id_seq'::regclass)
  • owner integer UNIQUE #1 NOT NULL
  • name text UNIQUE #1 NOT NULL
  • complete boolean NOT NULL DEFAULT false
  • match_set integer
  • queue_type vandelay.authority_queue_queue_type UNIQUE #1 NOT NULL DEFAULT 'authority'::vandelay.authority_queue_queue_type

Tables referencing via foreign key constraints

  • vandelay.queued_authority_record

bib_attr_definition

  • id serial PRIMARY KEY
  • code text UNIQUE NOT NULL
  • description text
  • xpath text NOT NULL
  • remove text NOT NULL DEFAULT ''::text

Tables referencing via foreign key constraints

  • vandelay.queued_bib_record_attr

bib_match

  • id bigserial PRIMARY KEY
  • queued_record bigint REFERENCES vandelay.table.queued-bib-record
  • eg_record bigint REFERENCES biblio.table.record-entry
  • quality integer NOT NULL DEFAULT 1
  • match_score integer NOT NULL

Indexes on bib_match

  • bib_match_queued_record_idx queued_record

bib_queue

  • id bigint PRIMARY KEY DEFAULT nextval('vandelay.queue_id_seq'::regclass)
  • owner integer UNIQUE #1 NOT NULL
  • name text UNIQUE #1 NOT NULL
  • complete boolean NOT NULL DEFAULT false
  • match_set integer
  • queue_type vandelay.bib_queue_queue_type UNIQUE #1 NOT NULL DEFAULT 'bib'::vandelay.bib_queue_queue_type
  • item_attr_def bigint REFERENCES vandelay.table.import-item-attr-definition
  • match_bucket integer REFERENCES container.table.biblio-record-entry-bucket

Tables referencing via foreign key constraints

  • vandelay.queued_bib_record

import_bib_trash_fields

  • id bigserial PRIMARY KEY
  • grp integer UNIQUE #1 NOT NULL REFERENCES vandelay.table.import-bib-trash-group
  • field text UNIQUE #1 NOT NULL

import_bib_trash_group

  • id serial PRIMARY KEY
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.org-unit
  • label text UNIQUE #1 NOT NULL
  • always_apply boolean NOT NULL DEFAULT false

Tables referencing via foreign key constraints

  • vandelay.import_bib_trash_fields

import_error

  • code text PRIMARY KEY
  • description text NOT NULL

Tables referencing via foreign key constraints

  • vandelay.import_item
  • vandelay.queued_authority_record
  • vandelay.queued_bib_record

import_item

  • id bigserial PRIMARY KEY
  • record bigint NOT NULL REFERENCES vandelay.table.queued-bib-record
  • definition bigint NOT NULL REFERENCES vandelay.table.import-item-attr-definition
  • import_error text REFERENCES vandelay.table.import-error
  • error_detail text
  • imported_as bigint REFERENCES asset.table.copy
  • import_time timestamp with time zone
  • owning_lib integer
  • circ_lib integer
  • call_number text
  • copy_number integer
  • status integer
  • location integer
  • circulate boolean
  • deposit boolean
  • deposit_amount numeric(8,2)
  • ref boolean
  • holdable boolean
  • price numeric(8,2)
  • barcode text
  • circ_modifier text
  • circ_as_type text
  • alert_message text
  • pub_note text
  • priv_note text
  • stat_cat_data text
  • parts_data text
  • opac_visible boolean
  • internal_id bigint

Indexes on import_item

  • import_item_record_idx record

import_item_attr_definition

  • id bigserial PRIMARY KEY
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.org-unit
  • name text UNIQUE #1 NOT NULL
  • tag text NOT NULL
  • keep boolean NOT NULL DEFAULT false
  • owning_lib text
  • circ_lib text
  • call_number text
  • copy_number text
  • status text
  • location text
  • circulate text
  • deposit text
  • deposit_amount text
  • ref text
  • holdable text
  • price text
  • barcode text
  • circ_modifier text
  • circ_as_type text
  • alert_message text
  • opac_visible text
  • pub_note_title text
  • pub_note text
  • priv_note_title text
  • priv_note text
  • internal_id text
  • stat_cat_data text
  • parts_data text

Tables referencing via foreign key constraints

  • vandelay.bib_queue
  • vandelay.import_item

match_set

  • id serial PRIMARY KEY
  • name text UNIQUE #1 NOT NULL
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.org-unit
  • mtype text UNIQUE #1 NOT NULL DEFAULT 'biblio'::text

Tables referencing via foreign key constraints

  • vandelay.match_set_point
  • vandelay.match_set_quality
  • vandelay.queue

match_set_point

  • id serial PRIMARY KEY
  • match_set integer REFERENCES vandelay.table.match-set
  • parent integer REFERENCES vandelay.table.match-set-point
  • bool_op text
  • svf text REFERENCES config.table.record-attr-definition
  • tag text
  • subfield text
  • negate boolean DEFAULT false
  • quality integer NOT NULL DEFAULT 1
  • heading boolean NOT NULL DEFAULT false

Constraints on match_set_point

  • match_set_point_bool_op_check CHECK
  • vmsp_need_a_subfield_with_a_tag CHECK ((((tag IS NOT NULL) AND (subfield IS NOT NULL)) OR (tag IS NULL)))
  • vmsp_need_a_tag_or_a_ff_or_a_bo CHECK ((((((((tag IS NOT NULL) AND (svf IS NULL)) AND (heading IS FALSE)) AND (bool_op IS NULL)) OR ((((tag IS NULL) AND (svf IS NOT NULL)) AND (heading IS FALSE)) AND (bool_op IS NULL))) OR ((((tag IS NULL) AND (svf IS NULL)) AND (heading IS TRUE)) AND (bool_op IS NULL))) OR ((((tag IS NULL) AND (svf IS NULL)) AND (heading IS FALSE)) AND (bool_op IS NOT NULL))))

Tables referencing via foreign key constraints

  • vandelay.match_set_point

match_set_quality

  • id serial PRIMARY KEY
  • match_set integer NOT NULL REFERENCES vandelay.table.match-set
  • svf text REFERENCES config.table.record-attr-definition
  • tag text
  • subfield text
  • value text NOT NULL
  • quality integer NOT NULL DEFAULT 1

Constraints on match_set_quality

  • vmsq_need_a_subfield_with_a_tag CHECK ((((tag IS NOT NULL) AND (subfield IS NOT NULL)) OR (tag IS NULL)))
  • vmsq_need_a_tag_or_a_ff CHECK ((((tag IS NOT NULL) AND (svf IS NULL)) OR tag IS NULL) AND (svf IS NOT NULL))

merge_profile

  • id bigserial PRIMARY KEY
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.org-unit
  • name text UNIQUE #1 NOT NULL
  • add_spec text
  • replace_spec text
  • strip_spec text
  • preserve_spec text
  • lwm_ratio numeric

Constraints on merge_profile

  • add_replace_strip_or_preserve CHECK ((((preserve_spec IS NOT NULL) OR (replace_spec IS NOT NULL)) OR preserve_spec IS NULL) AND (replace_spec IS NULL))

queue

  • id bigserial PRIMARY KEY
  • owner integer NOT NULL REFERENCES actor.table.usr
  • name text NOT NULL
  • complete boolean NOT NULL DEFAULT false
  • match_set integer REFERENCES vandelay.table.match-set

queued_authority_record

  • id bigint PRIMARY KEY DEFAULT nextval('vandelay.queued_record_id_seq'::regclass)
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • import_time timestamp with time zone
  • purpose text NOT NULL DEFAULT 'import'::text
  • marc text NOT NULL
  • quality integer NOT NULL
  • queue integer NOT NULL REFERENCES vandelay.table.authority-queue
  • imported_as integer REFERENCES authority.table.record-entry
  • import_error text REFERENCES vandelay.table.import-error
  • error_detail text

Constraints on queued_authority_record

  • queued_record_purpose_check CHECK purpose = ANY (ARRAY['import'::text

Indexes on queued_authority_record

  • queued_authority_record_queue_idx queue

Tables referencing via foreign key constraints

  • vandelay.authority_match
  • vandelay.queued_authority_record_attr

queued_authority_record_attr

  • id bigserial PRIMARY KEY
  • record bigint NOT NULL REFERENCES vandelay.table.queued-authority-record
  • field integer NOT NULL REFERENCES vandelay.table.authority-attr-definition
  • attr_value text NOT NULL

Indexes on queued_authority_record_attr

  • queued_authority_record_attr_record_idx record

queued_bib_record

  • id bigint PRIMARY KEY DEFAULT nextval('vandelay.queued_record_id_seq'::regclass)
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • import_time timestamp with time zone
  • purpose text NOT NULL DEFAULT 'import'::text
  • marc text NOT NULL
  • quality integer NOT NULL
  • queue integer NOT NULL REFERENCES vandelay.table.bib-queue
  • bib_source integer REFERENCES config.table.bib-source
  • imported_as bigint REFERENCES biblio.table.record-entry
  • import_error text REFERENCES vandelay.table.import-error
  • error_detail text

Constraints on queued_bib_record

  • queued_record_purpose_check CHECK purpose = ANY (ARRAY['import'::text

Indexes on queued_bib_record

  • queued_bib_record_queue_idx queue

Tables referencing via foreign key constraints

  • acq.lineitem
  • vandelay.bib_match
  • vandelay.import_item
  • vandelay.queued_bib_record_attr

queued_bib_record_attr

  • id bigserial PRIMARY KEY
  • record bigint NOT NULL REFERENCES vandelay.table.queued-bib-record
  • field integer NOT NULL REFERENCES vandelay.table.bib-attr-definition
  • attr_value text NOT NULL

Indexes on queued_bib_record_attr

  • queued_bib_record_attr_record_idx record

queued_record

  • id bigserial PRIMARY KEY
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • import_time timestamp with time zone
  • purpose text NOT NULL DEFAULT 'import'::text
  • marc text NOT NULL
  • quality integer NOT NULL

Constraints on queued_record

  • queued_record_purpose_check CHECK purpose = ANY (ARRAY['import'::text