 
 ################################################################################
 #
-# Table structure for table 'regulatory_motif'
-#
-
-CREATE TABLE regulatory_motif (
-
-  regulatory_motif_id   INT NOT NULL auto_increment,
-  name                  VARCHAR(255) NOT NULL,
-  type                  ENUM('miRNA_target', 'promoter'),
-
-  PRIMARY KEY(regulatory_motif_id)
+# Table structure for table 'regulatory_factor'
+#
+
+CREATE TABLE regulatory_factor (
+
+  regulatory_factor_id   INT NOT NULL auto_increment,
+  name                   VARCHAR(255) NOT NULL,
+  type                   ENUM('miRNA_target', 'transcription_factor', 'transcription_factor_complex'),
+
+  PRIMARY KEY(regulatory_factor_id)
 
 ) COLLATE=latin1_swedish_ci TYPE=MyISAM;
 


################################################################################
#
# Table structure for table 'peptide_regulatory_feature'
#

CREATE TABLE peptide_regulatory_feature (

  translation_id        INT NOT NULL,               # FK to translation
  regulatory_feature_id INT NOT NULL,               # FK to regulatory_feature

  KEY translation_idx (translation_id),
  KEY regulatory_feature_idx (regulatory_feature_id)

) COLLATE=latin1_swedish_ci TYPE=MyISAM;



  seq_region_end        INT NOT NULL,
  seq_region_strand     TINYINT NOT NULL,
  analysis_id           INT NOT NULL,                  # FK refs analysis
  regulatory_factor_id  INT,                           # FK refs regulatory_motif


  PRIMARY KEY(regulatory_feature_id)

