 #
 CREATE TABLE repeat_feature (
   id        int(10) unsigned NOT NULL auto_increment,
-  contig    int(10) unsigned NOT NULL,
+  contig    int(10) unsigned NOT NULL,         # foreign key contig:internal_id
   seq_start int(10) NOT NULL,
   seq_end   int(10) NOT NULL,
   score     double(16,4) NOT NULL,
   strand    tinyint(1) DEFAULT '1' NOT NULL,
-  analysis  int(10) unsigned NOT NULL,
+  analysis  int(10) unsigned NOT NULL,         # foregin key analysisprocess:analysisId
   hstart    int(11) NOT NULL,
   hend      int(11) NOT NULL,
   hid       varchar(40) NOT NULL,

#
# Table structure for table 'translation'
#
CREATE TABLE translation (
  translation_id  INT UNSIGNED NOT NULL auto_increment,
  seq_start       INT(10) NOT NULL,
  start_exon_id   INT UNSIGNED NOT NULL,
  seq_end         INT(10) NOT NULL,
  end_exon_id     INT UNSIGNED NOT NULL,
  
  PRIMARY KEY (translation_id)
);

CREATE TABLE translation_stable_id (
    translation_id INT unsigned NOT NULL,
    stable_id VARCHAR(40) NOT NULL,
    version   INT(10) DEFAULT '1' NOT NULL,
    

);

CREATE TABLE transcript_stable_id (
    transcript_id int unsigned not null,  # foreign key transcript:transcript_id
    stable_id     VARCHAR(40) not null,
    version       int(10) DEFAULT '1' NOT NULL,
    
