   seq_region_end        INT NOT NULL,
   seq_region_strand     TINYINT NOT NULL,
   analysis_id           INT NOT NULL,                  # FK refs analysis
-  regulatory_motif_id   INT,                           # FK refs regulatory_motif
-  influence             ENUM('positive', 'negative', 'mixed', 'unknown'),
+  regulatory_factor_id  INT,                           # FK refs regulatory_motif
+
 
   PRIMARY KEY(regulatory_feature_id)
 


################################################################################
#
# 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)

) COLLATE=latin1_swedish_ci TYPE=MyISAM;



################################################################################
#
# Table structure for table 'regulatory_factor_transcript'
#
# Describes which transcripts code for particular regulatory factors.

CREATE TABLE regulatory_factor_transcript (

  transcript_id         INT NOT NULL,               # FK to transcript
  regulatory_factor_id  INT NOT NULL,               # FK to regulatory_feature

  KEY translation_idx (transcript_id),
  KEY regulatory_factor_idx (regulatory_factor_id)

) COLLATE=latin1_swedish_ci TYPE=MyISAM;


