experiments

namespace: SMRUCC.genomics.Data.Regtransbase.MySQL

DROP TABLE IF EXISTS experiments;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE experiments (
exp_guid int(11) NOT NULL DEFAULT ‘0’,
pkg_guid int(11) NOT NULL DEFAULT ‘0’,
art_guid int(11) NOT NULL DEFAULT ‘0’,
descript blob,
last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (exp_guid),
KEY FK_experiments-pkg_guid (pkg_guid),
KEY FK_experiments-art_guid (art_guid),
CONSTRAINT FK_experiments-art_guid FOREIGN KEY (art_guid) REFERENCES articles (art_guid),
CONSTRAINT FK_experiments-pkg_guid FOREIGN KEY (pkg_guid) REFERENCES packages (pkg_guid)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/!40101 SET character_set_client = @saved_cs_client /;