Table homo_sapiens_core_98_38.alt_allele 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
alt_allele_id int unsigned 10  √ 
alt_allele_attrib.alt_allele_id Implied Constraint R
alt_allele_group_id int unsigned 10
alt_allele_group.alt_allele_group_id Implied Constraint R
gene_id int unsigned 10
gene.gene_id Implied Constraint R

Table contained 8,601 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
alt_allele_id Primary key Asc PRIMARY
gene_id + alt_allele_group_id Performance Asc/Asc gene_id
gene_id Must be unique Asc gene_idx

Close relationships: