Chapter 14. Schema metabib

Table of Contents

Tables in metabib
Functions in metabib

Below are the tables, views and functions for metabib

Tables in metabib

author_field_entry

  • id bigserial PRIMARY KEY
  • source bigint NOT NULL REFERENCES biblio.table.record-entry
  • field integer NOT NULL REFERENCES config.table.metabib-field
  • value text NOT NULL
  • index_vector tsvector NOT NULL

Indexes on author_field_entry

  • 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

browse_entry

  • id bigserial PRIMARY KEY
  • value text UNIQUE
  • index_vector tsvector

Indexes on browse_entry

  • metabib_browse_entry_index_vector_idx index_vector

Tables referencing via foreign key constraints

browse_entry_def_map

  • id bigserial PRIMARY KEY
  • entry bigint REFERENCES metabib.table.browse-entry
  • def integer REFERENCES config.table.metabib-field
  • source bigint REFERENCES biblio.table.record-entry

Indexes on browse_entry_def_map

  • browse_entry_def_map_def_idx def
  • browse_entry_def_map_entry_idx entry
  • browse_entry_def_map_source_idx source

facet_entry

  • id bigserial PRIMARY KEY
  • source bigint NOT NULL
  • field integer NOT NULL
  • value text NOT NULL

Indexes on facet_entry

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

full_rec

  • id bigint
  • record bigint
  • tag character(3)
  • ind1 text
  • ind2 text
  • subfield text
  • value text
  • index_vector tsvector

identifier_field_entry

  • id bigserial PRIMARY KEY
  • source bigint NOT NULL REFERENCES biblio.table.record-entry
  • field integer NOT NULL REFERENCES config.table.metabib-field
  • value text NOT NULL
  • index_vector tsvector NOT NULL

Indexes on identifier_field_entry

  • 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

keyword_field_entry

  • id bigserial PRIMARY KEY
  • source bigint NOT NULL REFERENCES biblio.table.record-entry
  • field integer NOT NULL REFERENCES config.table.metabib-field
  • value text NOT NULL
  • index_vector tsvector NOT NULL

Indexes on keyword_field_entry

  • 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

metarecord

  • id bigserial PRIMARY KEY
  • fingerprint text NOT NULL
  • master_record bigint REFERENCES biblio.table.record-entry
  • mods text

Indexes on metarecord

  • metabib_metarecord_fingerprint_idx fingerprint
  • metabib_metarecord_master_record_idx master_record

Tables referencing via foreign key constraints

metarecord_source_map

  • id bigserial PRIMARY KEY
  • metarecord bigint NOT NULL REFERENCES metabib.table.metarecord
  • source bigint NOT NULL REFERENCES biblio.table.record-entry

Indexes on metarecord_source_map

  • metabib_metarecord_source_map_metarecord_idx metarecord
  • metabib_metarecord_source_map_source_record_idx source

real_full_rec

  • id bigint PRIMARY KEY DEFAULT nextval('metabib.full_rec_id_seq'::regclass)
  • record bigint NOT NULL REFERENCES biblio.table.record-entry
  • tag character(3) NOT NULL
  • ind1 text
  • ind2 text
  • subfield text
  • value text NOT NULL
  • index_vector tsvector NOT NULL

Indexes on real_full_rec

  • metabib_full_rec_02x_tag_subfield_lower_substring tag, subfield, lower("substring"(value, 1, 1024))) WHERE (tag = ANY (ARRAY['020'::bpchar, '022'::bpchar, '024'::bpchar])
  • metabib_full_rec_index_vector_idx index_vector
  • metabib_full_rec_isxn_caseless_idx lower(value)) WHERE (tag = ANY (ARRAY['020'::bpchar, '022'::bpchar, '024'::bpchar])
  • 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

rec_descriptor

  • id bigint
  • record bigint
  • 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

record_attr

  • id bigint PRIMARY KEY REFERENCES biblio.table.record-entry
  • attrs hstore NOT NULL DEFAULT ''::hstore

Indexes on record_attr

  • metabib_svf_attrs_idx attrs
  • metabib_svf_date1_idx attrs -> 'date1'::text
  • metabib_svf_dates_idx attrs -> 'date1'::text, attrs -> 'date2'::text

series_field_entry

  • id bigserial PRIMARY KEY
  • source bigint NOT NULL REFERENCES biblio.table.record-entry
  • field integer NOT NULL REFERENCES config.table.metabib-field
  • value text NOT NULL
  • index_vector tsvector NOT NULL

Indexes on series_field_entry

  • 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

subject_field_entry

  • id bigserial PRIMARY KEY
  • source bigint NOT NULL REFERENCES biblio.table.record-entry
  • field integer NOT NULL REFERENCES config.table.metabib-field
  • value text NOT NULL
  • index_vector tsvector NOT NULL

Indexes on subject_field_entry

  • 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

title_field_entry

  • id bigserial PRIMARY KEY
  • source bigint NOT NULL REFERENCES biblio.table.record-entry
  • field integer NOT NULL REFERENCES config.table.metabib-field
  • value text NOT NULL
  • index_vector tsvector NOT NULL

Indexes on title_field_entry

  • 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