Table homo_sapiens_core_52_36n.gene_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
gene_id int unsigned 10 0
gene.gene_id Implied Constraint
attrib_type_id smallint unsigned 5 0
attrib_type.attrib_type_id Implied Constraint
value text 65535

Table contained 48 618 rows at ma maalis 23 00:31 EET 2009

Indexes:
Column(s) Type Sort Constraint Name
gene_id Performance Asc gene_idx
attrib_type_id + value Performance Asc/Asc type_val_idx
value Performance Asc val_only_idx

Close relationships: