bib_linking
-
id bigserial PRIMARY KEY
-
bib bigint NOT NULL REFERENCES biblio.table.record-entry
-
authority bigint NOT NULL REFERENCES authority.table.record-entry
Indexes on bib_linking
browse_axis
-
code text PRIMARY KEY
-
name text UNIQUE NOT NULL
-
sorter text REFERENCES config.table.record-attr-definition
-
description text
Tables referencing via foreign key constraints
browse_axis_authority_field_map
-
id serial PRIMARY KEY
-
axis text NOT NULL REFERENCES authority.table.browse-axis
-
field integer NOT NULL REFERENCES authority.table.control-set-authority-field
control_set
-
id serial PRIMARY KEY
-
name text UNIQUE NOT NULL
-
description text
Tables referencing via foreign key constraints
control_set_authority_field
-
id serial PRIMARY KEY
-
main_entry integer REFERENCES authority.table.control-set-authority-field
-
control_set integer NOT NULL REFERENCES authority.table.control-set
-
tag character(3) NOT NULL
-
nfi character(1)
-
sf_list text NOT NULL
-
name text NOT NULL
-
description text
Tables referencing via foreign key constraints
control_set_bib_field
-
id serial PRIMARY KEY
-
authority_field integer NOT NULL REFERENCES authority.table.control-set-authority-field
-
tag character(3) NOT NULL
full_rec
-
id bigserial PRIMARY KEY
-
record bigint NOT NULL
-
tag character(3) NOT NULL
-
ind1 text
-
ind2 text
-
subfield text
-
value text NOT NULL
-
index_vector tsvector NOT NULL
Indexes on full_rec
-
authority_full_rec_record_idx record
-
authority_full_rec_subfield_a_idx value) WHERE (subfield = 'a'::text
-
authority_full_rec_tag_part_idx "substring"((tag)::text, 2)
-
authority_full_rec_tag_subfield_idx tag, subfield
-
authority_full_rec_value_index value
-
authority_full_rec_value_tpo_index value text_pattern_ops
rec_descriptor
-
id bigserial PRIMARY KEY
-
record bigint
-
record_status text
-
encoding_level text
-
thesaurus text
Indexes on rec_descriptor
-
authority_rec_descriptor_record_idx record
record_entry
-
id bigserial PRIMARY KEY
-
creator integer NOT NULL DEFAULT 1
-
editor integer NOT NULL DEFAULT 1
-
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
-
source integer
-
marc text NOT NULL
-
last_xact_id text NOT NULL
-
owner integer
-
control_set integer REFERENCES authority.table.control-set
Indexes on record_entry
-
authority_record_deleted_idx deleted) WHERE ((deleted IS FALSE) OR (deleted = false)
-
authority_record_entry_creator_idx creator
-
authority_record_entry_editor_idx editor
-
by_heading authority.simple_normalize_heading(marc)) WHERE ((deleted IS FALSE) OR (deleted = false)
Tables referencing via foreign key constraints
record_note
-
id bigserial PRIMARY KEY
-
record bigint NOT NULL REFERENCES authority.table.record-entry
-
value text NOT NULL
-
creator integer NOT NULL DEFAULT 1
-
editor integer NOT NULL DEFAULT 1
-
create_date timestamp with time zone NOT NULL DEFAULT now()
-
edit_date timestamp with time zone NOT NULL DEFAULT now()
Indexes on record_note
-
authority_record_note_creator_idx creator
-
authority_record_note_editor_idx editor
-
authority_record_note_record_idx record
simple_heading
-
id bigserial PRIMARY KEY
-
record bigint NOT NULL REFERENCES authority.table.record-entry
-
atag integer NOT NULL REFERENCES authority.table.control-set-authority-field
-
value text NOT NULL
-
sort_value text NOT NULL
-
index_vector tsvector NOT NULL
Indexes on simple_heading
-
authority_simple_heading_index_vector_idx index_vector
-
authority_simple_heading_sort_value_idx sort_value
-
authority_simple_heading_value_idx value
thesaurus
-
code text PRIMARY KEY
-
control_set integer REFERENCES authority.table.control-set
-
name text UNIQUE NOT NULL
-
description text
tracing_links
-
record bigint
-
main_id bigint
-
main_tag character(3)
-
main_value text
-
relationship text
-
use_restriction text
-
deprecation text
-
display_restriction text
-
link_id bigint
-
link_tag character(3)
-
link_value text
-
normalized_main_value text
