# $Id: BNpp_int.sql,v 1.2 2007/02/23 16:12:44 kuentzer Exp $ # $Author: kuentzer $ SET FOREIGN_KEY_CHECKS = 0; # # Table structure for table `AATRNA` # CREATE TABLE `AATRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `AATRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `A_OCCURENCE` # CREATE TABLE `A_OCCURENCE` ( `value` BIGINT default NULL, `nucdistributionmatrix_id` BIGINT NOT NULL DEFAULT '0', KEY `nuc_ind` (`nucdistributionmatrix_id`), INDEX `val_ind` (`value`), CONSTRAINT `a_occurence_attribut` FOREIGN KEY (`nucdistributionmatrix_id`) REFERENCES `NucDistributionMatrix` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Activator` # CREATE TABLE `Activator` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ActivatorParent` FOREIGN KEY (`id`) REFERENCES `Regulator` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ActivatorTF` # CREATE TABLE `ActivatorTF` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ActivatorTFParent` FOREIGN KEY (`id`) REFERENCES `TranscriptionFactor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Active` # CREATE TABLE `Active` ( `id` BIGINT NOT NULL DEFAULT '0', `activitylevel` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `ac_ind` (`activitylevel`), CONSTRAINT `ActiveParent` FOREIGN KEY (`id`) REFERENCES `StateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Active_Event` # CREATE TABLE `Active_Event` ( `event` BIGINT NOT NULL DEFAULT '0', `active` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`event`,`active`), KEY `ev_ind` (`event`), KEY `ac_ind` (`active`), CONSTRAINT `relationship68` FOREIGN KEY (`active`) REFERENCES `Active` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship67` FOREIGN KEY (`event`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Artificial` # CREATE TABLE `Artificial` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ArtificialParent` FOREIGN KEY (`id`) REFERENCES `Source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `BentTo` # CREATE TABLE `BentTo` ( `id` BIGINT NOT NULL DEFAULT '0', `nucleicacidsequence_a` BIGINT NOT NULL DEFAULT '0', `nucleicacidsequence_b` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `a_ind` (`nucleicacidsequence_a`), KEY `b_ind` (`nucleicacidsequence_b`), CONSTRAINT `bent_to_B` FOREIGN KEY (`nucleicacidsequence_b`) REFERENCES `NucleicAcidSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `BentToParent` FOREIGN KEY (`id`) REFERENCES `StateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `bent_to_A` FOREIGN KEY (`nucleicacidsequence_a`) REFERENCES `NucleicAcidSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `BindingSite` # CREATE TABLE `BindingSite` ( `id` BIGINT NOT NULL DEFAULT '0', `participant` BIGINT default NULL, PRIMARY KEY (`id`), KEY `part_ind` (`participant`), CONSTRAINT `binds_participant` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `BindingSiteParent` FOREIGN KEY (`id`) REFERENCES `SequenceUnit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Bound` # CREATE TABLE `Bound` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `BoundParent` FOREIGN KEY (`id`) REFERENCES `StateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `CDNA` # CREATE TABLE `CDNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `CDNAParent` FOREIGN KEY (`id`) REFERENCES `DNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `CDNAClone` # CREATE TABLE `CDNAClone` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `CDNACloneParent` FOREIGN KEY (`id`) REFERENCES `CDNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `CDNALibrary` # CREATE TABLE `CDNALibrary` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `CDNALibraryParent` FOREIGN KEY (`id`) REFERENCES `Source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `CLASSNAME` # CREATE TABLE `CLASSNAME` ( `id` mediumint(7) NOT NULL default '0', `table_id` mediumint(7) NOT NULL default '0', `parent` mediumint(7) default NULL, PRIMARY KEY (`id`), KEY `table_id_ind` (`table_id`), KEY `parent_ind` (`parent`), CONSTRAINT `class_parent` FOREIGN KEY (`parent`) REFERENCES `CLASSNAME` (`id`), CONSTRAINT `table_id_description` FOREIGN KEY (`table_id`) REFERENCES `TABLELIST` (`id`) ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `C_OCCURENCE` # CREATE TABLE `C_OCCURENCE` ( `value` varchar(127) default NULL, `nucdistributionmatrix_id` BIGINT NOT NULL DEFAULT '0', KEY `nuc_ind` (`nucdistributionmatrix_id`), INDEX `val_ind` (`value`), CONSTRAINT `c_occurence_attribut` FOREIGN KEY (`nucdistributionmatrix_id`) REFERENCES `NucDistributionMatrix` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Catalyst` # CREATE TABLE `Catalyst` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `CatalystParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `CellCycleState` # CREATE TABLE `CellCycleState` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `CellCycleStateParent` FOREIGN KEY (`id`) REFERENCES `State` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Centromere` # CREATE TABLE `Centromere` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `CentromereParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ChromatinStructure` # CREATE TABLE `ChromatinStructure` ( `id` BIGINT NOT NULL DEFAULT '0', `accessability` float(16,8) default NULL, `value` mediumint(7) default NULL, PRIMARY KEY (`id`), INDEX `val_ind` (`value`), INDEX `acc_ind` (`accessability`), CONSTRAINT `ChromatinStructureParent` FOREIGN KEY (`id`) REFERENCES `NAStateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Chromosome` # CREATE TABLE `Chromosome` ( `id` BIGINT NOT NULL DEFAULT '0', `length` mediumint(7) default NULL, `number` varchar(127) default NULL, `nucleicacid` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `len_ind` (`length`), INDEX `num_ind` (`number`), KEY `nucleicacid_ind` (`nucleicacid`), CONSTRAINT `NucleicAcid_Chromosome` FOREIGN KEY (`nucleicacid`) REFERENCES `NucleicAcid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ChromosomeParent` FOREIGN KEY (`id`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Cofactor` # CREATE TABLE `Cofactor` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `CofactorParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Coiling` # CREATE TABLE `Coiling` ( `id` BIGINT NOT NULL DEFAULT '0', `value` float(16,8) default NULL, PRIMARY KEY (`id`), INDEX `val_ind` (`value`), CONSTRAINT `CoilingParent` FOREIGN KEY (`id`) REFERENCES `NAStateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Collection` # CREATE TABLE `Collection` ( `id` BIGINT NOT NULL DEFAULT '0', `datasource` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `data_ind` (`datasource`), CONSTRAINT `Collection_DatabaseKey` FOREIGN KEY (`datasource`) REFERENCES `DataSource` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `CollectionParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `CompositeDataSourceKey` # CREATE TABLE `CompositeDataSourceKey` ( `id` BIGINT NOT NULL DEFAULT '0', `datasourcekey2` BIGINT default NULL, PRIMARY KEY (`id`), INDEX `dat_ind` (`datasourcekey2`), CONSTRAINT `CompositeDataSourceKeyParent` FOREIGN KEY (`id`) REFERENCES `DataSourceKey` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Compound` # CREATE TABLE `Compound` ( `id` BIGINT NOT NULL DEFAULT '0', `smiles` text default NULL, `smarts` text default NULL, PRIMARY KEY (`id`), INDEX `smi_ind` (`smiles`(127)), INDEX `sma_ind` (`smarts`(127)), CONSTRAINT `CompoundParent` FOREIGN KEY (`id`) REFERENCES `GenericCompound` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Concentration` # CREATE TABLE `Concentration` ( `id` BIGINT NOT NULL DEFAULT '0', `max` float(16,8) default NULL, `min` float(16,8) default NULL, `unit` varchar(127) default NULL, `genericcompound` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `min_ind` (`min`), INDEX `max_ind` (`max`), INDEX `unit_ind` (`unit`), KEY `gen_ind` (`genericcompound`), CONSTRAINT `for_compound` FOREIGN KEY (`genericcompound`) REFERENCES `GenericCompound` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ConcentrationParent` FOREIGN KEY (`id`) REFERENCES `LocationStateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Condition` # CREATE TABLE `Condition` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ConditionParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ConformationalChange` # CREATE TABLE `ConformationalChange` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ConformationalChangeParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ConsensusSequence` # CREATE TABLE `ConsensusSequence` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ConsensusSequenceParent` FOREIGN KEY (`id`) REFERENCES `Sequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ConservedRegion` # CREATE TABLE `ConservedRegion` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ConservedRegionParent` FOREIGN KEY (`id`) REFERENCES `Sequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ConservedRegionPosition` # CREATE TABLE `ConservedRegionPosition` ( `id` BIGINT NOT NULL DEFAULT '0', `conservedregion` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `cons_ind` (`conservedregion`), CONSTRAINT `position` FOREIGN KEY (`conservedregion`) REFERENCES `ConservedRegion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ConservedRegionPositionParent` FOREIGN KEY (`id`) REFERENCES `SubSequencePosition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ControlEvent` # CREATE TABLE `ControlEvent` ( `id` BIGINT NOT NULL DEFAULT '0', `factor` float(16,8) default NULL, PRIMARY KEY (`id`), INDEX `f_ind` (`factor`), CONSTRAINT `ControlEventParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ControlSource` # CREATE TABLE `ControlSource` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ControlSourceParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ControlTarget` # CREATE TABLE `ControlTarget` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ControlTargetParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `CytosineMethylation` # CREATE TABLE `CytosineMethylation` ( `id` BIGINT NOT NULL DEFAULT '0', `value` float(16,8) default NULL, PRIMARY KEY (`id`), INDEX `val_ind` (`value`), CONSTRAINT `CytosineMethylation` FOREIGN KEY (`id`) REFERENCES `NAStateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `DNA` # CREATE TABLE `DNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `DNAParent` FOREIGN KEY (`id`) REFERENCES `NucleicAcid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `DNAConsensusSequence` # CREATE TABLE `DNAConsensusSequence` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `DNAConsensusSequenceParent` FOREIGN KEY (`id`) REFERENCES `NAConsensusSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `DataSet` # CREATE TABLE `DataSet` ( `id` BIGINT NOT NULL DEFAULT '0', `description` varchar(127) default NULL, `max_value` int(11) default NULL, PRIMARY KEY (`id`), INDEX `descr_ind` (`description`), INDEX `max_ind` (`max_value`), CONSTRAINT `DataSetParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `DataSet_Thing` # CREATE TABLE `DataSet_Thing` ( `thing` BIGINT NOT NULL DEFAULT '0', `dataset` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`thing`,`dataset`), KEY `thing_ind` (`thing`), KEY `dataset_ind` (`dataset`), CONSTRAINT `relationship_ds_th` FOREIGN KEY (`dataset`) REFERENCES `DataSet` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship_th_ds` FOREIGN KEY (`thing`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `DataSource` # CREATE TABLE `DataSource` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `DataSourceParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `DataSourceKey` # CREATE TABLE `DataSourceKey` ( `id` BIGINT NOT NULL DEFAULT '0', `databasekey` varchar(127) default NULL, `secondary` tinyint(3) default NULL, `datasource` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `data_ind` (`datasource`), INDEX `db_ind` (`databasekey`), INDEX `se_ind` (`secondary`), CONSTRAINT `DataSource` FOREIGN KEY (`datasource`) REFERENCES `DataSource` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `DataSourceKeyParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Definition` # CREATE TABLE `Definition` ( `id` BIGINT NOT NULL DEFAULT '0', `definition` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `def_ind` (`definition`), CONSTRAINT `DefinitionParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Description` # CREATE TABLE `Description` ( `id` BIGINT NOT NULL DEFAULT '0', `description` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `d_ind` (`description`), CONSTRAINT `DescriptionParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `DevelopmentState` # CREATE TABLE `DevelopmentState` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `DevelopmentStateParent` FOREIGN KEY (`id`) REFERENCES `State` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Disease` # CREATE TABLE `Disease` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `DiseaseParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Domain` # CREATE TABLE `Domain` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `DomainParent` FOREIGN KEY (`id`) REFERENCES `ProteinSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `DomainClass` # CREATE TABLE `DomainClass` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `DomainClassParent` FOREIGN KEY (`id`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `DownRegulation` # CREATE TABLE `DownRegulation` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `DownRegulationParent` FOREIGN KEY (`id`) REFERENCES `RegulativeEvent` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `EST` # CREATE TABLE `EST` ( `id` BIGINT NOT NULL DEFAULT '0', `cdna` BIGINT default NULL, PRIMARY KEY (`id`), KEY `cdna_ind` (`cdna`), CONSTRAINT `derived_from` FOREIGN KEY (`cdna`) REFERENCES `CDNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ESTParent` FOREIGN KEY (`id`) REFERENCES `CDNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Educt` # CREATE TABLE `Educt` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `EductParent` FOREIGN KEY (`id`) REFERENCES `Substrate` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Effect` # CREATE TABLE `Effect` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `EffectParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Effect_Event` # CREATE TABLE `Effect_Event` ( `event` BIGINT NOT NULL DEFAULT '0', `effect` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`event`,`effect`), KEY `event_ind` (`event`), KEY `effect_ind` (`effect`), CONSTRAINT `relationship32` FOREIGN KEY (`effect`) REFERENCES `Effect` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship31` FOREIGN KEY (`event`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Enhancer` # CREATE TABLE `Enhancer` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `EnhancerParent` FOREIGN KEY (`id`) REFERENCES `RegulatoryElement` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Enzyme` # CREATE TABLE `Enzyme` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `EnzymeParent` FOREIGN KEY (`id`) REFERENCES `Catalyst` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Polymerase` # CREATE TABLE `Polymerase` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `PolymeraseParent` FOREIGN KEY (`id`) REFERENCES `Enzyme` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `EnzymeClass` # CREATE TABLE `EnzymeClass` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `EnzymClassParent` FOREIGN KEY (`id`) REFERENCES `ProteinClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `EnzymeClass_Reaction` # CREATE TABLE `EnzymeClass_Reaction` ( `reaction` BIGINT NOT NULL DEFAULT '0', `enzymeclass` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`reaction`,`enzymeclass`), KEY `reaction_ind` (`reaction`), KEY `enzymeclass_ind` (`enzymeclass`), CONSTRAINT `relationship135` FOREIGN KEY (`enzymeclass`) REFERENCES `EnzymeClass` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship134` FOREIGN KEY (`reaction`) REFERENCES `Reaction` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Event` # CREATE TABLE `Event` ( `id` BIGINT NOT NULL DEFAULT '0', `reverse` tinyint(3) default NULL, `suspected` tinyint(3) default NULL, `probability` float(16,8) default NULL, `intramolecular` tinyint(3) default NULL, `reverseevent` BIGINT default NULL, PRIMARY KEY (`id`), INDEX `re_ind` (`reverse`), INDEX `su_ind` (`suspected`), INDEX `pr_ind` (`probability`), INDEX `in_ind` (`intramolecular`), KEY `rev_event_ind` (`reverseevent`), CONSTRAINT `EventParent` FOREIGN KEY (`id`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `reverse_event` FOREIGN KEY (`reverseevent`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `EventEquation` # CREATE TABLE `EventEquation` ( `id` BIGINT NOT NULL DEFAULT '0', `event` BIGINT NOT NULL DEFAULT '0', `equation` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `eq_ind` (`equation`), KEY `event_ind` (`event`), CONSTRAINT `equationConstraint` FOREIGN KEY (`event`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `EventEquationParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `EventType` # CREATE TABLE `EventType` ( `id` BIGINT NOT NULL DEFAULT '0', `reverse` tinyint(3) default NULL, PRIMARY KEY (`id`), INDEX `re_ind` (`reverse`), CONSTRAINT `EventTypeParent` FOREIGN KEY (`id`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `EventTypeCollection` # CREATE TABLE `EventTypeCollection` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `EventTypeCollectionParent` FOREIGN KEY (`id`) REFERENCES `Collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Exon` # CREATE TABLE `Exon` ( `id` BIGINT NOT NULL DEFAULT '0', `number` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `n_ind` (`number`), CONSTRAINT `ExonParent` FOREIGN KEY (`id`) REFERENCES `SequenceUnit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Experiment` # CREATE TABLE `Experiment` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ExperimentParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ExpressionExperiment` # CREATE TABLE `ExpressionExperiment` ( `id` BIGINT NOT NULL DEFAULT '0', `chip` varchar(127) default NULL, `median` double(20,10) default NULL, `mean` double(20,10) default NULL, `variance` double(20,10) default NULL, `min` double(20,10) default NULL, `max` double(20,10) default NULL, PRIMARY KEY (`id`), INDEX `median_ind` (`median`), INDEX `mean_ind` (`mean`), INDEX `variance_ind` (`variance`), INDEX `min_ind` (`min`), INDEX `max_ind` (`max`), CONSTRAINT `ExpressionExperimentParent` FOREIGN KEY (`id`) REFERENCES `Experiment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ExpressionPlatform` # CREATE TABLE `ExpressionPlatform` ( `id` int NOT NULL auto_increment, `size` int NOT NULL default 0, `identifier` LONGBLOB default NULL, `db` varchar(127) default NULL, `external` varchar(127) default NULL, `organism` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `external_ind` (`external`) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `ExpressionData` # CREATE TABLE `ExpressionData` ( `id` int NOT NULL auto_increment, `platform` int NOT NULL, `matrix` LONGBLOB default NULL, `head` varchar(127) default NULL, `title` varchar(127) default NULL, `description` varchar(127) default NULL, `external` varchar(127) default NULL, `head_descr` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `head_ind` (`head`), KEY `platform_ind` (`platform`), CONSTRAINT `PlatformID` FOREIGN KEY (`platform`) REFERENCES `ExpressionPlatform` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `ExperimentalCondition` # CREATE TABLE `ExperimentalCondition` ( `id` BIGINT NOT NULL DEFAULT '0', `general` varchar(127) default NULL, `system` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `ge_ind` (`general`), INDEX `sy_ind` (`system`), CONSTRAINT `ExperimentalConditionParent` FOREIGN KEY (`id`) REFERENCES `Condition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ExperimentalCondition_Experiment` # CREATE TABLE `ExperimentalCondition_Experiment` ( `experiment` BIGINT NOT NULL DEFAULT '0', `experimentalcondition` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`experiment`,`experimentalcondition`), KEY `exp_ind` (`experiment`), KEY `exp_cond_ind` (`experimentalcondition`), CONSTRAINT `relationship74` FOREIGN KEY (`experimentalcondition`) REFERENCES `ExperimentalCondition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship73` FOREIGN KEY (`experiment`) REFERENCES `Experiment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ExperimentalFunction` # CREATE TABLE `ExperimentalFunction` ( `id` BIGINT NOT NULL DEFAULT '0', `level` double(20,10) default NULL, `unit` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `le_ind` (`level`), INDEX `un_ind` (`unit`), CONSTRAINT `ExperimentalFunctionParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Expression` # CREATE TABLE `Expression` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ExpressionParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ExpressionProduct` # CREATE TABLE `ExpressionProduct` ( `id` BIGINT NOT NULL DEFAULT '0', `level` double(20,10) default NULL, PRIMARY KEY (`id`), INDEX `level_ind` (`level`), CONSTRAINT `ExpressionProductParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ExpressionScheme` # CREATE TABLE `ExpressionScheme` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ExpressionSchemeParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `FeedbackLoop` # CREATE TABLE `FeedbackLoop` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `FeedbackLoopParent` FOREIGN KEY (`id`) REFERENCES `RegulatoryPathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Formula` # CREATE TABLE `Formula` ( `id` BIGINT NOT NULL DEFAULT '0', `formula` varchar(255) default NULL, `participant` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `part_ind` (`participant`), INDEX `for_ind` (`formula`), CONSTRAINT `participantLnk` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FormulaParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `FoundationsForNucDistrMatrix` # CREATE TABLE `FoundationsForNucDistrMatrix` ( `id` BIGINT NOT NULL DEFAULT '0', `start` mediumint(7) default NULL, `length` mediumint(7) default NULL, `orientation` varchar(127) default NULL, `nucdistributionmatrix` BIGINT NOT NULL DEFAULT '0', `bindingsite` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `s_ind` (`start`), INDEX `l_ind` (`length`), INDEX `o_ind` (`orientation`), KEY `nuc_ind` (`nucdistributionmatrix`), KEY `bind_ind` (`bindingsite`), CONSTRAINT `FoundationsForNucDistrMatrixParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FoundationsForNucDistr_BindingSite` FOREIGN KEY (`bindingsite`) REFERENCES `BindingSite` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `NucDistr_FoundationsForNucDistr` FOREIGN KEY (`nucdistributionmatrix`) REFERENCES `NucDistributionMatrix` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `FunctionalDescription` # CREATE TABLE `FunctionalDescription` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `FunctionalDescriptionParent` FOREIGN KEY (`id`) REFERENCES `Description` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `GAP_VECTOR` # CREATE TABLE `GAP_VECTOR` ( `value` mediumint(7) default NULL, `foundationfornucdistrmatrix_id` BIGINT NOT NULL DEFAULT '0', KEY `found_ind` (`foundationfornucdistrmatrix_id`), CONSTRAINT `gap_vector_attribut` FOREIGN KEY (`foundationfornucdistrmatrix_id`) REFERENCES `FoundationsForNucDistrMatrix` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `GRNA` # CREATE TABLE `GRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `GRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `G_OCCURENCE` # CREATE TABLE `G_OCCURENCE` ( `value` BIGINT default NULL, `nucdistributionmatrix_id` BIGINT NOT NULL DEFAULT '0', KEY `nuc_ind` (`nucdistributionmatrix_id`), CONSTRAINT `g_occurence_attribut` FOREIGN KEY (`nucdistributionmatrix_id`) REFERENCES `NucDistributionMatrix` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Gene` # CREATE TABLE `Gene` ( `id` BIGINT NOT NULL DEFAULT '0', `operon` BIGINT default NULL, `nucleicacid` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `nuc_ac_ind` (`nucleicacid`), KEY `operon_ind` (`operon`), CONSTRAINT `contains_Gene` FOREIGN KEY (`nucleicacid`) REFERENCES `NucleicAcid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `GeneParent` FOREIGN KEY (`id`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `Operon_Gene` FOREIGN KEY (`operon`) REFERENCES `Operon` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `GeneProductPolymorphism` # CREATE TABLE `GeneProductPolymorphism` ( `id` BIGINT NOT NULL DEFAULT '0', `protein` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `protein_ind` (`protein`), CONSTRAINT `GeneProductPolymorphism_Protein` FOREIGN KEY (`protein`) REFERENCES `Protein` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `GeneProductPolymorphismParent` FOREIGN KEY (`id`) REFERENCES `Polymorphism` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `GeneProductSequence` # CREATE TABLE `GeneProductSequence` ( `id` BIGINT NOT NULL DEFAULT '0', `protein` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `protein_ind` (`protein`), CONSTRAINT `GeneProductSequence_Protein` FOREIGN KEY (`protein`) REFERENCES `Protein` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `GeneProductSequenceParent` FOREIGN KEY (`id`) REFERENCES `Sequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Protein_Gene` # CREATE TABLE `Protein_Gene` ( `gene` BIGINT NOT NULL DEFAULT '0', `protein` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`gene`,`protein`), KEY `gene_ind` (`gene`), KEY `protein_ind` (`protein`), CONSTRAINT `relationship42` FOREIGN KEY (`protein`) REFERENCES `Protein` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship41` FOREIGN KEY (`gene`) REFERENCES `Gene` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Protein_RNA` # CREATE TABLE `Protein_RNA` ( `rna` BIGINT NOT NULL DEFAULT '0', `protein` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`rna`,`protein`), KEY `rna_ind` (`rna`), KEY `protein_ind` (`protein`), CONSTRAINT `relationship680` FOREIGN KEY (`rna`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship670` FOREIGN KEY (`protein`) REFERENCES `Protein` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Protein_Tag` # CREATE TABLE `Protein_Tag` ( `tag` BIGINT NOT NULL DEFAULT '0', `protein` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`tag`,`protein`), KEY `rna_ind` (`tag`), KEY `protein_ind` (`protein`), CONSTRAINT `relationship682` FOREIGN KEY (`protein`) REFERENCES `Protein` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship672` FOREIGN KEY (`tag`) REFERENCES `Tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `GeneVariant` # CREATE TABLE `GeneVariant` ( `id` BIGINT NOT NULL DEFAULT '0', `gene` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `gene_ind` (`gene`), CONSTRAINT `Allel` FOREIGN KEY (`gene`) REFERENCES `Gene` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `GeneVariantParent` FOREIGN KEY (`id`) REFERENCES `NucleicAcidSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Gene_Tag` # CREATE TABLE `Gene_Tag` ( `tag` BIGINT NOT NULL DEFAULT '0', `gene` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`tag`,`gene`), KEY `rna_ind` (`tag`), KEY `gene_ind` (`gene`), CONSTRAINT `relationship681` FOREIGN KEY (`tag`) REFERENCES `Tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship671` FOREIGN KEY (`gene`) REFERENCES `Gene` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `GenericCompound` # CREATE TABLE `GenericCompound` ( `id` BIGINT NOT NULL DEFAULT '0', `molecularweight` double(12,2) default NULL, PRIMARY KEY (`id`), CONSTRAINT `GenericCompoundParent` FOREIGN KEY (`id`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `GeneticLocus` # CREATE TABLE `GeneticLocus` ( `id` BIGINT NOT NULL DEFAULT '0', `genome` BIGINT NOT NULL DEFAULT '0', `gene` BIGINT NOT NULL DEFAULT '0', `chromosome` BIGINT default NULL, PRIMARY KEY (`id`), KEY `genome_ind` (`genome`), KEY `gene_ind` (`gene`), KEY `chromosome_ind` (`chromosome`), CONSTRAINT `GeneticLocusParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `has_GeneticLocus` FOREIGN KEY (`gene`) REFERENCES `Gene` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `Genome_GeneticLocus` FOREIGN KEY (`genome`) REFERENCES `Genome` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `Chromosome_GeneticLocus` FOREIGN KEY (`chromosome`) REFERENCES `Chromosome` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Genome` # CREATE TABLE `Genome` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `GenomeParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Histology` # CREATE TABLE `Histology` ( `id` BIGINT NOT NULL DEFAULT '0', `histology` varchar(127) NOT NULL default '', PRIMARY KEY (`id`), INDEX `his_ind` (`histology`), CONSTRAINT `HistologyParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `HNRNA` # CREATE TABLE `HNRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `HNRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `HistoneModification` # CREATE TABLE `HistoneModification` ( `id` BIGINT NOT NULL DEFAULT '0', `argininmethylation` mediumint(7) default NULL, `lysineacetylation` float(16,8) default NULL, `lysinemethylation` float(16,8) default NULL, `lysineubiquitylation` float(16,8) default NULL, `serinephpsphorylation` float(16,8) default NULL, PRIMARY KEY (`id`), INDEX `am_ind` (`argininmethylation`), INDEX `la_ind` (`lysineacetylation`), INDEX `lm_ind` (`lysinemethylation`), INDEX `lu_ind` (`lysineubiquitylation`), INDEX `sp_ind` (`serinephpsphorylation`), CONSTRAINT `HistoneModificationParent` FOREIGN KEY (`id`) REFERENCES `NAStateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Homologues` # CREATE TABLE `Homologues` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `HomologuesParent` FOREIGN KEY (`id`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Homologues_Role` # CREATE TABLE `Homologues_Role` ( `role` BIGINT NOT NULL DEFAULT '0', `homologues` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`role`,`homologues`), KEY `role_ind` (`role`), KEY `hom_ind` (`homologues`), CONSTRAINT `relationship54` FOREIGN KEY (`homologues`) REFERENCES `Homologues` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship53` FOREIGN KEY (`role`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Hybridization` # CREATE TABLE `Hybridization` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `HybridizationParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ID_GENERATOR` # CREATE TABLE `ID_GENERATOR` ( `next_high` int(10) NOT NULL default '0', PRIMARY KEY (`next_high`) ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Individual` # CREATE TABLE `Individual` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `IndividualParent` FOREIGN KEY (`id`) REFERENCES `Organism` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Inducer` # CREATE TABLE `Inducer` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `InducerParent` FOREIGN KEY (`id`) REFERENCES `TranscriptionFactor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Inhibitor` # CREATE TABLE `Inhibitor` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `InhibitorParent` FOREIGN KEY (`id`) REFERENCES `Regulator` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `InhibitorTF` # CREATE TABLE `InhibitorTF` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `InhibitorTFParent` FOREIGN KEY (`id`) REFERENCES `TranscriptionFactor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Interaction` # CREATE TABLE `Interaction` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `InteractionParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Intron` # CREATE TABLE `Intron` ( `id` BIGINT NOT NULL DEFAULT '0', `number` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `nu_ind` (`number`), CONSTRAINT `IntronParent` FOREIGN KEY (`id`) REFERENCES `SequenceUnit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Isoform` # CREATE TABLE `Isoform` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `IsoformParent` FOREIGN KEY (`id`) REFERENCES `Homologues` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Isolator` # CREATE TABLE `Isolator` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `IsolatorParent` FOREIGN KEY (`id`) REFERENCES `RegulatoryElement` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Location` # CREATE TABLE `Location` ( `id` BIGINT NOT NULL DEFAULT '0', `geneontology` varchar(127) NOT NULL default '', PRIMARY KEY (`id`), INDEX `go_ind` (`geneontology`), CONSTRAINT `LocationParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `LocationStateProperty` # CREATE TABLE `LocationStateProperty` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `LocationStatePropertyParent` FOREIGN KEY (`id`) REFERENCES `StateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `LocationType` # CREATE TABLE `LocationType` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `LocationTypeParent` FOREIGN KEY (`id`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `MRNA` # CREATE TABLE `MRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `MRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `MainEduct` # CREATE TABLE `MainEduct` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `MainEductParent` FOREIGN KEY (`id`) REFERENCES `Educt` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `MainProduct` # CREATE TABLE `MainProduct` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `MainProductParent` FOREIGN KEY (`id`) REFERENCES `Product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `MetaInformation` # CREATE TABLE `MetaInformation` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `MetainformationParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `MetaInformation_Thing` # CREATE TABLE `MetaInformation_Thing` ( `thing` BIGINT NOT NULL DEFAULT '0', `metainformation` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`thing`,`metainformation`), KEY `thing_ind` (`thing`), KEY `meta_ind` (`metainformation`), CONSTRAINT `relationship18` FOREIGN KEY (`metainformation`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship17` FOREIGN KEY (`thing`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `InteractionPathway` # CREATE TABLE `InteractionPathway` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `InteractionPathwayParent` FOREIGN KEY (`id`) REFERENCES `Pathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `MetabolicPathway` # CREATE TABLE `MetabolicPathway` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `MetabolicPathwayParent` FOREIGN KEY (`id`) REFERENCES `InteractionPathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ChromosomalLocation` # CREATE TABLE `ChromosomalLocation` ( `id` BIGINT NOT NULL DEFAULT '0', `chromosomallocation` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `cl_ind` (`chromosomallocation`), CONSTRAINT `ChromosomalLocationParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Method` # CREATE TABLE `Method` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `MethodParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `MiRNA` # CREATE TABLE `MiRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `MiRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NAConsensusSequence` # CREATE TABLE `NAConsensusSequence` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `NAConsensusSequenceParent` FOREIGN KEY (`id`) REFERENCES `ConsensusSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NAPolymorphism` # CREATE TABLE `NAPolymorphism` ( `id` BIGINT NOT NULL DEFAULT '0', `genevariant` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `gene_ind` (`genevariant`), CONSTRAINT `NAPolymorphism_GeneVariant` FOREIGN KEY (`genevariant`) REFERENCES `GeneVariant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `NAPolymorphismParent` FOREIGN KEY (`id`) REFERENCES `Polymorphism` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NAPolymorphism_GeneProductPolymorphism` # CREATE TABLE `NAPolymorphism_GeneProductPolymorphism` ( `geneproductpolymorphism` BIGINT NOT NULL DEFAULT '0', `napolymorphism` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`geneproductpolymorphism`,`napolymorphism`), KEY `gene_ind` (`geneproductpolymorphism`), KEY `na_ind` (`napolymorphism`), CONSTRAINT `relationship44` FOREIGN KEY (`napolymorphism`) REFERENCES `NAPolymorphism` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship43` FOREIGN KEY (`geneproductpolymorphism`) REFERENCES `GeneProductPolymorphism` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NASecondaryStructure` # CREATE TABLE `NASecondaryStructure` ( `id` BIGINT NOT NULL DEFAULT '0', `value` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `v_ind` (`value`), CONSTRAINT `NASecondaryStructureParent` FOREIGN KEY (`id`) REFERENCES `NAStateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NAStateProperty` # CREATE TABLE `NAStateProperty` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `NAStatePropertyParent` FOREIGN KEY (`id`) REFERENCES `StateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Name` # CREATE TABLE `Name` ( `id` BIGINT NOT NULL DEFAULT '0', `name` varchar(255) default NULL, PRIMARY KEY (`id`), INDEX `n_ind` (`name`), CONSTRAINT `NameParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NegativeControlEvent` # CREATE TABLE `NegativeControlEvent` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `NegativeControlEventParent` FOREIGN KEY (`id`) REFERENCES `ControlEvent` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NucDistributionMatrix` # CREATE TABLE `NucDistributionMatrix` ( `id` BIGINT NOT NULL DEFAULT '0', `statisticalbasis` varchar(127) default NULL, `naconsensussequence` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `sb_ind` (`statisticalbasis`), KEY `na_ind` (`naconsensussequence`), CONSTRAINT `NucDistr_NAConsensusSequence` FOREIGN KEY (`naconsensussequence`) REFERENCES `NAConsensusSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `NucDistributionMatrixParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NucDistributionMatrix_TranscriptionFactor` # CREATE TABLE `NucDistributionMatrix_TranscriptionFactor` ( `transcriptionfactor` BIGINT NOT NULL DEFAULT '0', `nucdistributionmatrix` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`transcriptionfactor`,`nucdistributionmatrix`), KEY `nuc_ind` (`nucdistributionmatrix`), KEY `trans_ind` (`transcriptionfactor`), CONSTRAINT `relationship62` FOREIGN KEY (`transcriptionfactor`) REFERENCES `TranscriptionFactor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship61` FOREIGN KEY (`nucdistributionmatrix`) REFERENCES `NucDistributionMatrix` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NucleicAcid` # CREATE TABLE `NucleicAcid` ( `id` BIGINT NOT NULL DEFAULT '0', `length` mediumint(7) default NULL, `genome` BIGINT default NULL, PRIMARY KEY (`id`), INDEX `l_ind` (`length`), KEY `genome_ind` (`genome`), CONSTRAINT `hereditary_material` FOREIGN KEY (`genome`) REFERENCES `Genome` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `NucleicAcidParent` FOREIGN KEY (`id`) REFERENCES `GenericCompound` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `NucleicAcidSequence` # CREATE TABLE `NucleicAcidSequence` ( `id` BIGINT NOT NULL DEFAULT '0', `wholegenomesequence` tinyint(3) default NULL, `nucleicacid` BIGINT NOT NULL DEFAULT '0', `genome` BIGINT default NULL, PRIMARY KEY (`id`), INDEX `seq_ind` (`wholegenomesequence`), KEY `nuc_ind` (`nucleicacid`), KEY `gen_ind` (`genome`), CONSTRAINT `Genome_has_NucleicAcidSequence` FOREIGN KEY (`genome`) REFERENCES `Genome` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `NucleicAcidSequenceParent` FOREIGN KEY (`id`) REFERENCES `Sequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `NucleicAcid_has_NucleicAcidSequence` FOREIGN KEY (`nucleicacid`) REFERENCES `NucleicAcid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ORF` # CREATE TABLE `ORF` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ORFParent` FOREIGN KEY (`id`) REFERENCES `NucleicAcidSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ORI` # CREATE TABLE `ORI` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ORIParent` FOREIGN KEY (`id`) REFERENCES `SequenceUnit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Open` # CREATE TABLE `Open` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `OpenParent` FOREIGN KEY (`id`) REFERENCES `StateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Operator` # CREATE TABLE `Operator` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `OperatorParent` FOREIGN KEY (`id`) REFERENCES `RegulatoryElement` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Operon` # CREATE TABLE `Operon` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `OperonParent` FOREIGN KEY (`id`) REFERENCES `Sequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Organ` # CREATE TABLE `Organ` ( `id` BIGINT NOT NULL DEFAULT '0', `organ` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `o_ind` (`organ`), CONSTRAINT `OrganParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Organism` # CREATE TABLE `Organism` ( `id` BIGINT NOT NULL DEFAULT '0', `systematicgroup` BIGINT default NULL, PRIMARY KEY (`id`), KEY `sysgroup_ind` (`systematicgroup`), CONSTRAINT `SystematicGroupLnk` FOREIGN KEY (`systematicgroup`) REFERENCES `SystematicGroup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `OrganismParent` FOREIGN KEY (`id`) REFERENCES `Source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Orthologues` # CREATE TABLE `Orthologues` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `OrthologuesParent` FOREIGN KEY (`id`) REFERENCES `Homologues` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Paralogues` # CREATE TABLE `Paralogues` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ParaloguesParent` FOREIGN KEY (`id`) REFERENCES `Homologues` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `PartOf` # CREATE TABLE `PartOf` ( `id` BIGINT NOT NULL DEFAULT '0', `participant` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `part_ind` (`participant`), CONSTRAINT `PartOf_Participant` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `PartOfParent` FOREIGN KEY (`id`) REFERENCES `StateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Participant` # CREATE TABLE `Participant` ( `id` BIGINT NOT NULL DEFAULT '0', `toxicity` tinyint(3) default '0', PRIMARY KEY (`id`), INDEX `tox_ind` (`toxicity`), CONSTRAINT `ParticipantParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ParticipantClassification` # CREATE TABLE `ParticipantClassification` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ParticipantClassificationParent` FOREIGN KEY (`id`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ParticipantClassification_Collection` # CREATE TABLE `ParticipantClassification_Collection` ( `collection` BIGINT NOT NULL DEFAULT '0', `participantclassification` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`collection`,`participantclassification`), KEY `coll_ind` (`collection`), KEY `part_ind` (`participantclassification`), CONSTRAINT `relationship58` FOREIGN KEY (`participantclassification`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship57` FOREIGN KEY (`collection`) REFERENCES `Collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ParticipantClassification_Participant` # CREATE TABLE `ParticipantClassification_Participant` ( `participant` BIGINT NOT NULL DEFAULT '0', `participantclassification` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`participant`,`participantclassification`), KEY `part_ind` (`participant`), KEY `part_class_ind` (`participantclassification`), CONSTRAINT `relationship60` FOREIGN KEY (`participantclassification`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship59` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ParticipantClassification_Role` # CREATE TABLE `ParticipantClassification_Role` ( `role` BIGINT NOT NULL DEFAULT '0', `participantclassification` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`role`,`participantclassification`), KEY `role_ind` (`role`), KEY `part_ind` (`participantclassification`), CONSTRAINT `relationship52` FOREIGN KEY (`participantclassification`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship51` FOREIGN KEY (`role`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Participant_Bound` # CREATE TABLE `Participant_Bound` ( `bound` BIGINT NOT NULL DEFAULT '0', `participant` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`bound`,`participant`), KEY `part_ind` (`participant`), KEY `bound_ind` (`bound`), CONSTRAINT `relationship66` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship65` FOREIGN KEY (`bound`) REFERENCES `Bound` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Pathway` # CREATE TABLE `Pathway` ( `id` BIGINT NOT NULL DEFAULT '0', `pathway` BIGINT default NULL, PRIMARY KEY (`id`), KEY `pathway_ind` (`pathway`), CONSTRAINT `meta_pathway` FOREIGN KEY (`pathway`) REFERENCES `Pathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `PathwayParent` FOREIGN KEY (`id`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Pathway_Effect` # CREATE TABLE `Pathway_Effect` ( `effect` BIGINT NOT NULL DEFAULT '0', `pathway` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`effect`,`pathway`), KEY `path_ind` (`pathway`), KEY `effect_ind` (`effect`), CONSTRAINT `relationship30` FOREIGN KEY (`pathway`) REFERENCES `Pathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship29` FOREIGN KEY (`effect`) REFERENCES `Effect` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Pathway_Event` # CREATE TABLE `Pathway_Event` ( `event` BIGINT NOT NULL DEFAULT '0', `pathway` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`event`,`pathway`), KEY `event_ind` (`event`), KEY `path_ind` (`pathway`), CONSTRAINT `relationship28` FOREIGN KEY (`pathway`) REFERENCES `Pathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship27` FOREIGN KEY (`event`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `PeripherallyAssociated` # CREATE TABLE `PeripherallyAssociated` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `PeripherallyAssociatedParent` FOREIGN KEY (`id`) REFERENCES `StateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `PeripherallyAssociated_Participant` # CREATE TABLE `PeripherallyAssociated_Participant` ( `participant` BIGINT NOT NULL DEFAULT '0', `peripherallyassociated` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`participant`,`peripherallyassociated`), KEY `part_ind` (`participant`), KEY `peri_ind` (`peripherallyassociated`), CONSTRAINT `relationship64` FOREIGN KEY (`peripherallyassociated`) REFERENCES `PeripherallyAssociated` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship63` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `PhysicalTrigger` # CREATE TABLE `PhysicalTrigger` ( `id` BIGINT NOT NULL DEFAULT '0', `type` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `t_ind` (`type`), CONSTRAINT `PhysicalTriggerParent` FOREIGN KEY (`id`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `PhysicalTriggerType` # CREATE TABLE `PhysicalTriggerType` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `PhysicalTriggerTypeParent` FOREIGN KEY (`id`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `PhysiologicalProperty` # CREATE TABLE `PhysiologicalProperty` ( `id` BIGINT NOT NULL DEFAULT '0', `min` float(16,8) default NULL, `max` float(16,8) default NULL, `type` varchar(127) default NULL, `unit` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `min_ind` (`min`), INDEX `max_ind` (`max`), INDEX `type_ind` (`type`), INDEX `unit_ind` (`unit`), CONSTRAINT `PhysiologicalPropertyParent` FOREIGN KEY (`id`) REFERENCES `LocationStateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Plasmid` # CREATE TABLE `Plasmid` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `PlasmidParent` FOREIGN KEY (`id`) REFERENCES `DNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Polymorphism` # CREATE TABLE `Polymorphism` ( `id` BIGINT NOT NULL DEFAULT '0', `replacedby` varchar(127) default NULL, `replace` varchar(127) default NULL, `sequence` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `rb_ind` (`replacedby`), INDEX `r_ind` (`replace`), KEY `seq_ind` (`sequence`), CONSTRAINT `as_reference` FOREIGN KEY (`sequence`) REFERENCES `Sequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `PolymorphismParent` FOREIGN KEY (`id`) REFERENCES `Sequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `PositiveControlEvent` # CREATE TABLE `PositiveControlEvent` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `PositiveControlEvent` FOREIGN KEY (`id`) REFERENCES `ControlEvent` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `PrimaryTranscript` # CREATE TABLE `PrimaryTranscript` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `PrimaryTranscriptParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Product` # CREATE TABLE `Product` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ProductParent` FOREIGN KEY (`id`) REFERENCES `Substrate` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Promoter` # CREATE TABLE `Promoter` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `PromoterParent` FOREIGN KEY (`id`) REFERENCES `RegulatoryElement` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `PromoterClass` # CREATE TABLE `PromoterClass` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `PromoterClassParent` FOREIGN KEY (`id`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Protein` # CREATE TABLE `Protein` ( `id` BIGINT NOT NULL DEFAULT '0', `isoelectricpoint` double(12,2) default NULL, PRIMARY KEY (`id`), INDEX `iso_ind` (`isoelectricpoint`), CONSTRAINT `ProteinParent` FOREIGN KEY (`id`) REFERENCES `GenericCompound` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ProteinComplex` # CREATE TABLE `ProteinComplex` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ProteinComplexParent` FOREIGN KEY (`id`) REFERENCES `Protein` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ProteinClassification` # CREATE TABLE `ProteinClassification` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ProteinClassificationParent` FOREIGN KEY (`id`) REFERENCES `ParticipantClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ProteinClassificationCollection` # CREATE TABLE `ProteinClassificationCollection` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ProteinClassificationCollectionParent` FOREIGN KEY (`id`) REFERENCES `Collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ProteinClassification_ProteinClassification` # CREATE TABLE `ProteinClassification_ProteinClassification` ( `parent` BIGINT NOT NULL DEFAULT '0', `child` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`parent`,`child`), KEY `prot1_ind` (`parent`), KEY `prot2_ind` (`child`), CONSTRAINT `relationship50` FOREIGN KEY (`child`) REFERENCES `ProteinClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship49` FOREIGN KEY (`parent`) REFERENCES `ProteinClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ProteinConsensusSequence` # CREATE TABLE `ProteinConsensusSequence` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ProteinConsensusSequenceParent` FOREIGN KEY (`id`) REFERENCES `ConsensusSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ProteinFamily` # CREATE TABLE `ProteinFamily` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ProteinFamilyParent` FOREIGN KEY (`id`) REFERENCES `ProteinClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ProteinPolymorphism` # CREATE TABLE `ProteinPolymorphism` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ProteinPolymorphismParent` FOREIGN KEY (`id`) REFERENCES `GeneProductPolymorphism` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ProteinSequence` # CREATE TABLE `ProteinSequence` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ProteinSequenceParent` FOREIGN KEY (`id`) REFERENCES `GeneProductSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Publication` # CREATE TABLE `Publication` ( `id` BIGINT NOT NULL DEFAULT '0', `title` varchar(127) default NULL, `authors` varchar(127) default NULL, `source` varchar(127) default NULL, `unstructuredpublicationstring` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `t_ind` (`title`), INDEX `a_ind` (`authors`), INDEX `s_ind` (`source`), INDEX `u_ind` (`unstructuredpublicationstring`), CONSTRAINT `PublicationParent` FOREIGN KEY (`id`) REFERENCES `DataSource` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `RELATIONS` # # Creation: Dec 23, 2004 at 01:36 PM # Last update: Dec 23, 2004 at 01:37 PM # CREATE TABLE `RELATIONS` ( `table_name` varchar(127) NOT NULL default '', `relation_name` varchar(127) NOT NULL default '', `column_number` varchar(127) NOT NULL default '', `is_optional` tinyint(3) default NULL, INDEX `t_ind` (`table_name`), INDEX `r_ind` (`relation_name`), INDEX `c_ind` (`column_number`), INDEX `o_ind` (`is_optional`), PRIMARY KEY (`table_name`,`relation_name`,`column_number`) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `RNA` # CREATE TABLE `RNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `RNAParent` FOREIGN KEY (`id`) REFERENCES `NucleicAcid` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `RNAConsensusSequence` # CREATE TABLE `RNAConsensusSequence` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `RNAConsensusSequenceParent` FOREIGN KEY (`id`) REFERENCES `NAConsensusSequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `RRNA` # CREATE TABLE `RRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `RRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Reaction` # CREATE TABLE `Reaction` ( `id` BIGINT NOT NULL DEFAULT '0', `affinity` float(16,8) default NULL, `associationconstant` float(16,8) default NULL, `dissociationconstant` float(16,8) default NULL, `specificity` float(16,8) default NULL, `direction` mediumint(7) default NULL, `energy` float(16,8) default NULL, PRIMARY KEY (`id`), INDEX `aff_ind` (`affinity`), INDEX `ass_ind` (`associationconstant`), INDEX `dis_ind` (`dissociationconstant`), INDEX `spe_ind` (`specificity`), INDEX `dir_ind` (`direction`), INDEX `en_ind` (`energy`), CONSTRAINT `ReactionParent` FOREIGN KEY (`id`) REFERENCES `Interaction` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `RegulativeEvent` # CREATE TABLE `RegulativeEvent` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `RegulativeEventParent` FOREIGN KEY (`id`) REFERENCES `ControlEvent` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Regulator` # CREATE TABLE `Regulator` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `RegulatorParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `RegulatoryElement` # CREATE TABLE `RegulatoryElement` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `RegulatoryElementParent` FOREIGN KEY (`id`) REFERENCES `BindingSite` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `RegulatoryPathway` # CREATE TABLE `RegulatoryPathway` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `RegulatoryPathwayParent` FOREIGN KEY (`id`) REFERENCES `Pathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Reliability` # CREATE TABLE `Reliability` ( `id` BIGINT NOT NULL DEFAULT '0', `reliability` BIGINT default NULL, PRIMARY KEY (`id`), INDEX `rel_ind` (`reliability`), CONSTRAINT `ReliabilityParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Repressor` # CREATE TABLE `Repressor` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `RepressorParent` FOREIGN KEY (`id`) REFERENCES `TranscriptionFactor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Role` # CREATE TABLE `Role` ( `id` BIGINT NOT NULL DEFAULT '0', `stoichiometriccoefficient` mediumint(7) default NULL, `event` BIGINT default NULL, `participant` BIGINT NOT NULL DEFAULT '0', `eventtype` BIGINT default NULL, PRIMARY KEY (`id`), INDEX `st_ind` (`stoichiometriccoefficient`), KEY `ev_ind` (`event`), KEY `part_ind` (`participant`), KEY `ev_type_ind` (`eventtype`), CONSTRAINT `EventType_Role` FOREIGN KEY (`eventtype`) REFERENCES `EventType` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `RoleEventRelation` FOREIGN KEY (`event`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `RoleParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `RoleParticipantRelation` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Role_Role` # CREATE TABLE `Role_Role` ( `parent` BIGINT NOT NULL DEFAULT '0', `child` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`parent`,`child`), KEY `role1_ind` (`parent`), KEY `role2_ind` (`child`), CONSTRAINT `relationship2` FOREIGN KEY (`child`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship1` FOREIGN KEY (`parent`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SAR` # CREATE TABLE `SAR` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SARParent` FOREIGN KEY (`id`) REFERENCES `SequenceUnit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SCRNA` # CREATE TABLE `SCRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SCRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SNP` # CREATE TABLE `SNP` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SNPParent` FOREIGN KEY (`id`) REFERENCES `NAPolymorphism` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SNRNA` # CREATE TABLE `SNRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SNRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SNoRNA` # CREATE TABLE `SNoRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SNoRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Sequence` # CREATE TABLE `Sequence` ( `id` BIGINT NOT NULL DEFAULT '0', `strand` varchar(127) default NULL, `length` mediumint(7) default NULL, `sequence` BLOB default NULL, PRIMARY KEY (`id`), INDEX `strand_ind` (`strand`), INDEX `sequence_ind` (`sequence`(256)), INDEX `l_ind` (`length`), CONSTRAINT `SequenceParent` FOREIGN KEY (`id`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SequenceUnit` # CREATE TABLE `SequenceUnit` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SequenceUnitParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SideEduct` # CREATE TABLE `SideEduct` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SideEductParent` FOREIGN KEY (`id`) REFERENCES `Educt` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SideProduct` # CREATE TABLE `SideProduct` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SideProductParent` FOREIGN KEY (`id`) REFERENCES `Product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SignalEffector` # CREATE TABLE `SignalEffector` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SignalEffectorParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SignalPeptide` # CREATE TABLE `SignalPeptide` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SignalPeptideParent` FOREIGN KEY (`id`) REFERENCES `SequenceUnit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SignalReceptor` # CREATE TABLE `SignalReceptor` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SignalReceptorParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SignalTransductionPathway` # CREATE TABLE `SignalTransductionPathway` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SignalTransductionPathwayParent` FOREIGN KEY (`id`) REFERENCES `RegulatoryPathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SignificantPathwayPoint` # CREATE TABLE `SignificantPathwayPoint` ( `id` BIGINT NOT NULL DEFAULT '0', `pathway` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pathway_ind` (`pathway`), CONSTRAINT `pathway` FOREIGN KEY (`pathway`) REFERENCES `Pathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `SignificantPathwayPointParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Silencer` # CREATE TABLE `Silencer` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SilencerParent` FOREIGN KEY (`id`) REFERENCES `RegulatoryElement` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Source` # CREATE TABLE `Source` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SourceParent` FOREIGN KEY (`id`) REFERENCES `MetaInformation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SourceDatabase` # CREATE TABLE `SourceDatabase` ( `id` BIGINT NOT NULL DEFAULT '0', `url` varchar(127) default NULL, `version` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `url_ind` (`url`), INDEX `version_ind` (`version`), CONSTRAINT `SourceDatabaseParent` FOREIGN KEY (`id`) REFERENCES `DataSource` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SpecificationEventCondition` # CREATE TABLE `SpecificationEventCondition` ( `id` BIGINT NOT NULL DEFAULT '0', `event` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `ev_ind` (`event`), CONSTRAINT `SpecificationEventConditionParent` FOREIGN KEY (`id`) REFERENCES `SpecificationProcessCondition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `event_has` FOREIGN KEY (`event`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SpecificationPathwayCondition` # CREATE TABLE `SpecificationPathwayCondition` ( `id` BIGINT NOT NULL DEFAULT '0', `pathway` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `path_ind` (`pathway`), CONSTRAINT `SpecificationPathwayConditionParent` FOREIGN KEY (`id`) REFERENCES `SpecificationProcessCondition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `pathway_has` FOREIGN KEY (`pathway`) REFERENCES `Pathway` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SpecificationProcessCondition` # CREATE TABLE `SpecificationProcessCondition` ( `id` BIGINT NOT NULL DEFAULT '0', `orderspecification` varchar(127) default NULL, `condition` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `os_ind` (`orderspecification`), KEY `cond_ind` (`condition`), CONSTRAINT `has_condition` FOREIGN KEY (`condition`) REFERENCES `Condition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `SpecificationProcessConditionParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SpecificationRoleState` # CREATE TABLE `SpecificationRoleState` ( `id` BIGINT NOT NULL DEFAULT '0', `orderspecification` varchar(127) default NULL, `state` BIGINT NOT NULL DEFAULT '0', `role` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `os_ind` (`orderspecification`), KEY `state_ind` (`state`), KEY `role_ind` (`role`), CONSTRAINT `SpecificationRoleStateParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `has_state` FOREIGN KEY (`state`) REFERENCES `State` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `role_has` FOREIGN KEY (`role`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Splicing` # CREATE TABLE `Splicing` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SplicingParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `StartPoint` # CREATE TABLE `StartPoint` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `StartPointParent` FOREIGN KEY (`id`) REFERENCES `SignificantPathwayPoint` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `StartPointParticipant` # CREATE TABLE `StartPointParticipant` ( `id` BIGINT NOT NULL DEFAULT '0', `participant` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `part_ind` (`participant`), CONSTRAINT `startpoint1` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `StartPointParticipantParent` FOREIGN KEY (`id`) REFERENCES `StartPoint` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `StartPointRole` # CREATE TABLE `StartPointRole` ( `id` BIGINT NOT NULL DEFAULT '0', `role` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `role_ind` (`role`), CONSTRAINT `startpoint` FOREIGN KEY (`role`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `StartPointRoleParent` FOREIGN KEY (`id`) REFERENCES `StartPoint` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `State` # CREATE TABLE `State` ( `id` BIGINT NOT NULL DEFAULT '0', `participant` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `par_ind` (`participant`), CONSTRAINT `state_participant` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `StateParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `StateProperty` # CREATE TABLE `StateProperty` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `StatePropertyParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `State_Condition` # CREATE TABLE `State_Condition` ( `condition` BIGINT NOT NULL DEFAULT '0', `state` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`condition`,`state`), KEY `cond_ind` (`condition`), KEY `state_ind` (`state`), CONSTRAINT `relationship7000` FOREIGN KEY (`state`) REFERENCES `State` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship6900` FOREIGN KEY (`condition`) REFERENCES `Condition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `State_StateProperty` # CREATE TABLE `State_StateProperty` ( `stateproperty` BIGINT NOT NULL DEFAULT '0', `state` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`stateproperty`,`state`), KEY `state_prop_ind` (`stateproperty`), KEY `state_ind` (`state`), CONSTRAINT `relationship70` FOREIGN KEY (`state`) REFERENCES `State` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship69` FOREIGN KEY (`stateproperty`) REFERENCES `StateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SubSequencePosition` # CREATE TABLE `SubSequencePosition` ( `id` BIGINT NOT NULL DEFAULT '0', `startpos` mediumint(7) default NULL, `endpos` mediumint(7) default NULL, `parent` BIGINT NOT NULL DEFAULT '0', `child` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `sp_ind` (`startpos`), INDEX `ep_ind` (`endpos`), KEY `parent_ind` (`parent`), KEY `child_ind` (`child`), CONSTRAINT `SubSequencePositionParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `subunit_child` FOREIGN KEY (`parent`) REFERENCES `Sequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `subunit_parent` FOREIGN KEY (`child`) REFERENCES `Sequence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Substrate` # CREATE TABLE `Substrate` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SubstrateParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `SystematicGroup` # CREATE TABLE `SystematicGroup` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `SystematicGroupParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TABLEATTRIBUTES` # CREATE TABLE `TABLEATTRIBUTES` ( `tablename` varchar(127) default NULL, `attribute` varchar(127) default NULL, INDEX `t_ind` (`tablename`), INDEX `a_ind` (`attribute`) ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TABLELIST` # CREATE TABLE `TABLELIST` ( `id` mediumint(7) NOT NULL default '0', `name` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `n_ind` (`name`) ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TRNA` # CREATE TABLE `TRNA` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TRNAParent` FOREIGN KEY (`id`) REFERENCES `RNA` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `T_OCCURENCE` # CREATE TABLE `T_OCCURENCE` ( `value` BIGINT default NULL, `nucdistributionmatrix_id` BIGINT NOT NULL DEFAULT '0', KEY `nuc_ind` (`nucdistributionmatrix_id`), INDEX `v_ind` (`value`), CONSTRAINT `t_occurence_attribut` FOREIGN KEY (`nucdistributionmatrix_id`) REFERENCES `NucDistributionMatrix` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Tag` # CREATE TABLE `Tag` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TagParent` FOREIGN KEY (`id`) REFERENCES `ExperimentalFunction` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TargetPoint` # CREATE TABLE `TargetPoint` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TargetPointParent` FOREIGN KEY (`id`) REFERENCES `SignificantPathwayPoint` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TargetPointParticipant` # CREATE TABLE `TargetPointParticipant` ( `id` BIGINT NOT NULL DEFAULT '0', `participant` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `part_ind` (`participant`), CONSTRAINT `targetpoint` FOREIGN KEY (`participant`) REFERENCES `Participant` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `TargetPointParticipantParent` FOREIGN KEY (`id`) REFERENCES `TargetPoint` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TargetPointRole` # CREATE TABLE `TargetPointRole` ( `id` BIGINT NOT NULL DEFAULT '0', `role` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `role_ind` (`role`), CONSTRAINT `targetpoint1` FOREIGN KEY (`role`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `TargetPointRoleParent` FOREIGN KEY (`id`) REFERENCES `TargetPoint` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TemplateForModification` # CREATE TABLE `TemplateForModification` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TemplateForModificationParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ModifiedForm` # CREATE TABLE `ModifiedForm` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ModifiedFormParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Telomere` # CREATE TABLE `Telomere` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TelomereParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TemporaryDependency` # CREATE TABLE `TemporaryDependency` ( `id` BIGINT NOT NULL DEFAULT '0', `max` float(16,8) default NULL, `min` float(16,8) default NULL, `unit` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `min_ind` (`min`), INDEX `max_ind` (`max`), INDEX `unit_ind` (`unit`), CONSTRAINT `TemporaryDependencyParent` FOREIGN KEY (`id`) REFERENCES `Condition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Terminator` # CREATE TABLE `Terminator` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TerminatorParent` FOREIGN KEY (`id`) REFERENCES `SequenceUnit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Thing` # CREATE TABLE `Thing` ( `id` BIGINT NOT NULL DEFAULT '0', `classname_id` mediumint(7) NOT NULL default '0', `accessionnumber` varchar(127) default NULL, `timestamp` timestamp(14) NOT NULL, PRIMARY KEY (`id`), INDEX `acc_ind` (`accessionnumber`), KEY `classname_ind` (`classname_id`), CONSTRAINT `is_of_classtype` FOREIGN KEY (`classname_id`) REFERENCES `CLASSNAME` (`id`) ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Thing_Name` # CREATE TABLE `Thing_Name` ( `name` BIGINT NOT NULL DEFAULT '0', `thing` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`name`,`thing`), KEY `name_ind` (`name`), KEY `thing_ind` (`thing`), CONSTRAINT `relationship10` FOREIGN KEY (`thing`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship9` FOREIGN KEY (`name`) REFERENCES `Name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Thing_Thing` # CREATE TABLE `Thing_Thing` ( `parent` BIGINT NOT NULL DEFAULT '0', `child` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`parent`,`child`), KEY `child_ind` (`child`), KEY `parent_ind` (`parent`), CONSTRAINT `relationship8` FOREIGN KEY (`child`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship7` FOREIGN KEY (`parent`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Transcription` # CREATE TABLE `Transcription` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TranscriptionParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TranscriptionActivity` # CREATE TABLE `TranscriptionActivity` ( `id` BIGINT NOT NULL DEFAULT '0', `value` float(16,8) default NULL, PRIMARY KEY (`id`), INDEX `val_ind` (`value`), CONSTRAINT `TranscriptionActivityParent` FOREIGN KEY (`id`) REFERENCES `NAStateProperty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TranscriptionFactor` # CREATE TABLE `TranscriptionFactor` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TranscriptionFactorParent` FOREIGN KEY (`id`) REFERENCES `Role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TranscriptionFactorClass` # CREATE TABLE `TranscriptionFactorClass` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TranscriptionFactorClassParent` FOREIGN KEY (`id`) REFERENCES `ProteinClassification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TranscriptionUnit` # CREATE TABLE `TranscriptionUnit` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TranscriptionUnitParent` FOREIGN KEY (`id`) REFERENCES `SequenceUnit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `TranscriptionUnit_Gene` # CREATE TABLE `TranscriptionUnit_Gene` ( `gene` BIGINT NOT NULL DEFAULT '0', `transcriptionunit` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`gene`,`transcriptionunit`), KEY `gene_ind` (`gene`), KEY `trans_ind` (`transcriptionunit`), CONSTRAINT `relationship56` FOREIGN KEY (`transcriptionunit`) REFERENCES `TranscriptionUnit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `relationship55` FOREIGN KEY (`gene`) REFERENCES `Gene` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `ImmunRegulation` # CREATE TABLE `ImmunRegulation` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ImmunRegulationParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `StrandBreak` # CREATE TABLE `StrandBreak` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `StrandBreakParent` FOREIGN KEY (`id`) REFERENCES `Modification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Mutation` # CREATE TABLE `Mutation` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `MutationParent` FOREIGN KEY (`id`) REFERENCES `Modification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Rearrangement` # CREATE TABLE `Rearrangement` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `RearrangementParent` FOREIGN KEY (`id`) REFERENCES `Modification` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Translation` # CREATE TABLE `Translation` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TranslationParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Modification` # CREATE TABLE `Modification` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `ModificationParent` FOREIGN KEY (`id`) REFERENCES `Event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Translocation` # CREATE TABLE `Translocation` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `TranslocationParent` FOREIGN KEY (`id`) REFERENCES `Reaction` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `UpRegulation` # CREATE TABLE `UpRegulation` ( `id` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), CONSTRAINT `UpRegulationParent` FOREIGN KEY (`id`) REFERENCES `RegulativeEvent` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `UserData` # CREATE TABLE `UserData` ( `id` BIGINT NOT NULL DEFAULT '0', `people` varchar(127) default NULL, `group` varchar(127) default NULL, `project` varchar(127) default NULL, `url` varchar(127) default NULL, PRIMARY KEY (`id`), INDEX `people_ind` (`people`), INDEX `g_ind` (`group`), INDEX `pro_ind` (`project`), INDEX `url_ind` (`url`), CONSTRAINT `UserDataParent` FOREIGN KEY (`id`) REFERENCES `DataSource` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Query` # CREATE TABLE `Query` ( `id` BIGINT NOT NULL DEFAULT '0', `datasource` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `datasource_ind` (`datasource`), CONSTRAINT `QueryParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `DatasourceLnk` FOREIGN KEY (`datasource`) REFERENCES `DataSource` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; # -------------------------------------------------------- # # Table structure for table `Filter` # CREATE TABLE `Filter` ( `id` BIGINT NOT NULL DEFAULT '0', `class` varchar(127) default NULL, `attribute` varchar(127) default NULL, `operator` varchar(127) default NULL, `value` varchar(127) default NULL, `query` BIGINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `query_ind` (`query`), INDEX `c_ind` (`class`), INDEX `a_ind` (`attribute`), INDEX `o_ind` (`operator`), INDEX `v_ind` (`value`), CONSTRAINT `FilterParent` FOREIGN KEY (`id`) REFERENCES `Thing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `QueryLnk` FOREIGN KEY (`query`) REFERENCES `Query` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; SET FOREIGN_KEY_CHECKS = 1; # # Dumping data for table `TABLELIST` # INSERT INTO TABLELIST VALUES (0, 'Event'); INSERT INTO TABLELIST VALUES (1, 'Role'); INSERT INTO TABLELIST VALUES (2, 'Participant'); INSERT INTO TABLELIST VALUES (3, 'Role_Role'); INSERT INTO TABLELIST VALUES (5, 'FunctionalDescription'); INSERT INTO TABLELIST VALUES (6, 'Thing'); INSERT INTO TABLELIST VALUES (8, 'EventEquation'); INSERT INTO TABLELIST VALUES (9, 'SignificantPathwayPoint'); INSERT INTO TABLELIST VALUES (10, 'StartPoint'); INSERT INTO TABLELIST VALUES (11, 'Description'); INSERT INTO TABLELIST VALUES (12, 'StartPointRole'); INSERT INTO TABLELIST VALUES (13, 'Name'); INSERT INTO TABLELIST VALUES (14, 'Thing_Name'); INSERT INTO TABLELIST VALUES (15, 'DataSource'); INSERT INTO TABLELIST VALUES (16, 'DataSourceKey'); INSERT INTO TABLELIST VALUES (17, 'CompositeDataSourceKey'); INSERT INTO TABLELIST VALUES (18, 'MetaInformation'); INSERT INTO TABLELIST VALUES (19, 'Publication'); INSERT INTO TABLELIST VALUES (20, 'StartPointParticipant'); INSERT INTO TABLELIST VALUES (21, 'Source'); INSERT INTO TABLELIST VALUES (22, 'Artificial'); INSERT INTO TABLELIST VALUES (23, 'Organism'); INSERT INTO TABLELIST VALUES (24, 'Individual'); INSERT INTO TABLELIST VALUES (25, 'SystematicGroup'); INSERT INTO TABLELIST VALUES (27, 'TargetPoint'); INSERT INTO TABLELIST VALUES (29, 'TargetPointParticipant'); INSERT INTO TABLELIST VALUES (30, 'Location'); INSERT INTO TABLELIST VALUES (31, 'TargetPointRole'); INSERT INTO TABLELIST VALUES (32, 'Histology'); INSERT INTO TABLELIST VALUES (33, 'Modification'); INSERT INTO TABLELIST VALUES (34, 'TemplateForModification'); INSERT INTO TABLELIST VALUES (35, 'ModifiedForm'); INSERT INTO TABLELIST VALUES (36, 'ImmunRegulation'); INSERT INTO TABLELIST VALUES (37, 'StrandBreak'); INSERT INTO TABLELIST VALUES (38, 'Mutation'); INSERT INTO TABLELIST VALUES (39, 'Rearrangement'); INSERT INTO TABLELIST VALUES (40, 'Polymerase'); INSERT INTO TABLELIST VALUES (41, 'ChromosomalLocation'); INSERT INTO TABLELIST VALUES (73, 'Organ'); INSERT INTO TABLELIST VALUES (75, 'MetaInformation_Thing'); INSERT INTO TABLELIST VALUES (77, 'Translation'); INSERT INTO TABLELIST VALUES (78, 'Transcription'); INSERT INTO TABLELIST VALUES (79, 'Splicing'); INSERT INTO TABLELIST VALUES (80, 'Translocation'); INSERT INTO TABLELIST VALUES (81, 'ConformationalChange'); INSERT INTO TABLELIST VALUES (82, 'Expression'); INSERT INTO TABLELIST VALUES (83, 'ControlEvent'); INSERT INTO TABLELIST VALUES (84, 'NegativeControlEvent'); INSERT INTO TABLELIST VALUES (85, 'PositiveControlEvent'); INSERT INTO TABLELIST VALUES (86, 'RegulativeEvent'); INSERT INTO TABLELIST VALUES (87, 'DownRegulation'); INSERT INTO TABLELIST VALUES (88, 'UpRegulation'); INSERT INTO TABLELIST VALUES (89, 'Interaction'); INSERT INTO TABLELIST VALUES (90, 'Reaction'); INSERT INTO TABLELIST VALUES (92, 'Pathway'); INSERT INTO TABLELIST VALUES (93, 'RegulatoryPathway'); INSERT INTO TABLELIST VALUES (94, 'FeedbackLoop'); INSERT INTO TABLELIST VALUES (95, 'SignalTransductionPathway'); INSERT INTO TABLELIST VALUES (96, 'MetabolicPathway'); INSERT INTO TABLELIST VALUES (97, 'LocationType'); INSERT INTO TABLELIST VALUES (98, 'Pathway_Event'); INSERT INTO TABLELIST VALUES (99, 'Effect'); INSERT INTO TABLELIST VALUES (100, 'Pathway_Effect'); INSERT INTO TABLELIST VALUES (101, 'Effect_Event'); INSERT INTO TABLELIST VALUES (102, 'GenericCompound'); INSERT INTO TABLELIST VALUES (103, 'PhysicalTrigger'); INSERT INTO TABLELIST VALUES (104, 'Compound'); INSERT INTO TABLELIST VALUES (105, 'RNA'); INSERT INTO TABLELIST VALUES (106, 'DNA'); INSERT INTO TABLELIST VALUES (107, 'Plasmid'); INSERT INTO TABLELIST VALUES (108, 'Chromosome'); INSERT INTO TABLELIST VALUES (109, 'NucleicAcid'); INSERT INTO TABLELIST VALUES (110, 'Genome'); INSERT INTO TABLELIST VALUES (111, 'GeneticLocus'); INSERT INTO TABLELIST VALUES (113, 'Reliability'); INSERT INTO TABLELIST VALUES (114, 'Disease'); INSERT INTO TABLELIST VALUES (115, 'CDNALibrary'); INSERT INTO TABLELIST VALUES (117, 'Experiment'); INSERT INTO TABLELIST VALUES (118, 'ExpressionExperiment'); INSERT INTO TABLELIST VALUES (120, 'Protein'); INSERT INTO TABLELIST VALUES (121, 'ProteinComplex'); INSERT INTO TABLELIST VALUES (125, 'Gene'); INSERT INTO TABLELIST VALUES (126, 'Protein_Gene'); INSERT INTO TABLELIST VALUES (127, 'Sequence'); INSERT INTO TABLELIST VALUES (128, 'Operon'); INSERT INTO TABLELIST VALUES (129, 'GeneProductSequence'); INSERT INTO TABLELIST VALUES (130, 'ProteinSequence'); INSERT INTO TABLELIST VALUES (131, 'Domain'); INSERT INTO TABLELIST VALUES (132, 'Polymorphism'); INSERT INTO TABLELIST VALUES (133, 'GeneProductPolymorphism'); INSERT INTO TABLELIST VALUES (134, 'ProteinPolymorphism'); INSERT INTO TABLELIST VALUES (135, 'NAPolymorphism'); INSERT INTO TABLELIST VALUES (136, 'SNP'); INSERT INTO TABLELIST VALUES (137, 'GeneVariant'); INSERT INTO TABLELIST VALUES (138, 'NucleicAcidSequence'); INSERT INTO TABLELIST VALUES (139, 'ORF'); INSERT INTO TABLELIST VALUES (140, 'NAPolymorphism_GeneProductPolymorphism'); INSERT INTO TABLELIST VALUES (141, 'ConsensusSequence'); INSERT INTO TABLELIST VALUES (142, 'NAConsensusSequence'); INSERT INTO TABLELIST VALUES (143, 'DNAConsensusSequence'); INSERT INTO TABLELIST VALUES (144, 'RNAConsensusSequence'); INSERT INTO TABLELIST VALUES (145, 'ProteinConsensusSequence'); INSERT INTO TABLELIST VALUES (147, 'Collection'); INSERT INTO TABLELIST VALUES (148, 'EventTypeCollection'); INSERT INTO TABLELIST VALUES (149, 'ProteinClassificationCollection'); INSERT INTO TABLELIST VALUES (150, 'EventType'); INSERT INTO TABLELIST VALUES (151, 'SCRNA'); INSERT INTO TABLELIST VALUES (152, 'MiRNA'); INSERT INTO TABLELIST VALUES (153, 'AATRNA'); INSERT INTO TABLELIST VALUES (155, 'HNRNA'); INSERT INTO TABLELIST VALUES (156, 'GRNA'); INSERT INTO TABLELIST VALUES (157, 'SNoRNA'); INSERT INTO TABLELIST VALUES (158, 'PrimaryTranscript'); INSERT INTO TABLELIST VALUES (159, 'SNRNA'); INSERT INTO TABLELIST VALUES (160, 'RRNA'); INSERT INTO TABLELIST VALUES (161, 'TRNA'); INSERT INTO TABLELIST VALUES (162, 'MRNA'); INSERT INTO TABLELIST VALUES (163, 'DomainClass'); INSERT INTO TABLELIST VALUES (164, 'PromoterClass'); INSERT INTO TABLELIST VALUES (165, 'ProteinFamily'); INSERT INTO TABLELIST VALUES (166, 'EnzymeClass'); INSERT INTO TABLELIST VALUES (167, 'ProteinClassification'); INSERT INTO TABLELIST VALUES (168, 'TranscriptionFactorClass'); INSERT INTO TABLELIST VALUES (169, 'ParticipantClassification'); INSERT INTO TABLELIST VALUES (170, 'Homologues'); INSERT INTO TABLELIST VALUES (171, 'Orthologues'); INSERT INTO TABLELIST VALUES (172, 'Paralogues'); INSERT INTO TABLELIST VALUES (173, 'Isoform'); INSERT INTO TABLELIST VALUES (174, 'ProteinClassification_ProteinClassification'); INSERT INTO TABLELIST VALUES (175, 'ParticipantClassification_Role'); INSERT INTO TABLELIST VALUES (176, 'Homologues_Role'); INSERT INTO TABLELIST VALUES (177, 'TranscriptionUnit'); INSERT INTO TABLELIST VALUES (178, 'SAR'); INSERT INTO TABLELIST VALUES (179, 'ORI'); INSERT INTO TABLELIST VALUES (180, 'BindingSite'); INSERT INTO TABLELIST VALUES (181, 'RegulatoryElement'); INSERT INTO TABLELIST VALUES (182, 'Operator'); INSERT INTO TABLELIST VALUES (183, 'Silencer'); INSERT INTO TABLELIST VALUES (184, 'Promoter'); INSERT INTO TABLELIST VALUES (185, 'Isolator'); INSERT INTO TABLELIST VALUES (186, 'Enhancer'); INSERT INTO TABLELIST VALUES (187, 'SequenceUnit'); INSERT INTO TABLELIST VALUES (188, 'Intron'); INSERT INTO TABLELIST VALUES (189, 'Exon'); INSERT INTO TABLELIST VALUES (190, 'Terminator'); INSERT INTO TABLELIST VALUES (191, 'SignalPeptide'); INSERT INTO TABLELIST VALUES (192, 'TranscriptionUnit_Gene'); INSERT INTO TABLELIST VALUES (193, 'FoundationsForNucDistrMatrix'); INSERT INTO TABLELIST VALUES (194, 'NucDistributionMatrix'); INSERT INTO TABLELIST VALUES (195, 'ParticipantClassification_Participant'); INSERT INTO TABLELIST VALUES (196, 'ParticipantClassification_Collection'); INSERT INTO TABLELIST VALUES (197, 'TranscriptionFactor'); INSERT INTO TABLELIST VALUES (198, 'InhibitorTF'); INSERT INTO TABLELIST VALUES (199, 'ActivatorTF'); INSERT INTO TABLELIST VALUES (200, 'Inducer'); INSERT INTO TABLELIST VALUES (201, 'Repressor'); INSERT INTO TABLELIST VALUES (202, 'Cofactor'); INSERT INTO TABLELIST VALUES (203, 'Substrate'); INSERT INTO TABLELIST VALUES (204, 'Product'); INSERT INTO TABLELIST VALUES (205, 'Educt'); INSERT INTO TABLELIST VALUES (206, 'SideProduct'); INSERT INTO TABLELIST VALUES (207, 'MainProduct'); INSERT INTO TABLELIST VALUES (208, 'SideEduct'); INSERT INTO TABLELIST VALUES (209, 'MainEduct'); INSERT INTO TABLELIST VALUES (210, 'NucDistributionMatrix_TranscriptionFactor'); INSERT INTO TABLELIST VALUES (211, 'SignalEffector'); INSERT INTO TABLELIST VALUES (212, 'SignalReceptor'); INSERT INTO TABLELIST VALUES (213, 'ControlSource'); INSERT INTO TABLELIST VALUES (214, 'ControlTarget'); INSERT INTO TABLELIST VALUES (215, 'Telomere'); INSERT INTO TABLELIST VALUES (216, 'Centromere'); INSERT INTO TABLELIST VALUES (217, 'Catalyst'); INSERT INTO TABLELIST VALUES (218, 'Enzyme'); INSERT INTO TABLELIST VALUES (219, 'Activator'); INSERT INTO TABLELIST VALUES (220, 'Inhibitor'); INSERT INTO TABLELIST VALUES (221, 'Regulator'); INSERT INTO TABLELIST VALUES (222, 'TranscriptionActivity'); INSERT INTO TABLELIST VALUES (223, 'HistoneModification'); INSERT INTO TABLELIST VALUES (224, 'CytosineMethylation'); INSERT INTO TABLELIST VALUES (225, 'NASecondaryStructure'); INSERT INTO TABLELIST VALUES (226, 'ChromatinStructure'); INSERT INTO TABLELIST VALUES (227, 'NAStateProperty'); INSERT INTO TABLELIST VALUES (228, 'StateProperty'); INSERT INTO TABLELIST VALUES (229, 'Open'); INSERT INTO TABLELIST VALUES (230, 'Active'); INSERT INTO TABLELIST VALUES (231, 'BentTo'); INSERT INTO TABLELIST VALUES (232, 'PartOf'); INSERT INTO TABLELIST VALUES (233, 'PeripherallyAssociated'); INSERT INTO TABLELIST VALUES (234, 'Bound'); INSERT INTO TABLELIST VALUES (235, 'LocationStateProperty'); INSERT INTO TABLELIST VALUES (236, 'PhysiologicalProperty'); INSERT INTO TABLELIST VALUES (237, 'Concentration'); INSERT INTO TABLELIST VALUES (238, 'PeripherallyAssociated_Participant'); INSERT INTO TABLELIST VALUES (239, 'Participant_Bound'); INSERT INTO TABLELIST VALUES (240, 'Active_Event'); INSERT INTO TABLELIST VALUES (241, 'State'); INSERT INTO TABLELIST VALUES (242, 'CellCycleState'); INSERT INTO TABLELIST VALUES (243, 'DevelopmentState'); INSERT INTO TABLELIST VALUES (244, 'Condition'); INSERT INTO TABLELIST VALUES (245, 'TemporaryDependency'); INSERT INTO TABLELIST VALUES (246, 'ExperimentalCondition'); INSERT INTO TABLELIST VALUES (247, 'State_StateProperty'); INSERT INTO TABLELIST VALUES (248, 'ExperimentalCondition_Experiment'); INSERT INTO TABLELIST VALUES (250, 'GAP_VECTOR'); INSERT INTO TABLELIST VALUES (251, 'ConservedRegion'); INSERT INTO TABLELIST VALUES (253, 'SubSequencePosition'); INSERT INTO TABLELIST VALUES (254, 'SpecificationRoleState'); INSERT INTO TABLELIST VALUES (255, 'SpecificationEventCondition'); INSERT INTO TABLELIST VALUES (256, 'SpecificationPathwayCondition'); INSERT INTO TABLELIST VALUES (257, 'ID_GENERATOR'); INSERT INTO TABLELIST VALUES (258, 'CLASSNAME'); INSERT INTO TABLELIST VALUES (259, 'TABLELIST'); INSERT INTO TABLELIST VALUES (260, 'ExpressionScheme'); INSERT INTO TABLELIST VALUES (261, 'ExpressionProduct'); INSERT INTO TABLELIST VALUES (262, 'SourceDatabase'); INSERT INTO TABLELIST VALUES (263, 'UserData'); INSERT INTO TABLELIST VALUES (305, 'Method'); INSERT INTO TABLELIST VALUES (310, 'Definition'); INSERT INTO TABLELIST VALUES (347, 'Thing_Thing'); INSERT INTO TABLELIST VALUES (352, 'SpecificationProcessCondition'); INSERT INTO TABLELIST VALUES (353, 'PhysicalTriggerType'); INSERT INTO TABLELIST VALUES (354, 'ConservedRegionPosition'); INSERT INTO TABLELIST VALUES (355, 'EnzymeClass_Reaction'); INSERT INTO TABLELIST VALUES (365, 'Coiling'); INSERT INTO TABLELIST VALUES (366, 'CDNA'); INSERT INTO TABLELIST VALUES (369, 'CDNAClone'); INSERT INTO TABLELIST VALUES (370, 'EST'); INSERT INTO TABLELIST VALUES (374, 'Formula'); INSERT INTO TABLELIST VALUES (379, 'RELATIONS'); INSERT INTO TABLELIST VALUES (380, 'Protein_RNA'); INSERT INTO TABLELIST VALUES (382, 'ExperimentalFunction'); INSERT INTO TABLELIST VALUES (383, 'Tag'); INSERT INTO TABLELIST VALUES (384, 'Hybridization'); INSERT INTO TABLELIST VALUES (385, 'Gene_Tag'); INSERT INTO TABLELIST VALUES (387, 'Protein_Tag'); INSERT INTO TABLELIST VALUES (389, 'A_OCCURENCE'); INSERT INTO TABLELIST VALUES (390, 'C_OCCURENCE'); INSERT INTO TABLELIST VALUES (391, 'G_OCCURENCE'); INSERT INTO TABLELIST VALUES (392, 'T_OCCURENCE'); INSERT INTO TABLELIST VALUES (395, 'State_Condition'); INSERT INTO TABLELIST VALUES (397, 'Query'); INSERT INTO TABLELIST VALUES (398, 'Filter'); INSERT INTO TABLELIST VALUES (399, 'InteractionPathway'); INSERT INTO TABLELIST VALUES (400, 'DataSet'); INSERT INTO TABLELIST VALUES (401, 'DataSet_Thing'); INSERT INTO TABLELIST VALUES (402, 'ExpressionPlatform'); INSERT INTO TABLELIST VALUES (403, 'ExpressionData'); # # Dumping data for table `CLASSNAME` # INSERT INTO CLASSNAME VALUES (6, 6, NULL); INSERT INTO CLASSNAME VALUES (9, 9, 6); INSERT INTO CLASSNAME VALUES (10, 10, 9); INSERT INTO CLASSNAME VALUES (2, 2, 6); INSERT INTO CLASSNAME VALUES (0, 0, 2); INSERT INTO CLASSNAME VALUES (1, 1, 6); INSERT INTO CLASSNAME VALUES (3, 3, NULL); INSERT INTO CLASSNAME VALUES (8, 8, 6); INSERT INTO CLASSNAME VALUES (18, 18, 6); INSERT INTO CLASSNAME VALUES (11, 11, 18); INSERT INTO CLASSNAME VALUES (5, 5, 11); INSERT INTO CLASSNAME VALUES (12, 12, 10); INSERT INTO CLASSNAME VALUES (13, 13, 6); INSERT INTO CLASSNAME VALUES (14, 14, NULL); INSERT INTO CLASSNAME VALUES (15, 15, 18); INSERT INTO CLASSNAME VALUES (16, 16, 18); INSERT INTO CLASSNAME VALUES (17, 17, 16); INSERT INTO CLASSNAME VALUES (19, 19, 15); INSERT INTO CLASSNAME VALUES (20, 20, 10); INSERT INTO CLASSNAME VALUES (21, 21, 18); INSERT INTO CLASSNAME VALUES (22, 22, 21); INSERT INTO CLASSNAME VALUES (23, 23, 21); INSERT INTO CLASSNAME VALUES (24, 24, 23); INSERT INTO CLASSNAME VALUES (25, 25, 6); INSERT INTO CLASSNAME VALUES (27, 27, 9); INSERT INTO CLASSNAME VALUES (29, 29, 27); INSERT INTO CLASSNAME VALUES (30, 30, 18); INSERT INTO CLASSNAME VALUES (31, 31, 27); INSERT INTO CLASSNAME VALUES (32, 32, 18); INSERT INTO CLASSNAME VALUES (33, 33, 0); INSERT INTO CLASSNAME VALUES (34, 34, 1); INSERT INTO CLASSNAME VALUES (35, 35, 1); INSERT INTO CLASSNAME VALUES (36, 36, 0); INSERT INTO CLASSNAME VALUES (37, 37, 33); INSERT INTO CLASSNAME VALUES (38, 38, 33); INSERT INTO CLASSNAME VALUES (39, 39, 33); INSERT INTO CLASSNAME VALUES (41, 41, 18); INSERT INTO CLASSNAME VALUES (73, 73, 18); INSERT INTO CLASSNAME VALUES (75, 75, NULL); INSERT INTO CLASSNAME VALUES (77, 77, 0); INSERT INTO CLASSNAME VALUES (78, 78, 0); INSERT INTO CLASSNAME VALUES (79, 79, 0); INSERT INTO CLASSNAME VALUES (89, 89, 0); INSERT INTO CLASSNAME VALUES (90, 90, 89); INSERT INTO CLASSNAME VALUES (80, 80, 90); INSERT INTO CLASSNAME VALUES (81, 81, 0); INSERT INTO CLASSNAME VALUES (82, 82, 0); INSERT INTO CLASSNAME VALUES (83, 83, 0); INSERT INTO CLASSNAME VALUES (84, 84, 83); INSERT INTO CLASSNAME VALUES (85, 85, 83); INSERT INTO CLASSNAME VALUES (86, 86, 83); INSERT INTO CLASSNAME VALUES (87, 87, 86); INSERT INTO CLASSNAME VALUES (88, 88, 86); INSERT INTO CLASSNAME VALUES (92, 92, 2); INSERT INTO CLASSNAME VALUES (93, 93, 92); INSERT INTO CLASSNAME VALUES (94, 94, 93); INSERT INTO CLASSNAME VALUES (95, 95, 93); INSERT INTO CLASSNAME VALUES (98, 98, NULL); INSERT INTO CLASSNAME VALUES (99, 99, 6); INSERT INTO CLASSNAME VALUES (100, 100, NULL); INSERT INTO CLASSNAME VALUES (101, 101, NULL); INSERT INTO CLASSNAME VALUES (102, 102, 2); INSERT INTO CLASSNAME VALUES (103, 103, 2); INSERT INTO CLASSNAME VALUES (109, 109, 102); INSERT INTO CLASSNAME VALUES (104, 104, 102); INSERT INTO CLASSNAME VALUES (105, 105, 109); INSERT INTO CLASSNAME VALUES (106, 106, 109); INSERT INTO CLASSNAME VALUES (107, 107, 106); INSERT INTO CLASSNAME VALUES (108, 108, 2); INSERT INTO CLASSNAME VALUES (110, 110, 6); INSERT INTO CLASSNAME VALUES (111, 111, 6); INSERT INTO CLASSNAME VALUES (113, 113, 18); INSERT INTO CLASSNAME VALUES (114, 114, 18); INSERT INTO CLASSNAME VALUES (115, 115, 21); INSERT INTO CLASSNAME VALUES (117, 117, 18); INSERT INTO CLASSNAME VALUES (118, 118, 117); INSERT INTO CLASSNAME VALUES (120, 120, 102); INSERT INTO CLASSNAME VALUES (121, 121, 120); INSERT INTO CLASSNAME VALUES (125, 125, 2); INSERT INTO CLASSNAME VALUES (126, 126, NULL); INSERT INTO CLASSNAME VALUES (127, 127, 2); INSERT INTO CLASSNAME VALUES (128, 128, 127); INSERT INTO CLASSNAME VALUES (129, 129, 127); INSERT INTO CLASSNAME VALUES (130, 130, 129); INSERT INTO CLASSNAME VALUES (131, 131, 130); INSERT INTO CLASSNAME VALUES (132, 132, 127); INSERT INTO CLASSNAME VALUES (133, 133, 132); INSERT INTO CLASSNAME VALUES (134, 134, 133); INSERT INTO CLASSNAME VALUES (135, 135, 132); INSERT INTO CLASSNAME VALUES (136, 136, 135); INSERT INTO CLASSNAME VALUES (138, 138, 127); INSERT INTO CLASSNAME VALUES (137, 137, 138); INSERT INTO CLASSNAME VALUES (139, 139, 138); INSERT INTO CLASSNAME VALUES (140, 140, NULL); INSERT INTO CLASSNAME VALUES (141, 141, 127); INSERT INTO CLASSNAME VALUES (142, 142, 141); INSERT INTO CLASSNAME VALUES (143, 143, 142); INSERT INTO CLASSNAME VALUES (144, 144, 142); INSERT INTO CLASSNAME VALUES (145, 145, 141); INSERT INTO CLASSNAME VALUES (147, 147, 10); INSERT INTO CLASSNAME VALUES (148, 148, 147); INSERT INTO CLASSNAME VALUES (149, 149, 147); INSERT INTO CLASSNAME VALUES (169, 169, 2); INSERT INTO CLASSNAME VALUES (97, 97, 169); INSERT INTO CLASSNAME VALUES (150, 150, 169); INSERT INTO CLASSNAME VALUES (158, 158, 105); INSERT INTO CLASSNAME VALUES (151, 151, 105); INSERT INTO CLASSNAME VALUES (152, 152, 105); INSERT INTO CLASSNAME VALUES (153, 153, 105); INSERT INTO CLASSNAME VALUES (155, 155, 105); INSERT INTO CLASSNAME VALUES (156, 156, 105); INSERT INTO CLASSNAME VALUES (157, 157, 105); INSERT INTO CLASSNAME VALUES (159, 159, 105); INSERT INTO CLASSNAME VALUES (160, 160, 105); INSERT INTO CLASSNAME VALUES (161, 161, 105); INSERT INTO CLASSNAME VALUES (162, 162, 105); INSERT INTO CLASSNAME VALUES (163, 163, 169); INSERT INTO CLASSNAME VALUES (164, 164, 169); INSERT INTO CLASSNAME VALUES (167, 167, 169); INSERT INTO CLASSNAME VALUES (165, 165, 167); INSERT INTO CLASSNAME VALUES (166, 166, 167); INSERT INTO CLASSNAME VALUES (168, 168, 167); INSERT INTO CLASSNAME VALUES (170, 170, 169); INSERT INTO CLASSNAME VALUES (171, 171, 170); INSERT INTO CLASSNAME VALUES (172, 172, 170); INSERT INTO CLASSNAME VALUES (173, 173, 170); INSERT INTO CLASSNAME VALUES (174, 174, NULL); INSERT INTO CLASSNAME VALUES (175, 175, NULL); INSERT INTO CLASSNAME VALUES (176, 176, NULL); INSERT INTO CLASSNAME VALUES (187, 187, 1); INSERT INTO CLASSNAME VALUES (177, 177, 187); INSERT INTO CLASSNAME VALUES (178, 178, 187); INSERT INTO CLASSNAME VALUES (179, 179, 187); INSERT INTO CLASSNAME VALUES (180, 180, 187); INSERT INTO CLASSNAME VALUES (181, 181, 180); INSERT INTO CLASSNAME VALUES (182, 182, 181); INSERT INTO CLASSNAME VALUES (183, 183, 181); INSERT INTO CLASSNAME VALUES (184, 184, 181); INSERT INTO CLASSNAME VALUES (185, 185, 181); INSERT INTO CLASSNAME VALUES (186, 186, 181); INSERT INTO CLASSNAME VALUES (188, 188, 187); INSERT INTO CLASSNAME VALUES (189, 189, 187); INSERT INTO CLASSNAME VALUES (190, 190, 187); INSERT INTO CLASSNAME VALUES (191, 191, 187); INSERT INTO CLASSNAME VALUES (192, 192, NULL); INSERT INTO CLASSNAME VALUES (193, 193, 6); INSERT INTO CLASSNAME VALUES (194, 194, 6); INSERT INTO CLASSNAME VALUES (195, 195, NULL); INSERT INTO CLASSNAME VALUES (196, 196, NULL); INSERT INTO CLASSNAME VALUES (197, 197, 1); INSERT INTO CLASSNAME VALUES (198, 198, 197); INSERT INTO CLASSNAME VALUES (199, 199, 197); INSERT INTO CLASSNAME VALUES (200, 200, 197); INSERT INTO CLASSNAME VALUES (201, 201, 197); INSERT INTO CLASSNAME VALUES (202, 202, 1); INSERT INTO CLASSNAME VALUES (203, 203, 1); INSERT INTO CLASSNAME VALUES (204, 204, 203); INSERT INTO CLASSNAME VALUES (205, 205, 203); INSERT INTO CLASSNAME VALUES (206, 206, 204); INSERT INTO CLASSNAME VALUES (207, 207, 204); INSERT INTO CLASSNAME VALUES (208, 208, 205); INSERT INTO CLASSNAME VALUES (209, 209, 205); INSERT INTO CLASSNAME VALUES (210, 210, NULL); INSERT INTO CLASSNAME VALUES (211, 211, 1); INSERT INTO CLASSNAME VALUES (212, 212, 1); INSERT INTO CLASSNAME VALUES (213, 213, 1); INSERT INTO CLASSNAME VALUES (214, 214, 1); INSERT INTO CLASSNAME VALUES (215, 215, 1); INSERT INTO CLASSNAME VALUES (216, 216, 1); INSERT INTO CLASSNAME VALUES (217, 217, 1); INSERT INTO CLASSNAME VALUES (218, 218, 217); INSERT INTO CLASSNAME VALUES (40, 40, 218); INSERT INTO CLASSNAME VALUES (221, 221, 1); INSERT INTO CLASSNAME VALUES (219, 219, 221); INSERT INTO CLASSNAME VALUES (220, 220, 221); INSERT INTO CLASSNAME VALUES (228, 228, 6); INSERT INTO CLASSNAME VALUES (227, 227, 228); INSERT INTO CLASSNAME VALUES (222, 222, 227); INSERT INTO CLASSNAME VALUES (223, 223, 227); INSERT INTO CLASSNAME VALUES (224, 224, 227); INSERT INTO CLASSNAME VALUES (225, 225, 227); INSERT INTO CLASSNAME VALUES (226, 226, 227); INSERT INTO CLASSNAME VALUES (229, 229, 228); INSERT INTO CLASSNAME VALUES (230, 230, 228); INSERT INTO CLASSNAME VALUES (231, 231, 228); INSERT INTO CLASSNAME VALUES (232, 232, 228); INSERT INTO CLASSNAME VALUES (233, 233, 228); INSERT INTO CLASSNAME VALUES (234, 234, 228); INSERT INTO CLASSNAME VALUES (235, 235, 228); INSERT INTO CLASSNAME VALUES (236, 236, 235); INSERT INTO CLASSNAME VALUES (237, 237, 235); INSERT INTO CLASSNAME VALUES (238, 238, NULL); INSERT INTO CLASSNAME VALUES (239, 239, NULL); INSERT INTO CLASSNAME VALUES (240, 240, NULL); INSERT INTO CLASSNAME VALUES (241, 241, 6); INSERT INTO CLASSNAME VALUES (242, 242, 241); INSERT INTO CLASSNAME VALUES (243, 243, 241); INSERT INTO CLASSNAME VALUES (244, 244, 6); INSERT INTO CLASSNAME VALUES (245, 245, 244); INSERT INTO CLASSNAME VALUES (246, 246, 244); INSERT INTO CLASSNAME VALUES (247, 247, NULL); INSERT INTO CLASSNAME VALUES (248, 248, NULL); INSERT INTO CLASSNAME VALUES (250, 250, NULL); INSERT INTO CLASSNAME VALUES (251, 251, NULL); INSERT INTO CLASSNAME VALUES (253, 253, 6); INSERT INTO CLASSNAME VALUES (254, 254, 6); INSERT INTO CLASSNAME VALUES (352, 352, 6); INSERT INTO CLASSNAME VALUES (255, 255, 352); INSERT INTO CLASSNAME VALUES (256, 256, 352); INSERT INTO CLASSNAME VALUES (257, 257, NULL); INSERT INTO CLASSNAME VALUES (258, 258, NULL); INSERT INTO CLASSNAME VALUES (259, 259, NULL); INSERT INTO CLASSNAME VALUES (260, 260, 1); INSERT INTO CLASSNAME VALUES (261, 261, 1); INSERT INTO CLASSNAME VALUES (262, 262, 15); INSERT INTO CLASSNAME VALUES (263, 263, 15); INSERT INTO CLASSNAME VALUES (305, 305, 18); INSERT INTO CLASSNAME VALUES (310, 310, 18); INSERT INTO CLASSNAME VALUES (347, 347, NULL); INSERT INTO CLASSNAME VALUES (353, 353, 169); INSERT INTO CLASSNAME VALUES (354, 354, 253); INSERT INTO CLASSNAME VALUES (355, 355, NULL); INSERT INTO CLASSNAME VALUES (365, 365, 227); INSERT INTO CLASSNAME VALUES (366, 366, 106); INSERT INTO CLASSNAME VALUES (369, 369, 366); INSERT INTO CLASSNAME VALUES (370, 370, 366); INSERT INTO CLASSNAME VALUES (374, 374, 6); INSERT INTO CLASSNAME VALUES (379, 379, NULL); INSERT INTO CLASSNAME VALUES (380, 380, NULL); INSERT INTO CLASSNAME VALUES (382, 382, 1); INSERT INTO CLASSNAME VALUES (383, 383, 382); INSERT INTO CLASSNAME VALUES (384, 384, 0); INSERT INTO CLASSNAME VALUES (385, 385, NULL); INSERT INTO CLASSNAME VALUES (387, 387, NULL); INSERT INTO CLASSNAME VALUES (389, 389, NULL); INSERT INTO CLASSNAME VALUES (390, 390, NULL); INSERT INTO CLASSNAME VALUES (391, 391, NULL); INSERT INTO CLASSNAME VALUES (392, 392, NULL); INSERT INTO CLASSNAME VALUES (395, 395, NULL); INSERT INTO CLASSNAME VALUES (397, 397, 6); INSERT INTO CLASSNAME VALUES (398, 398, 6); INSERT INTO CLASSNAME VALUES (399, 399, 92); INSERT INTO CLASSNAME VALUES (96, 96, 399); INSERT INTO CLASSNAME VALUES (400, 400, 6); INSERT INTO CLASSNAME VALUES (401, 401, NULL); INSERT INTO CLASSNAME VALUES (402, 402, NULL); INSERT INTO CLASSNAME VALUES (403, 403, NULL); INSERT INTO RELATIONS VALUES ('Event', 'Event', 'reverseevent', '1'); INSERT INTO RELATIONS VALUES ('Event', 'Role', 'event', '1'); INSERT INTO RELATIONS VALUES ('Event', 'SpecificationEventCondition', 'event', '0'); INSERT INTO RELATIONS VALUES ('Event', 'EventEquation', 'event', '0'); INSERT INTO RELATIONS VALUES ('Participant', 'Role', 'participant', '0'); INSERT INTO RELATIONS VALUES ('Participant', 'BindingSite', 'participant', '1'); INSERT INTO RELATIONS VALUES ('Participant', 'PartOf', 'participant', '0'); INSERT INTO RELATIONS VALUES ('Participant', 'StartPointParticipant', 'participant', '0'); INSERT INTO RELATIONS VALUES ('Participant', 'TargetPointParticipant', 'participant', '0'); INSERT INTO RELATIONS VALUES ('Participant', 'Formula', 'participant', '0'); INSERT INTO RELATIONS VALUES ('Participant', 'State', 'participant', '0'); INSERT INTO RELATIONS VALUES ('EventType', 'Role', 'eventtype', '1'); INSERT INTO RELATIONS VALUES ('DataSource', 'DataSourceKey', 'datasource', '0'); INSERT INTO RELATIONS VALUES ('DataSource', 'Collection', 'datasource', '0'); INSERT INTO RELATIONS VALUES ('SystematicGroup', 'Organism', 'systematicgroup', '1'); INSERT INTO RELATIONS VALUES ('Pathway', 'Pathway', 'pathway', '1'); INSERT INTO RELATIONS VALUES ('Pathway', 'SpecificationPathwayCondition', 'pathway', '0'); INSERT INTO RELATIONS VALUES ('Pathway', 'SignificantPathwayPoint', 'pathway', '0'); INSERT INTO RELATIONS VALUES ('NucleicAcid', 'Chromosome', 'nucleicacid', '0'); INSERT INTO RELATIONS VALUES ('Genome', 'NucleicAcid', 'genome', '1'); INSERT INTO RELATIONS VALUES ('Genome', 'GeneticLocus', 'genome', '0'); INSERT INTO RELATIONS VALUES ('Genome', 'NucleicAcidSequence', 'genome', '1'); INSERT INTO RELATIONS VALUES ('NucleicAcid', 'Gene', 'nucleicacid', '0'); INSERT INTO RELATIONS VALUES ('NucleicAcid', 'NucleicAcidSequence', 'nucleicacid', '0'); INSERT INTO RELATIONS VALUES ('Gene', 'GeneticLocus', 'gene', '0'); INSERT INTO RELATIONS VALUES ('Gene', 'GeneVariant', 'gene', '0'); INSERT INTO RELATIONS VALUES ('GenericCompound', 'Concentration', 'genericcompound', '0'); INSERT INTO RELATIONS VALUES ('Operon', 'Gene', 'operon', '1'); INSERT INTO RELATIONS VALUES ('Protein', 'GeneProductSequence', 'protein', '0'); INSERT INTO RELATIONS VALUES ('Protein', 'GeneProductPolymorphism', 'protein', '0'); INSERT INTO RELATIONS VALUES ('Sequence', 'Polymorphism', 'sequence', '0'); INSERT INTO RELATIONS VALUES ('Sequence', 'SubSequencePosition', 'parent', '0'); INSERT INTO RELATIONS VALUES ('Sequence', 'SubSequencePosition', 'child', '0'); INSERT INTO RELATIONS VALUES ('GeneVariant', 'NAPolymorphism', 'genevariant', '0'); INSERT INTO RELATIONS VALUES ('NucDistributionMatrix', 'FoundationsForNucDistrMatrix', 'nucdistributionmatrix', '0'); INSERT INTO RELATIONS VALUES ('BindingSite', 'FoundationsForNucDistrMatrix', 'bindingsite', '0'); INSERT INTO RELATIONS VALUES ('NAConsensusSequence', 'NucDistributionMatrix', 'naconsensussequence', '0'); INSERT INTO RELATIONS VALUES ('NucleicAcidSequence', 'BentTo', 'nucleicacidsequence_a', '0'); INSERT INTO RELATIONS VALUES ('NucleicAcidSequence', 'BentTo', 'nucleicacidsequence_b', '0'); INSERT INTO RELATIONS VALUES ('Condition', 'SpecificationProcessCondition', 'condition', '0'); INSERT INTO RELATIONS VALUES ('State', 'SpecificationRoleState', 'state', '0'); INSERT INTO RELATIONS VALUES ('Role', 'SpecificationRoleState', 'role', '0'); INSERT INTO RELATIONS VALUES ('Role', 'StartPointRole', 'role', '0'); INSERT INTO RELATIONS VALUES ('Role', 'TargetPointRole', 'role', '0'); INSERT INTO RELATIONS VALUES ('ConservedRegion', 'ConservedRegionPosition','conservedregion', '0'); INSERT INTO RELATIONS VALUES ('Chromosome', 'GeneticLocus', 'chromosome', '1'); INSERT INTO RELATIONS VALUES ('CDNA', 'EST', 'cdna', '0'); INSERT INTO RELATIONS VALUES ('Query', 'Filter', 'query', '1'); # # Dumping data for table `TABLELIST` # INSERT INTO TABLEATTRIBUTES VALUES ('Event', 'REVERSE'); INSERT INTO TABLEATTRIBUTES VALUES ('Event', 'SUSPECTED'); INSERT INTO TABLEATTRIBUTES VALUES ('Event', 'PROBABILITY'); INSERT INTO TABLEATTRIBUTES VALUES ('Event', 'INTRAMOLECULAR'); INSERT INTO TABLEATTRIBUTES VALUES ('Role', 'STOICHIOMETRIC_COEFFICIENT'); INSERT INTO TABLEATTRIBUTES VALUES ('Participant', 'TOXICITY'); INSERT INTO TABLEATTRIBUTES VALUES ('Role_Role', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('FunctionalDescription', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Thing', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('EventEquation', 'EQUATION'); INSERT INTO TABLEATTRIBUTES VALUES ('SignificantPathwayPoint', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('StartPoint', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Description', 'DESCRIPTION'); INSERT INTO TABLEATTRIBUTES VALUES ('StartPointRole', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Name', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Thing_Name', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('DataSource', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('DataSourceKey', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('CompositeDataSourceKey', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('MetaInformation', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Publication', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('StartPointParticipant', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Source', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Artificial', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Organism', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Individual', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SystematicGroup', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Organism_SystematicGroup', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TargetPoint', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('MetaInformation_DataSourceKey', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TargetPointParticipant', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Location', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TargetPointRole', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Histology', 'HISTOLOGY'); INSERT INTO TABLEATTRIBUTES VALUES ('Modification', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TemplateForModification', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ModifiedForm', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ImmunRegulation', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('StrandBreak', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Mutation', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Rearrangement', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Polymerase', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ChromosomalLocation', 'CHROMOSOMALLOCATION'); INSERT INTO TABLEATTRIBUTES VALUES ('Organ', 'ORGAN'); INSERT INTO TABLEATTRIBUTES VALUES ('MetaInformation_Thing', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Translation', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Transcription', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Splicing', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Translocation', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ConformationalChange', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Expression', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ControlEvent', 'FACTOR'); INSERT INTO TABLEATTRIBUTES VALUES ('NegativeControlEvent', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('PositiveControlEvent', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('RegulativeEvent', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('DownRegulation', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('UpRegulation', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Interaction', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Reaction', 'AFFINITY'); INSERT INTO TABLEATTRIBUTES VALUES ('Reaction', 'ASSOCIATION_CONSTANT'); INSERT INTO TABLEATTRIBUTES VALUES ('Reaction', 'DISSOCIATION_CONSTANT'); INSERT INTO TABLEATTRIBUTES VALUES ('Reaction', 'SPECIFICITY'); INSERT INTO TABLEATTRIBUTES VALUES ('Reaction', 'DIRECTION'); INSERT INTO TABLEATTRIBUTES VALUES ('Pathway', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('RegulatoryPathway', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('FeedbackLoop', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SignalTransductionPathway', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('MetabolicPathway', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('InteractionPathway', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('LocationType', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Pathway_Event', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Effect', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Pathway_Effect', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Effect_Event', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('GenericCompound', 'MOLECULARWEIGHT'); INSERT INTO TABLEATTRIBUTES VALUES ('PhysicalTrigger', 'TYPE'); INSERT INTO TABLEATTRIBUTES VALUES ('Compound', 'SMILES'); INSERT INTO TABLEATTRIBUTES VALUES ('Compound', 'SMARTS'); INSERT INTO TABLEATTRIBUTES VALUES ('RNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('DNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Plasmid', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Chromosome', 'NUMBER'); INSERT INTO TABLEATTRIBUTES VALUES ('Chromosome', 'LENGTH'); INSERT INTO TABLEATTRIBUTES VALUES ('NucleicAcid', 'LENGTH'); INSERT INTO TABLEATTRIBUTES VALUES ('Genome', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('GeneticLocus', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Reliability', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Disease', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('cDNALibrary', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Experiment', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('IsoelectricPoint', 'ISOELECTRIC_POINT'); INSERT INTO TABLEATTRIBUTES VALUES ('Protein', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Gene', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Protein_Gene', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Sequence', 'SEQUENCE'); INSERT INTO TABLEATTRIBUTES VALUES ('Sequence', 'STRAND'); INSERT INTO TABLEATTRIBUTES VALUES ('Sequence', 'LENGTH'); INSERT INTO TABLEATTRIBUTES VALUES ('Operon', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('GeneProductSequence', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ProteinSequence', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Domain', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Polymorphism', 'REPLACE_ATTRIBUT'); INSERT INTO TABLEATTRIBUTES VALUES ('Polymorphism', 'REPLACED_BY'); INSERT INTO TABLEATTRIBUTES VALUES ('GeneProductPolymorphism', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ProteinPolymorphism', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('NAPolymorphism', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SNP', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('GeneVariant', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('NucleicAcidSequence', 'WHOLE_GENOME_SEQUENCE'); INSERT INTO TABLEATTRIBUTES VALUES ('ORF', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('NAPolymorphism_GeneProductPolymorphism', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ConsensusSequence', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('NAConsensusSequence', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('DNAConsensusSequence', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('RNAConsensusSequence', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ProteinConsensusSequence', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Collection', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('EventTypeCollection', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ProteinClassificationCollection', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('EventType', 'REVERSE'); INSERT INTO TABLEATTRIBUTES VALUES ('scRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('miRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('AATRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('hnRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('gRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('snoRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('PrimaryTranscript', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('snRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('rRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('tRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('mRNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('DomainClass', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('PromoterClass', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ProteinFamily', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('EnzymeClass', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ProteinClassification', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TranscriptionFactorClass', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ParticipantClassification', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Homologues', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Orthologues', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Paralogues', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Isoform', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ProteinClassification_ProteinClassification', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ParticipantClassification_Role', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Homologues_Role', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TranscriptionUnit', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SAR', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ORI', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('BindingSite', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('RegulatoryElement', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Operator', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Silencer', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Promoter', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Isolator', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Enhancer', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SequenceUnit', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Intron', 'NUMBER'); INSERT INTO TABLEATTRIBUTES VALUES ('Exon', 'NUMBER'); INSERT INTO TABLEATTRIBUTES VALUES ('Terminator', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SignalPeptide', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TranscriptionUnit_Gene', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('FoundationsForNucDistrMatrix', 'START'); INSERT INTO TABLEATTRIBUTES VALUES ('FoundationsForNucDistrMatrix', 'LENGTH'); INSERT INTO TABLEATTRIBUTES VALUES ('FoundationsForNucDistrMatrix', 'ORIENTATION'); INSERT INTO TABLEATTRIBUTES VALUES ('FoundationsForNucDistrMatrix', 'GAP_VECTOR'); INSERT INTO TABLEATTRIBUTES VALUES ('NucDistributionMatrix', 'STATISTICAL_BASIS'); INSERT INTO TABLEATTRIBUTES VALUES ('NucDistributionMatrix', 'A_OCCURENCE'); INSERT INTO TABLEATTRIBUTES VALUES ('NucDistributionMatrix', 'C_OCCURENCE'); INSERT INTO TABLEATTRIBUTES VALUES ('NucDistributionMatrix', 'G_OCCURENCE'); INSERT INTO TABLEATTRIBUTES VALUES ('NucDistributionMatrix', 'T_OCCURENCE'); INSERT INTO TABLEATTRIBUTES VALUES ('ParticipantClassification_Participant', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ParticipantClassification_Collection', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TranscriptionFactor', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('InhibitorTF', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ActivatorTF', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Inducer', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Repressor', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Cofactor', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Substrate', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Product', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Educt', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SideProduct', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('MainProduct', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SideEduct', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('MainEduct', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TranscriptionFactor_NucDistributionMatrix', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SignalEffector', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SignalReceptor', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ControlSource', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ControlTarget', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Telomere', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Centromere', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Catalyst', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Enzyme', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Activator', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Inhibitor', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Regulator', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TranscriptionActivity', 'VALUE_FLOAT'); INSERT INTO TABLEATTRIBUTES VALUES ('HistoneModification', 'SERINE_PHPSPHORYLATION'); INSERT INTO TABLEATTRIBUTES VALUES ('HistoneModification', 'LYSINE_METHYLATION'); INSERT INTO TABLEATTRIBUTES VALUES ('HistoneModification', 'LYSINE_ACETYLATION'); INSERT INTO TABLEATTRIBUTES VALUES ('HistoneModification', 'LYSINE_UBIQUITYLATION'); INSERT INTO TABLEATTRIBUTES VALUES ('HistoneModification', 'ARGININ_METHYLATION'); INSERT INTO TABLEATTRIBUTES VALUES ('CytosineMethylation', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('NASecondaryStructure', 'VALUE_STRING'); INSERT INTO TABLEATTRIBUTES VALUES ('ChromatinStructure', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('NAStateProperty', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('StateProperty', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Open', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Active', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('BentTo', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('PartOf', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('PeripherallyAssociated', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Bound', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('LocationStateProperty', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('PhysiologicalProperty', 'MIN'); INSERT INTO TABLEATTRIBUTES VALUES ('PhysiologicalProperty', 'MAX'); INSERT INTO TABLEATTRIBUTES VALUES ('PhysiologicalProperty', 'UNIT'); INSERT INTO TABLEATTRIBUTES VALUES ('PhysiologicalProperty', 'TYPE'); INSERT INTO TABLEATTRIBUTES VALUES ('Concentration', 'MIN'); INSERT INTO TABLEATTRIBUTES VALUES ('Concentration', 'MAX'); INSERT INTO TABLEATTRIBUTES VALUES ('Concentration', 'UNIT'); INSERT INTO TABLEATTRIBUTES VALUES ('PeripherallyAssociated_Participant', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Participant_Bound', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Active_Event', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('State', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('CellCycleState', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('DevelopmentState', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Condition', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TemporaryDependency', 'MIN'); INSERT INTO TABLEATTRIBUTES VALUES ('TemporaryDependency', 'MAX'); INSERT INTO TABLEATTRIBUTES VALUES ('TemporaryDependency', 'UNIT'); INSERT INTO TABLEATTRIBUTES VALUES ('ExperimentalCondition', 'GENERAL'); INSERT INTO TABLEATTRIBUTES VALUES ('ExperimentalCondition', 'SYSTEM'); INSERT INTO TABLEATTRIBUTES VALUES ('State_StateProperty', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ExperimentalCondition_Experiment', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('IntList', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ConservedRegions', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SubSequencePosition', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SpecificationRoleState', 'ORDER_SPECIFICATION'); INSERT INTO TABLEATTRIBUTES VALUES ('SpecificationEventCondition', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SpecificationPathwayCondition', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ID_GENERATOR', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('CLASSNAME', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('TABLEATTRIBUTES', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ExpressionScheme', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ExpressionProduct', 'DOUBLE'); INSERT INTO TABLEATTRIBUTES VALUES ('SourceDatabase', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('UserData', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Method', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Definition', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Thing_Thing', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('SpecificationProcessCondition', 'ORDER_SPECIFICATION'); INSERT INTO TABLEATTRIBUTES VALUES ('PhysicalTriggerType', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ConservedRegionPosition', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('EnzymeClass_Reaction', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Coiling', 'VALUE_FLOAT'); INSERT INTO TABLEATTRIBUTES VALUES ('cDNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('cDNAClone', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('EST', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Formula', 'FORMULA'); INSERT INTO TABLEATTRIBUTES VALUES ('RELATIONS', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Protein_RNA', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('ExperimentalFunction', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Tag', 'UNIT'); INSERT INTO TABLEATTRIBUTES VALUES ('Tag', 'LEVEL'); INSERT INTO TABLEATTRIBUTES VALUES ('Hybridization', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Gene_Tag', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Protein_Tag', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('Query', 'CLASS'); INSERT INTO TABLEATTRIBUTES VALUES ('Query', 'ATTRIBUTE'); INSERT INTO TABLEATTRIBUTES VALUES ('Query', 'OPERATOR'); INSERT INTO TABLEATTRIBUTES VALUES ('Query', 'VALUE'); INSERT INTO TABLEATTRIBUTES VALUES ('Filter', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('DataSet_Thing', NULL); INSERT INTO TABLEATTRIBUTES VALUES ('DataSet', 'DESCRIPTION'); INSERT INTO TABLEATTRIBUTES VALUES ('ExpressionExperiment', 'CHIP'); INSERT INTO TABLEATTRIBUTES VALUES ('ExpressionExperiment', 'MEDIAN'); INSERT INTO TABLEATTRIBUTES VALUES ('ExpressionExperiment', 'MEAN'); INSERT INTO TABLEATTRIBUTES VALUES ('ExpressionExperiment', 'VARIANCE'); INSERT INTO TABLEATTRIBUTES VALUES ('ExpressionExperiment', 'MIN'); INSERT INTO TABLEATTRIBUTES VALUES ('ExpressionExperiment', 'MAX'); # # Dumping data for table `ID_GENERATOR` # #INSERT INTO ID_GENERATOR VALUES (555819297); INSERT INTO ID_GENERATOR VALUES (100); set foreign_key_checks=1;