Schema metabib

Table: author_field_entry

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
source : bigint -- NOT NULL, REFERENCES biblio.record_entry.
field : integer -- NOT NULL, REFERENCES config.metabib_field.
value : text -- NOT NULL,
index_vector : tsvector -- NOT NULL,

Indexes: 

metabib_author_field_entry_index_vector_idx : index_vector
metabib_author_field_entry_source_idx : source
metabib_author_field_entry_value_idx : "substring"(value, 1, 1024)) WHERE ((index_vector)::pg_catalog.tsvector = ((''::pg_catalog.tsvector)::tsvector)::pg_catalog.tsvector

Table: facet_entry

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
source : bigint -- NOT NULL,
field : integer -- NOT NULL,
value : text -- NOT NULL,

Indexes: 

metabib_facet_entry_field_idx : field
metabib_facet_entry_source_idx : source
metabib_facet_entry_value_idx : "substring"(value, 1, 1024)

View: full_rec

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
record : bigint --
tag : character(3) --
ind1 : text --
ind2 : text --
subfield : text --
value : text --
index_vector : tsvector --

Table: identifier_field_entry

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
source : bigint -- NOT NULL, REFERENCES biblio.record_entry.
field : integer -- NOT NULL, REFERENCES config.metabib_field.
value : text -- NOT NULL,
index_vector : tsvector -- NOT NULL,

Indexes: 

metabib_identifier_field_entry_index_vector_idx : index_vector
metabib_identifier_field_entry_source_idx : source
metabib_identifier_field_entry_value_idx : "substring"(value, 1, 1024)) WHERE ((index_vector)::pg_catalog.tsvector = ((''::pg_catalog.tsvector)::tsvector)::pg_catalog.tsvector

Table: keyword_field_entry

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
source : bigint -- NOT NULL, REFERENCES biblio.record_entry.
field : integer -- NOT NULL, REFERENCES config.metabib_field.
value : text -- NOT NULL,
index_vector : tsvector -- NOT NULL,

Indexes: 

metabib_keyword_field_entry_index_vector_idx : index_vector
metabib_keyword_field_entry_source_idx : source
metabib_keyword_field_entry_value_idx : "substring"(value, 1, 1024)) WHERE ((index_vector)::pg_catalog.tsvector = ((''::pg_catalog.tsvector)::tsvector)::pg_catalog.tsvector

Table: metarecord

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
fingerprint : text -- NOT NULL,
master_record : bigint -- REFERENCES biblio.record_entry.
mods : text --

Indexes: 

metabib_metarecord_fingerprint_idx : fingerprint
metabib_metarecord_master_record_idx : master_record

Tables referencing metabib.metarecord_source_map via Foreign Key Constraints: 

metabib.metarecord_source_map 

Table: metarecord_source_map

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
metarecord : bigint -- NOT NULL, REFERENCES metabib.metarecord.
source : bigint -- NOT NULL, REFERENCES biblio.record_entry.

Indexes: 

metabib_metarecord_source_map_metarecord_idx : metarecord
metabib_metarecord_source_map_source_record_idx : source

Table: real_full_rec

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('metabib.full_rec_id_seq'::regclass),
record : bigint -- NOT NULL, REFERENCES biblio.record_entry.
tag : character(3) -- NOT NULL,
ind1 : text --
ind2 : text --
subfield : text --
value : text -- NOT NULL,
index_vector : tsvector -- NOT NULL,

Indexes: 

metabib_full_rec_index_vector_idx : index_vector
metabib_full_rec_record_idx : record
metabib_full_rec_tag_subfield_idx : tag, subfield
metabib_full_rec_value_idx : "substring"(value, 1, 1024)
metabib_full_rec_value_tpo_index : "substring"(value, 1, 1024) text_pattern_ops

Table: rec_descriptor

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
record : bigint -- REFERENCES biblio.record_entry.
item_type : text --
item_form : text --
bib_level : text --
control_type : text --
char_encoding : text --
enc_level : text --
audience : text --
lit_form : text --
type_mat : text --
cat_form : text --
pub_status : text --
item_lang : text --
vr_format : text --
date1 : text --
date2 : text --

Indexes: 

metabib_rec_descriptor_audience_idx : audience
metabib_rec_descriptor_bib_level_idx : bib_level
metabib_rec_descriptor_cat_form_idx : cat_form
metabib_rec_descriptor_char_encoding_idx : char_encoding
metabib_rec_descriptor_control_type_idx : control_type
metabib_rec_descriptor_date1_idx : date1
metabib_rec_descriptor_dates_idx : date1, date2
metabib_rec_descriptor_enc_level_idx : enc_level
metabib_rec_descriptor_item_form_idx : item_form
metabib_rec_descriptor_item_lang_idx : item_lang
metabib_rec_descriptor_item_type_idx : item_type
metabib_rec_descriptor_lit_form_idx : lit_form
metabib_rec_descriptor_pub_status_idx : pub_status
metabib_rec_descriptor_record_idx : record
metabib_rec_descriptor_vr_format_idx : vr_format

Table: series_field_entry

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
source : bigint -- NOT NULL, REFERENCES biblio.record_entry.
field : integer -- NOT NULL, REFERENCES config.metabib_field.
value : text -- NOT NULL,
index_vector : tsvector -- NOT NULL,

Indexes: 

metabib_series_field_entry_index_vector_idx : index_vector
metabib_series_field_entry_source_idx : source
metabib_series_field_entry_value_idx : "substring"(value, 1, 1024)) WHERE ((index_vector)::pg_catalog.tsvector = ((''::pg_catalog.tsvector)::tsvector)::pg_catalog.tsvector

Table: subject_field_entry

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
source : bigint -- NOT NULL, REFERENCES biblio.record_entry.
field : integer -- NOT NULL, REFERENCES config.metabib_field.
value : text -- NOT NULL,
index_vector : tsvector -- NOT NULL,

Indexes: 

metabib_subject_field_entry_index_vector_idx : index_vector
metabib_subject_field_entry_source_idx : source
metabib_subject_field_entry_value_idx : "substring"(value, 1, 1024)) WHERE ((index_vector)::pg_catalog.tsvector = ((''::pg_catalog.tsvector)::tsvector)::pg_catalog.tsvector

Table: title_field_entry

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
source : bigint -- NOT NULL, REFERENCES biblio.record_entry.
field : integer -- NOT NULL, REFERENCES config.metabib_field.
value : text -- NOT NULL,
index_vector : tsvector -- NOT NULL,

Indexes: 

metabib_title_field_entry_index_vector_idx : index_vector
metabib_title_field_entry_source_idx : source
metabib_title_field_entry_value_idx : "substring"(value, 1, 1024)) WHERE ((index_vector)::pg_catalog.tsvector = ((''::pg_catalog.tsvector)::tsvector)::pg_catalog.tsvector

reingest_metabib_field_entries(bib_id bigint)

Function Properties
Language: PLPGSQL
Return Type: void

reingest_metabib_full_rec(bib_id bigint)

Function Properties
Language: PLPGSQL
Return Type: void

reingest_metabib_rec_descriptor(bib_id bigint)

Function Properties
Language: PLPGSQL
Return Type: void

remap_metarecord_for_bib(fp bigint, bib_id text)

Function Properties
Language: PLPGSQL
Return Type: bigint