Table testsql_comments.import_record_matches
matches found when importing a batch of records

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
import_record_id int 10
import_records.import_record_id import_record_matches_ibfk_1 C
the id given to the imported bib record (import_records.import_record_id)
candidate_match_id int 10 the biblio the imported record matches (biblio.biblionumber)
score int 10 0 the match score

Table contained 0 rows at Mon Jun 26 09:07 NZST 2017

Indexes:
Column(s) Type Sort Constraint Name
import_record_id + score Performance Asc/Asc record_score

Close relationships  within of separation: