metabib.metarecord_source_map

↑ metabib schema

Cascading Deletes: Deleting rows from this table will cascade to: metabib.metarecord, biblio.record_entry.

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('metabib.metarecord_source_map_id_seq'::regclass)

metarecord FK

bigint

No

→ metabib.metarecord(id)

source FK

bigint

No

→ biblio.record_entry(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

metarecord

metabib.metarecord(id)

CASCADE

NO ACTION

DEFERRED

metabib_metarecord_source_map_metarecord_fkey

source

biblio.record_entry(id)

CASCADE

NO ACTION

DEFERRED

metabib_metarecord_source_map_source_fkey

Indexes

Index Method Definition

metarecord_source_map_pkey PK

btree

CREATE UNIQUE INDEX metarecord_source_map_pkey ON metabib.metarecord_source_map USING btree (id)

metabib_metarecord_source_map_metarecord_idx

btree

CREATE INDEX metabib_metarecord_source_map_metarecord_idx ON metabib.metarecord_source_map USING btree (metarecord)

metabib_metarecord_source_map_source_record_idx

btree

CREATE INDEX metabib_metarecord_source_map_source_record_idx ON metabib.metarecord_source_map USING btree (source)
Previous
Next