 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 transcript_attrib ADD FOREIGN KEY (attrib_type_id) REFERENCES attrib_type(attrib_type_id);
ALTER table transcript_attrib ADD FOREIGN KEY (transcript_id) REFERENCES transcript(transcript_id);

ALTER table transcript_stable_id ADD FOREIGN KEY (transcript_id) REFERENCES transcript(transcript_id);

ALTER table transcript_supporting_feature ADD FOREIGN KEY (transcript_id) REFERENCES transcript(transcript_id);

ALTER table translation ADD FOREIGN KEY (end_exon_id) REFERENCES exon(exon_id);


ALTER table assembly_exception ADD FOREIGN KEY (exc_seq_region_id) REFERENCES seq_region(seq_region_id);
ALTER table assembly_exception ADD FOREIGN KEY (seq_region_id) REFERENCES seq_region(seq_region_id);

ALTER table data_file ADD FOREIGN KEY (coord_system_id) REFERENCES coord_system(coord_system_id);
ALTER table data_file ADD FOREIGN KEY (analysis_id) REFERENCES analysis(analysis_id);

ALTER table density_feature ADD FOREIGN KEY (density_type_id) REFERENCES density_type(density_type_id);
ALTER table density_feature ADD FOREIGN KEY (seq_region_id) REFERENCES seq_region(seq_region_id);
