Chapter 7. Schema authority


Home Prev		Next

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