Chapter 14. Schema metabib


Home Prev		Next

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 = ''::tsvector

browse_entry

id bigserial PRIMARY KEY
value text UNIQUE #1
index_vector tsvector
sort_value text UNIQUE #1 NOT NULL

Indexes on browse_entry

browse_entry_sort_value_idx sort_value
metabib_browse_entry_index_vector_idx index_vector

Tables referencing via foreign key constraints

metabib.browse_entry_def_map
metabib.browse_entry_simple_heading_map

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
authority bigint REFERENCES authority.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

browse_entry_simple_heading_map

id bigserial PRIMARY KEY
entry bigint REFERENCES metabib.table.browse-entry
simple_heading bigint REFERENCES authority.table.simple-heading

Indexes on browse_entry_simple_heading_map

browse_entry_sh_map_entry_idx entry
browse_entry_sh_map_sh_idx simple_heading

combined_all_field_entry

record bigint
metabib_field integer
index_vector tsvector

combined_author_field_entry

record bigint NOT NULL
metabib_field integer
index_vector tsvector NOT NULL

Indexes on combined_author_field_entry

metabib_combined_author_field_entry_index_vector_idx index_vector
metabib_combined_author_field_source_idx metabib_field

combined_identifier_field_entry

record bigint NOT NULL
metabib_field integer
index_vector tsvector NOT NULL

Indexes on combined_identifier_field_entry

metabib_combined_identifier_field_entry_index_vector_idx index_vector
metabib_combined_identifier_field_source_idx metabib_field

combined_keyword_field_entry

record bigint NOT NULL
metabib_field integer
index_vector tsvector NOT NULL

Indexes on combined_keyword_field_entry

metabib_combined_keyword_field_entry_index_vector_idx index_vector
metabib_combined_keyword_field_source_idx metabib_field

combined_series_field_entry

record bigint NOT NULL
metabib_field integer
index_vector tsvector NOT NULL

Indexes on combined_series_field_entry

metabib_combined_series_field_entry_index_vector_idx index_vector
metabib_combined_series_field_source_idx metabib_field

combined_subject_field_entry

record bigint NOT NULL
metabib_field integer
index_vector tsvector NOT NULL

Indexes on combined_subject_field_entry

metabib_combined_subject_field_entry_index_vector_idx index_vector
metabib_combined_subject_field_source_idx metabib_field

combined_title_field_entry

record bigint NOT NULL
metabib_field integer
index_vector tsvector NOT NULL

Indexes on combined_title_field_entry

metabib_combined_title_field_entry_index_vector_idx index_vector
metabib_combined_title_field_source_idx metabib_field

composite_attr_id_map

id integer
attr text
value text

compressed_display_entry

source bigint
name text
multi boolean
label text
field integer
value json

display_entry

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

Indexes on display_entry

metabib_display_entry_field_idx field
metabib_display_entry_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)

flat_display_entry

source bigint
name text
multi boolean
label text
field integer
value text

full_attr_id_map

id bigint
attr text
value text

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 = ''::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 = ''::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

metabib.metarecord_source_map

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
attrs hstore

record_attr_flat

id bigint
attr text
value text

record_attr_id_map

id bigint
attr text
value text

record_attr_vector_list

source bigint PRIMARY KEY REFERENCES biblio.table.record-entry
vlist integer[] NOT NULL

Indexes on record_attr_vector_list

mrca_vlist_idx vlist gin__int_ops

record_sorter

id bigserial PRIMARY KEY
source bigint NOT NULL REFERENCES biblio.table.record-entry
attr text NOT NULL REFERENCES config.table.record-attr-definition
value text NOT NULL

Indexes on record_sorter

metabib_sorter_a_v_idx attr, value
metabib_sorter_s_a_idx source, attr
metabib_sorter_source_idx source

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 = ''::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 = ''::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 = ''::tsvector

uncontrolled_record_attr_value

id bigint PRIMARY KEY DEFAULT nextval('metabib.uncontrolled_record_attr_value_id_seq'::regclass)
attr text NOT NULL REFERENCES config.table.record-attr-definition
value text NOT NULL

wide_display_entry

source bigint
title text
author text
subject_geographic text
subject_name text
subject_temporal text
subject_topic text
creators text
isbn text
issn text
upc text
tcn text
edition text
physical_description text
publisher text
series_title text
abstract text
toc text
pubdate text
type_of_resource text

Prev		Next
Chapter 13. Schema extend_reporter	Home	Functions in metabib