vandelay.authority_match

Cascading Deletes: Deleting rows from this table will cascade to: vandelay.queued_authority_record.

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

Columns

Column Type Nullable Default Notes

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

id PK

bigint

nextval('vandelay.authority_match_id_seq'::regclass)

queued_record FK

bigint

Yes

→ vandelay.queued_authority_record(id)

eg_record FK

bigint

Yes

→ authority.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`	authority.record_entry(id)	NO ACTION	NO ACTION	DEFERRED	`authority_match_eg_record_fkey`
`queued_record`	vandelay.queued_authority_record(id)	CASCADE	NO ACTION	DEFERRED	`authority_match_queued_record_fkey`

eg_record

authority.record_entry(id)

NO ACTION

DEFERRED

authority_match_eg_record_fkey

queued_record

vandelay.queued_authority_record(id)

CASCADE

NO ACTION

DEFERRED

authority_match_queued_record_fkey

Indexes

Index Method Definition

Index	Method	Definition
`authority_match_pkey` PK	btree	`CREATE UNIQUE INDEX authority_match_pkey ON vandelay.authority_match USING btree (id)`

authority_match_pkey PK

btree

CREATE UNIQUE INDEX authority_match_pkey ON vandelay.authority_match USING btree (id)