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

• [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

• 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

• [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

• 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

• [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]
• [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()

• biblio_record_note_creator_idx creator
• biblio_record_note_editor_idx editor
• biblio_record_note_record_idx record