metabib.metarecord

↑ metabib schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: metabib_metarecord_master_record_fkey.

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('metabib.metarecord_id_seq'::regclass)

fingerprint

text

No

master_record FK

bigint

Yes

→ biblio.record_entry(id)

mods

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

master_record

biblio.record_entry(id)

NO ACTION

NO ACTION

DEFERRED

metabib_metarecord_master_record_fkey

Indexes

Index Method Definition

metarecord_pkey PK

btree

CREATE UNIQUE INDEX metarecord_pkey ON metabib.metarecord USING btree (id)

metabib_metarecord_fingerprint_idx

btree

CREATE INDEX metabib_metarecord_fingerprint_idx ON metabib.metarecord USING btree (fingerprint)

metabib_metarecord_master_record_idx

btree

CREATE INDEX metabib_metarecord_master_record_idx ON metabib.metarecord USING btree (master_record)

Referenced By

The following tables have foreign keys pointing to metabib.metarecord (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

metabib.metarecord_source_map

metarecord

id

metabib_metarecord_source_map_metarecord_fkey
Previous
Next