bib_linking

• id bigserial PRIMARY KEY
• bib bigint NOT NULL REFERENCES biblio.table.record-entry
• authority bigint NOT NULL REFERENCES authority.table.record-entry

• authority_bl_bib_idx bib

browse_axis

• code text PRIMARY KEY
• name text UNIQUE NOT NULL
• sorter text REFERENCES config.table.record-attr-definition
• description text

• [authority.table.browse-axis-authority-field-map]

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

• [authority.table.control-set-authority-field]
• [authority.table.record-entry]
• [authority.table.thesaurus]

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

• [authority.table.browse-axis-authority-field-map]
• [authority.table.control-set-authority-field]
• [authority.table.control-set-bib-field]
• [authority.table.simple-heading]

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

• authority_full_rec_index_vector_idx index_vector
• 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

• authority_rec_descriptor_record_idx record

record_entry

• id bigserial PRIMARY KEY
• create_date timestamp with time zone NOT NULL DEFAULT now()
• edit_date timestamp with time zone NOT NULL DEFAULT now()
• creator integer NOT NULL DEFAULT 1
• editor integer NOT NULL DEFAULT 1
• active boolean NOT NULL DEFAULT true
• deleted boolean NOT NULL DEFAULT false
• source integer
• control_set integer REFERENCES authority.table.control-set
• marc text NOT NULL
• last_xact_id text NOT NULL
• owner integer

• 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)
• by_heading_and_thesaurus authority.normalize_heading(marc)) WHERE ((deleted IS FALSE) OR (deleted = false)

• [authority.table.bib-linking]
• [authority.table.record-note]
• [authority.table.simple-heading]
• [vandelay.table.authority-match]
• [vandelay.table.queued-authority-record]

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()

• 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

• 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