 #
 CREATE TABLE 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        int(1) DEFAULT '1' NOT NULL,
-  analysis      int(10) unsigned NOT NULL,
+  analysis      int(10) unsigned NOT NULL,      # foreign key analysisprocess:analysisId
   name          varchar(40),
   hstart        int(11) NOT NULL,
   hend          int(11) 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 gene_stable_id (
    gene_id int unsigned not null,    # foreign key gene:gene_id
    stable_id VARCHAR(40) not null,
    version   int(10) DEFAULT '1' NOT NULL,
    created   datetime NOT NULL,
