 |  | |
| HomePrev | Chapter 26. Database Schema | Next |
|---|---|---|
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 |
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) |
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 -- |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |