Table homo_sapiens_core_98_38.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 1
transcript_stable_id varchar 128
transcript_version smallint 5 1
translation_stable_id varchar 128  √  null
translation_version smallint 5 1
peptide_archive_id int unsigned 10  √  null
peptide_archive.peptide_archive_id Implied Constraint R
mapping_session_id int unsigned 10
mapping_session.mapping_session_id Implied Constraint R

Table contained 612,707 rows at Wed Nov 27 11:43 CET 2019

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: