Chapter 8. Schema biblio

Table of Contents

Tables in biblio
monograph_part
peer_bib_copy_map
peer_type
record_entry
record_note
Functions in biblio

Below are the tables, views and functions for biblio

Tables in biblio

monograph_part

  • id serial PRIMARY KEY
  • record bigint UNIQUE #1 NOT NULL REFERENCES biblio.table.record-entry
  • label text UNIQUE #1 NOT NULL
  • label_sortkey text NOT NULL

Tables referencing via foreign key constraints

  • asset.table.copy-part-map

peer_bib_copy_map

  • id serial PRIMARY KEY
  • peer_type integer NOT NULL REFERENCES biblio.table.peer-type
  • peer_record bigint NOT NULL REFERENCES biblio.table.record-entry
  • target_copy bigint NOT NULL

Indexes on peer_bib_copy_map

  • peer_bib_copy_map_copy_idx target_copy
  • peer_bib_copy_map_record_idx peer_record

peer_type

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL

Tables referencing via foreign key constraints

  • biblio.table.peer-bib-copy-map

record_entry

  • id bigserial PRIMARY KEY
  • creator integer NOT NULL DEFAULT 1 REFERENCES actor.table.usr
  • editor integer NOT NULL DEFAULT 1 REFERENCES actor.table.usr
  • source integer
  • quality integer
  • 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
  • fingerprint text
  • tcn_source text NOT NULL DEFAULT 'AUTOGEN'::text
  • tcn_value text NOT NULL DEFAULT biblio.next_autogen_tcn_value()
  • marc text NOT NULL
  • last_xact_id text NOT NULL
  • owner integer REFERENCES actor.table.org-unit
  • share_depth integer

Indexes on record_entry

  • biblio_record_entry_create_date_idx create_date
  • biblio_record_entry_creator_idx creator
  • biblio_record_entry_edit_date_idx edit_date
  • biblio_record_entry_editor_idx editor
  • biblio_record_entry_fp_idx fingerprint

Tables referencing via foreign key constraints

  • acq.table.lineitem
  • acq.table.user-request
  • asset.table.call-number
  • authority.table.bib-linking
  • biblio.table.monograph-part
  • biblio.table.peer-bib-copy-map
  • biblio.table.record-note
  • booking.table.resource-type
  • container.table.biblio-record-entry-bucket-item
  • metabib.table.author-field-entry
  • metabib.table.browse-entry-def-map
  • metabib.table.identifier-field-entry
  • metabib.table.keyword-field-entry
  • metabib.table.metarecord
  • metabib.table.metarecord-source-map
  • metabib.table.real-full-rec
  • metabib.table.record-attr-vector-list
  • metabib.table.record-sorter
  • metabib.table.series-field-entry
  • metabib.table.subject-field-entry
  • metabib.table.title-field-entry
  • serial.table.record-entry
  • serial.table.subscription
  • vandelay.table.bib-match
  • vandelay.table.queued-bib-record

record_note

  • id bigserial PRIMARY KEY
  • record bigint NOT NULL REFERENCES biblio.table.record-entry
  • value text NOT NULL
  • creator integer NOT NULL DEFAULT 1 REFERENCES actor.table.usr
  • editor integer NOT NULL DEFAULT 1 REFERENCES actor.table.usr
  • pub boolean NOT NULL DEFAULT false
  • create_date timestamp with time zone NOT NULL DEFAULT now()
  • edit_date timestamp with time zone NOT NULL DEFAULT now()

Indexes on record_note

  • biblio_record_note_creator_idx creator
  • biblio_record_note_editor_idx editor
  • biblio_record_note_record_idx record