vandelay.bib_match

↑ vandelay schema

Cascading Deletes: Rows in this table will be automatically deleted when rows are deleted from: biblio.record_entry, vandelay.queued_bib_record.

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

Written by External Triggers: This table can receive writes triggered by operations on other tables:

zz_match_bibs_trigger on vandelay.queued_bib_record → INSERT into this table

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('vandelay.bib_match_id_seq'::regclass)
queued_record FK	`bigint`	Yes		→ vandelay.queued_bib_record(id)
eg_record FK	`bigint`	Yes		→ biblio.record_entry(id)
quality	`integer`	No	1
match_score	`integer`	No	0

id PK

bigint

nextval('vandelay.bib_match_id_seq'::regclass)

queued_record FK

bigint

Yes

→ vandelay.queued_bib_record(id)

eg_record FK

bigint

Yes

→ biblio.record_entry(id)

quality

integer

match_score

integer

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`eg_record`	biblio.record_entry(id)	CASCADE	NO ACTION	DEFERRED	`bib_match_eg_record_fkey`
`queued_record`	vandelay.queued_bib_record(id)	CASCADE	NO ACTION	DEFERRED	`bib_match_queued_record_fkey`

eg_record

biblio.record_entry(id)

CASCADE

NO ACTION

DEFERRED

bib_match_eg_record_fkey

queued_record

vandelay.queued_bib_record(id)

CASCADE

NO ACTION

DEFERRED

bib_match_queued_record_fkey

Indexes

Index Method Definition

Index	Method	Definition
`bib_match_pkey` PK	btree	`CREATE UNIQUE INDEX bib_match_pkey ON vandelay.bib_match USING btree (id)`
`bib_match_queued_record_idx`	btree	`CREATE INDEX bib_match_queued_record_idx ON vandelay.bib_match USING btree (queued_record)`

bib_match_pkey PK

btree

CREATE UNIQUE INDEX bib_match_pkey ON vandelay.bib_match USING btree (id)

bib_match_queued_record_idx

btree

CREATE INDEX bib_match_queued_record_idx ON vandelay.bib_match USING btree (queued_record)