Schema biblio
HomePrev Chapter 1. Database Schema Next

Schema biblio

Table: monograph_part

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
record : bigint -- UNIQUE#1, NOT NULL, REFERENCES biblio.record_entry.
label : text -- UNIQUE#1, NOT NULL,
label_sortkey : text -- NOT NULL,

Tables referencing asset.copy_part_map via Foreign Key Constraints: 

asset.copy_part_map 

Table: peer_bib_copy_map

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
peer_type : integer -- NOT NULL, REFERENCES biblio.peer_type.
peer_record : bigint -- NOT NULL, REFERENCES biblio.record_entry.
target_copy : bigint -- NOT NULL,

Indexes: 

peer_bib_copy_map_copy_idx : target_copy
peer_bib_copy_map_record_idx : peer_record

Table: peer_type

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
name : text -- UNIQUE, NOT NULL,

Tables referencing biblio.peer_bib_copy_map via Foreign Key Constraints: 

biblio.peer_bib_copy_map 

Table: record_entry

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
creator : integer -- NOT NULL, DEFAULT 1, REFERENCES actor.usr.
editor : integer -- NOT NULL, DEFAULT 1, REFERENCES actor.usr.
source : integer --
quality : integer --
create_date : timestamp with time zone -- NOT NULL, DEFAULT now(),
edit_date : timestamp with time zone -- NOT NULL, DEFAULT now(),
active : boolean -- NOT NULL, DEFAULT true,
deleted : boolean -- NOT NULL, DEFAULT false,
fingerprint : text --
tcn_source : text -- NOT NULL, DEFAULT 'AUTOGEN'::text,
tcn_value : text -- NOT NULL, DEFAULT biblio.next_autogen_tcn_value(),
marc : text -- NOT NULL,
last_xact_id : text -- NOT NULL,
owner : integer -- REFERENCES actor.org_unit.
share_depth : integer --

Indexes: 

biblio_record_entry_create_date_idx : create_date
biblio_record_entry_creator_idx : creator
biblio_record_entry_edit_date_idx : edit_date
biblio_record_entry_editor_idx : editor
biblio_record_entry_fp_idx : fingerprint

Tables referencing acq.lineitem via Foreign Key Constraints: 

acq.lineitemacq.user_request
asset.call_numberauthority.bib_linking
biblio.monograph_partbiblio.peer_bib_copy_map
biblio.record_notebooking.resource_type
container.biblio_record_entry_bucket_itemmetabib.author_field_entry
metabib.identifier_field_entrymetabib.keyword_field_entry
metabib.metarecordmetabib.metarecord_source_map
metabib.real_full_recmetabib.record_attr
metabib.series_field_entrymetabib.subject_field_entry
metabib.title_field_entryserial.record_entry
serial.subscriptionvandelay.bib_match
vandelay.queued_bib_record 

Table: record_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
record : bigint -- NOT NULL, REFERENCES biblio.record_entry.
value : text -- NOT NULL,
creator : integer -- NOT NULL, DEFAULT 1, REFERENCES actor.usr.
editor : integer -- NOT NULL, DEFAULT 1, REFERENCES actor.usr.
pub : boolean -- NOT NULL, DEFAULT false,
create_date : timestamp with time zone -- NOT NULL, DEFAULT now(),
edit_date : timestamp with time zone -- NOT NULL, DEFAULT now(),

Indexes: 

biblio_record_note_creator_idx : creator
biblio_record_note_editor_idx : editor
biblio_record_note_record_idx : record

check_marcxml_well_formed()

Function Properties
Language: PLPGSQL
Return Type: trigger

extract_fingerprint(marc text)

Function Properties
Language: PLPGSQL
Return Type: text

extract_located_uris(editor_id bigint, marcxml text, bib_id integer)

Function Properties
Language: PLPGSQL
Return Type: void

extract_metabib_field_entry(bigint)

Function Properties
Language: SQL
Return Type: SET OF field_entry_template

extract_metabib_field_entry(default_joiner bigint, rid text)

Function Properties
Language: PLPGSQL
Return Type: SET OF field_entry_template

extract_quality(best_type text, best_lang text, marc text)

Function Properties
Language: PLPGSQL
Return Type: integer

fingerprint_trigger()

Function Properties
Language: PLPGSQL
Return Type: trigger

flatten_marc(rid bigint)

Function Properties
Language: PLPGSQL
Return Type: SET OF full_rec

indexing_ingest_or_delete()

Function Properties
Language: PLPGSQL
Return Type: trigger

map_authority_linking(marc bigint, bibid text)

Function Properties
Language: SQL
Return Type: bigint

marc21_extract_all_fixed_fields(rid bigint)

Function Properties
Language: SQL
Return Type: SET OF record_ff_map

marc21_extract_fixed_field(ff bigint, rid text)

Function Properties
Language: SQL
Return Type: text

marc21_physical_characteristics(rid bigint)

Function Properties
Language: SQL
Return Type: SET OF marc21_physical_characteristics

marc21_record_type(rid bigint)

Function Properties
Language: SQL
Return Type: marc21_rec_type_map

next_autogen_tcn_value()

Function Properties
Language: PLPGSQL
Return Type: text

normalize_biblio_monograph_part_sortkey()

Function Properties
Language: PLPGSQL
Return Type: trigger

Prev Up Next
Schema authority Home Schema booking

Report any errors in this documentation using Launchpad.
Documentation for Evergreen version 2.2
Copyright © 2007-2012, Memebers of the Evergreen Project