   regulatory_feature_id INT NOT NULL,               # FK to regulatory_feature
   ensembl_object_type   ENUM( 'Transcript', 'Translation', 'Gene') NOT NULL,
   ensembl_object_id     INT NOT NULL,               # FK to transcript,gene etc
+  influence             ENUM('positive', 'negative', 'mixed', 'unknown'),
+  evidence              VARCHAR(255),
 
   KEY regulatory_feature_idx (regulatory_feature_id),
   KEY ensembl_object_idx (ensembl_object_type, ensembl_object_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;


