Table homo_sapiens_core_98_38.dna_align_feature_attrib 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
dna_align_feature_id int unsigned 10
dna_align_feature.dna_align_feature_id Implied Constraint R
attrib_type_id smallint unsigned 5
attrib_type.attrib_type_id Implied Constraint R
value text 65535

Table contained 0 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
dna_align_feature_id + attrib_type_id + value Must be unique Asc/Asc/Asc dna_align_feature_attribx
dna_align_feature_id Performance Asc dna_align_feature_idx
attrib_type_id + value Performance Asc/Asc type_val_idx
value Performance Asc val_only_idx

Close relationships: