Chapter 7. Schema authority

Table of Contents

Tables in authority
authority_linking
bib_linking
browse_axis
browse_axis_authority_field_map
control_set
control_set_auth_field_metabib_field_map_blind_main
control_set_auth_field_metabib_field_map_blind_refs
control_set_auth_field_metabib_field_map_blind_refs_only
control_set_auth_field_metabib_field_map_main
control_set_auth_field_metabib_field_map_refs
control_set_auth_field_metabib_field_map_refs_only
control_set_authority_field
control_set_bib_field
control_set_bib_field_metabib_field_map
full_rec
rec_descriptor
record_entry
record_note
simple_heading
thesaurus
tracing_links
Functions in authority

Below are the tables, views and functions for authority

Tables in authority

authority_linking

  • id bigserial PRIMARY KEY
  • source bigint NOT NULL REFERENCES authority.table.record-entry
  • target bigint NOT NULL REFERENCES authority.table.record-entry
  • field integer NOT NULL REFERENCES authority.table.control-set-authority-field

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

  • 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

Tables referencing via foreign key constraints

  • 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

Tables referencing via foreign key constraints

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

control_set_auth_field_metabib_field_map_blind_main

  • authority_field integer
  • metabib_field integer

control_set_auth_field_metabib_field_map_blind_refs

  • authority_field integer
  • metabib_field integer

control_set_auth_field_metabib_field_map_blind_refs_only

  • authority_field integer
  • metabib_field integer

control_set_auth_field_metabib_field_map_main

  • authority_field integer
  • metabib_field integer

control_set_auth_field_metabib_field_map_refs

  • authority_field integer
  • metabib_field integer

control_set_auth_field_metabib_field_map_refs_only

  • authority_field integer
  • metabib_field integer

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
  • display_sf_list text NOT NULL
  • name text NOT NULL
  • description text
  • joiner text
  • linking_subfield character(1)

Tables referencing via foreign key constraints

  • authority.table.authority-linking
  • 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

Tables referencing via foreign key constraints

  • authority.table.control-set-bib-field-metabib-field-map

control_set_bib_field_metabib_field_map

  • id serial PRIMARY KEY
  • bib_field integer UNIQUE #1 NOT NULL REFERENCES authority.table.control-set-bib-field
  • metabib_field integer UNIQUE #1 NOT NULL REFERENCES config.table.metabib-field

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_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

Indexes on rec_descriptor

  • 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
  • heading text
  • simple_heading text

Indexes on record_entry

  • authority_record_deleted_idx deleted) WHERE ((deleted IS FALSE) OR (deleted = false)
  • authority_record_entry_create_date_idx create_date
  • authority_record_entry_creator_idx creator
  • authority_record_entry_edit_date_idx edit_date
  • authority_record_entry_editor_idx editor
  • by_heading simple_heading) WHERE ((deleted IS FALSE) OR (deleted = false)
  • by_heading_and_thesaurus heading) WHERE ((deleted IS FALSE) OR (deleted = false)

Tables referencing via foreign key constraints

  • authority.table.authority-linking
  • authority.table.bib-linking
  • authority.table.record-note
  • authority.table.simple-heading
  • metabib.table.browse-entry-def-map
  • 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()

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

Tables referencing via foreign key constraints

  • metabib.table.browse-entry-simple-heading-map

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