Table homo_sapiens_core_52_36n.gene_archive 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_stable_id varchar 128
gene_version smallint 5 0
transcript_stable_id varchar 128
transcript_version smallint 5 0
translation_stable_id varchar 128
translation_version smallint 5 0
peptide_archive_id int unsigned 10 0
peptide_archive.peptide_archive_id Implied Constraint
mapping_session_id int unsigned 10 0
mapping_session.mapping_session_id Implied Constraint

Table contained 130 208 rows at ma maalis 23 00:31 EET 2009

Indexes:
Column(s) Type Sort Constraint Name
gene_stable_id + gene_version Performance Asc/Asc gene_idx
peptide_archive_id Performance Asc peptide_archive_id_idx
transcript_stable_id + transcript_version Performance Asc/Asc transcript_idx
translation_stable_id + translation_version Performance Asc/Asc translation_idx

Close relationships: