 ALTER TABLE operon ADD FOREIGN KEY (analysis_id) REFERENCES analysis(analysis_id);
 ALTER TABLE operon ADD FOREIGN KEY (seq_region_id) REFERENCES seq_region(seq_region_id);
 
-ALTER TABLE operon_stable_id ADD FOREIGN KEY (operon_id) REFERENCES operon(operon_id);
-
 ALTER TABLE operon_transcript ADD FOREIGN KEY (analysis_id) REFERENCES analysis(analysis_id);
 ALTER TABLE operon_transcript ADD FOREIGN KEY (seq_region_id) REFERENCES seq_region(seq_region_id); 
 ALTER TABLE operon_transcript ADD FOREIGN KEY (operon_id) REFERENCES operon(operon_id);
-
-ALTER TABLE operon_transcript_stable_id ADD FOREIGN KEY (operon_transcript_id) REFERENCES operon_transcript(operon_transcript_id);
 
 ALTER TABLE operon_transcript_gene ADD FOREIGN KEY (operon_transcript_id) REFERENCES operon_transcript(operon_transcript_id);
 ALTER TABLE operon_transcript_gene ADD FOREIGN KEY (gene_id) REFERENCES gene(gene_id);


ALTER table gene_archive ADD FOREIGN KEY (mapping_session_id) REFERENCES mapping_session(mapping_session_id);
ALTER table gene_archive ADD FOREIGN KEY (peptide_archive_id) REFERENCES peptide_archive(peptide_archive_id);

ALTER table gene_stable_id ADD FOREIGN KEY (gene_id) REFERENCES gene(gene_id);

ALTER table ontology_xref ADD FOREIGN KEY (object_xref_id) REFERENCES object_xref(object_xref_id);
ALTER table ontology_xref ADD FOREIGN KEY (source_xref_id) REFERENCES xref(xref_id);


ALTER table exon ADD FOREIGN KEY (seq_region_id) REFERENCES seq_region(seq_region_id);

ALTER table exon_transcript ADD FOREIGN KEY (exon_id) REFERENCES exon(exon_id);
ALTER table exon_transcript ADD FOREIGN KEY (transcript_id) REFERENCES transcript(transcript_id);

