Chapter 7. Schema authority

Table of Contents

Tables in authority
Functions in authority

Below are the tables, views and functions for authority

Tables in authority

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

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