Table testsql_comments.matchpoint_components 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
matchpoint_id int 10
matchpoints.matchpoint_id matchpoint_components_ifbk_1 C
matchpoint_component_id int 10  √ 
matchpoint_component_norms.matchpoint_component_id matchpoint_component_norms_ifbk_1 C
sequence int 10 0
tag varchar 3
subfields varchar 40
offset int 10 0
length int 10 0

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
matchpoint_component_id Primary key Asc PRIMARY
matchpoint_id + sequence Performance Asc/Asc by_sequence

Close relationships  within of separation: