Evergreen
HomePrev Chapter 26. Database Schema Next

Schema biblio

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

flatten_marc(text)

Function Properties
Language: PLPERLU
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_fixed_field(ff bigint, rid text)

Function Properties
Language: PLPGSQL
Return Type: text

marc21_physical_characteristics(rid bigint)

Function Properties
Language: PLPGSQL
Return Type: SET OF marc21_physical_characteristics

marc21_record_type(rid bigint)

Function Properties
Language: PLPGSQL
Return Type: marc21_rec_type_map

next_autogen_tcn_value()

Function Properties
Language: PLPGSQL
Return Type: text

Prev Up Next
Schema authority Home Schema booking