 |  | |
| HomePrev | Chapter 26. Database Schema | Next |
|---|---|---|
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 |
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_tag_part_idx : "substring"((tag)::text, 2) |
| authority_full_rec_tag_subfield_idx : tag, subfield |
| authority_full_rec_value_tpo_index : value text_pattern_ops |
Columns:
| field name : datatype -- parameters, contraints and notes |
id : bigserial
--
PRIMARY KEY,
|
| record : bigint -- |
| record_status : text -- |
| char_encoding : text -- |
Indexes:
| authority_rec_descriptor_record_idx : record |
Columns:
| field name : datatype -- parameters, contraints and notes |
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 -- |
Indexes:
| authority_record_entry_creator_idx : creator |
| authority_record_entry_editor_idx : editor |
| 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_linking | authority.record_note |
| vandelay.authority_match | vandelay.queued_authority_record |
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 |
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 -- |
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.