Schema authority
HomePrev Chapter 1. Database Schema Next

Schema authority

Table: bib_linking

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
bib : bigint -- NOT NULL, REFERENCES biblio.record_entry.
authority : bigint -- NOT NULL, REFERENCES authority.record_entry.

Indexes: 

authority_bl_bib_idx : bib

Table: browse_axis

Columns: 

field name : datatype -- parameters, contraints and notes
code : text -- PRIMARY KEY,
name : text -- UNIQUE, NOT NULL,
sorter : text -- REFERENCES config.record_attr_definition.
description : text --

Tables referencing authority.browse_axis_authority_field_map via Foreign Key Constraints: 

authority.browse_axis_authority_field_map 

Table: browse_axis_authority_field_map

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
axis : text -- NOT NULL, REFERENCES authority.browse_axis.
field : integer -- NOT NULL, REFERENCES authority.control_set_authority_field.

Table: control_set

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
name : text -- UNIQUE, NOT NULL,
description : text --

Tables referencing authority.control_set_authority_field via Foreign Key Constraints: 

authority.control_set_authority_fieldauthority.record_entry
authority.thesaurus 

Table: control_set_authority_field

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
main_entry : integer -- REFERENCES authority.control_set_authority_field.
control_set : integer -- NOT NULL, REFERENCES authority.control_set.
tag : character(3) -- NOT NULL,
nfi : character(1) --
sf_list : text -- NOT NULL,
name : text -- NOT NULL,
description : text --

Tables referencing authority.browse_axis_authority_field_map via Foreign Key Constraints: 

authority.browse_axis_authority_field_mapauthority.control_set_authority_field
authority.control_set_bib_fieldauthority.simple_heading

Table: control_set_bib_field

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
authority_field : integer -- NOT NULL, REFERENCES authority.control_set_authority_field.
tag : character(3) -- NOT NULL,

Table: full_rec

Columns: 

field name : datatype -- parameters, contraints and notes
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: 

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

Table: rec_descriptor

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
record : bigint --
record_status : text --
encoding_level : text --
thesaurus : text --

Indexes: 

authority_rec_descriptor_record_idx : record

Table: record_entry

Columns: 

field name : datatype -- parameters, contraints and notes
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.control_set.
marc : text -- NOT NULL,
last_xact_id : text -- NOT NULL,
owner : integer --

Indexes: 

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)

Tables referencing authority.bib_linking via Foreign Key Constraints: 

authority.bib_linkingauthority.record_note
authority.simple_headingvandelay.authority_match
vandelay.queued_authority_record 

Table: record_note

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
record : bigint -- NOT NULL, REFERENCES authority.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: 

authority_record_note_creator_idx : creator
authority_record_note_editor_idx : editor
authority_record_note_record_idx : record

Table: simple_heading

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
record : bigint -- NOT NULL, REFERENCES authority.record_entry.
atag : integer -- NOT NULL, REFERENCES authority.control_set_authority_field.
value : text -- NOT NULL,
sort_value : text -- NOT NULL,
index_vector : tsvector -- NOT NULL,

Indexes: 

authority_simple_heading_index_vector_idx : index_vector
authority_simple_heading_sort_value_idx : sort_value
authority_simple_heading_value_idx : value

Table: thesaurus

Columns: 

field name : datatype -- parameters, contraints and notes
code : text -- PRIMARY KEY,
control_set : integer -- NOT NULL, REFERENCES authority.control_set.
name : text -- UNIQUE, NOT NULL,
description : text --

View: tracing_links

Columns: 

field name : datatype -- parameters, contraints and notes
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 --

atag_authority_tags(atag text)

Function Properties
Language: SQL
Return Type: integer[]

atag_authority_tags_refs(atag text)

Function Properties
Language: SQL
Return Type: integer[]

atag_browse_center(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

atag_browse_center_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

atag_browse_top(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

atag_browse_top_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

atag_search_heading(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

atag_search_heading_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

atag_search_rank(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

atag_search_rank_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

axis_authority_tags(a text)

Function Properties
Language: SQL
Return Type: integer[]

axis_authority_tags_refs(a text)

Function Properties
Language: SQL
Return Type: integer[]

axis_browse_center(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

axis_browse_center_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

axis_browse_top(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

axis_browse_top_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

axis_search_heading(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

axis_search_heading_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

axis_search_rank(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

axis_search_rank_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

btag_authority_tags(btag text)

Function Properties
Language: SQL
Return Type: integer[]

btag_authority_tags_refs(btag text)

Function Properties
Language: SQL
Return Type: integer[]

btag_browse_center(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

btag_browse_center_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

btag_browse_top(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

btag_browse_top_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

btag_search_heading(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

btag_search_heading_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

btag_search_rank(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

btag_search_rank_refs(pagesize text, page text, q integer, a integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

flatten_marc(rid bigint)

Function Properties
Language: PLPGSQL
Return Type: SET OF full_rec

generate_overlay_template(bigint)

Function Properties
Language: SQL
Return Type: text

generate_overlay_template(source_xml text)

Function Properties
Language: PLPGSQL
Return Type: text

indexing_ingest_or_delete()

Function Properties
Language: PLPGSQL
Return Type: trigger

map_thesaurus_to_control_set()

Function Properties
Language: PLPGSQL
Return Type: trigger

merge_records(source_record bigint, target_record bigint)

Function Properties
Language: PLPGSQL
Return Type: integer

normalize_heading(marcxml text)

Extract the authority heading, thesaurus, and NACO-normalized values from an authority record. The primary purpose is to build a unique index to defend against duplicated authority records from the same thesaurus.

Function Properties
Language: SQL
Return Type: text

normalize_heading(no_thesaurus text, marcxml boolean)

Function Properties
Language: PLPGSQL
Return Type: text

propagate_changes(aid bigint)

Function Properties
Language: SQL
Return Type: SET OF bigint

propagate_changes(bid bigint, aid bigint)

Function Properties
Language: SQL
Return Type: bigint

reingest_authority_full_rec(auth_id bigint)

Function Properties
Language: PLPGSQL
Return Type: void

reingest_authority_rec_descriptor(auth_id bigint)

Function Properties
Language: PLPGSQL
Return Type: void

simple_heading_browse_center(pagesize integer[], page text, q integer, atag_list integer)

Function Properties
Language: PLPGSQL
Return Type: SET OF bigint

simple_heading_browse_top(pagesize integer[], page text, q integer, atag_list integer)

Function Properties
Language: PLPGSQL
Return Type: SET OF bigint

simple_heading_find_pivot(q integer[], a text)

Function Properties
Language: PLPGSQL
Return Type: text

simple_heading_search_heading(pagesize integer[], page text, q integer, atag_list integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

simple_heading_search_rank(pagesize integer[], page text, q integer, atag_list integer)

Function Properties
Language: SQL
Return Type: SET OF bigint

simple_heading_set(marcxml text)

Function Properties
Language: PLPGSQL
Return Type: SET OF simple_heading

simple_normalize_heading(marcxml text)

Function Properties
Language: SQL
Return Type: text

Prev Up Next
Schema auditor Home Schema biblio

Report any errors in this documentation using Launchpad.
Documentation for Evergreen version 2.2
Copyright © 2007-2012, Memebers of the Evergreen Project