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
  • deleted boolean NOT NULL DEFAULT false

Tables referencing via foreign key constraints

  • asset.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.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.lineitem
  • acq.user_request
  • asset.call_number
  • authority.bib_linking
  • biblio.monograph_part
  • biblio.peer_bib_copy_map
  • biblio.record_note
  • booking.resource_type
  • container.biblio_record_entry_bucket_item
  • metabib.author_field_entry
  • metabib.browse_entry_def_map
  • metabib.identifier_field_entry
  • metabib.keyword_field_entry
  • metabib.metarecord
  • metabib.metarecord_source_map
  • metabib.real_full_rec
  • metabib.record_attr_vector_list
  • metabib.record_sorter
  • metabib.series_field_entry
  • metabib.subject_field_entry
  • metabib.title_field_entry
  • serial.record_entry
  • serial.subscription
  • vandelay.bib_match
  • vandelay.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