Chapter 28. 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.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
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
update_bib_source boolean NOT NULL DEFAULT false
lwm_ratio numeric

Constraints on merge_profile

add_replace_strip_or_preserve CHECK

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