Chapter 27. Schema vandelay


Home Prev		Next

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.table.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.table.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.table.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

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.table.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.table.import-bib-trash-fields

import_error

code text PRIMARY KEY
description text NOT NULL

Tables referencing via foreign key constraints

vandelay.table.import-item
vandelay.table.queued-authority-record
vandelay.table.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
opac_visible boolean
internal_id bigint

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

Tables referencing via foreign key constraints

vandelay.table.bib-queue
vandelay.table.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.table.match-set-point
vandelay.table.match-set-quality
vandelay.table.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.table.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.table.authority-match
vandelay.table.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.table.lineitem
vandelay.table.bib-match
vandelay.table.import-item
vandelay.table.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