diff options
| author | Pjotr Prins <pjotr.public01@thebird.nl> | 2026-10-03 10:56:10 +0000 |
|---|---|---|
| committer | Pjotr <wrk@bosa.lan> | 2026-10-03 10:56:10 +0000 |
| commit | eb18351880af6eb978103eb902855f668206dbec (patch) | |
| tree | 6c31b338c1c446ef9ad8b574ce13963ce22a0e0f /docs | |
| parent | 13c3ecfe01c9272b91f10dd8e2941e5f14e6a5fb (diff) | |
| download | genenetwork4-eb18351880af6eb978103eb902855f668206dbec.tar.gz | |
doc: Add db_webqtl MariaDB schema dump.
* docs/mariadb_db-webqtl.md: New file. CREATE TABLE statement for each of the 112 tables in db_webqtl, dumped with mysqldump --no-data and grouped under a linked table of contents.
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/mariadb_db-webqtl.md | 2204 |
1 files changed, 2204 insertions, 0 deletions
diff --git a/docs/mariadb_db-webqtl.md b/docs/mariadb_db-webqtl.md new file mode 100644 index 0000000..66d923a --- /dev/null +++ b/docs/mariadb_db-webqtl.md @@ -0,0 +1,2204 @@ +# db_webqtl MariaDB schema + +Table definitions dumped from `db_webqtl` via +`mysqldump --no-data`. Schema only, no data. + +## Tables + +- [AccessLog](#accesslog) +- [AvgMethod](#avgmethod) +- [BACKUP_CaseAttribute_20240601T01_34_02__842794](#backup_caseattribute_20240601t01_34_02__842794) +- [BACKUP_CaseAttributeXRefNew_20240601T01_34_02__842794](#backup_caseattributexrefnew_20240601t01_34_02__842794) +- [BXDSnpPosition](#bxdsnpposition) +- [CaseAttribute](#caseattribute) +- [caseattributes_audit](#caseattributes_audit) +- [CaseAttributeXRef](#caseattributexref) +- [CaseAttributeXRefNew](#caseattributexrefnew) +- [CeleraINFO_mm6](#celerainfo_mm6) +- [Chr_Length](#chr_length) +- [Dataset_mbat](#dataset_mbat) +- [DatasetMapInvestigator](#datasetmapinvestigator) +- [Datasets](#datasets) +- [DatasetStatus](#datasetstatus) +- [DBList](#dblist) +- [DBType](#dbtype) +- [Docs](#docs) +- [EnsemblChip](#ensemblchip) +- [EnsemblProbe](#ensemblprobe) +- [EnsemblProbeLocation](#ensemblprobelocation) +- [Genbank](#genbank) +- [GeneCategory](#genecategory) +- [GeneChip](#genechip) +- [GeneChipEnsemblXRef](#genechipensemblxref) +- [GeneIDXRef](#geneidxref) +- [GeneInfo](#geneinfo) +- [GeneList](#genelist) +- [GeneList081722](#genelist081722) +- [GeneList_rn3](#genelist_rn3) +- [GeneList_rn33](#genelist_rn33) +- [GeneMap_cuiyan](#genemap_cuiyan) +- [GeneRIF](#generif) +- [GeneRIF_BASIC](#generif_basic) +- [GeneRIFXRef](#generifxref) +- [Geno](#geno) +- [GenoCode](#genocode) +- [GenoData](#genodata) +- [GenoFile](#genofile) +- [GenoFreeze](#genofreeze) +- [GenoSE](#genose) +- [GenoXRef](#genoxref) +- [GORef](#goref) +- [H2](#h2) +- [Homologene](#homologene) +- [InbredSet](#inbredset) +- [InbredSetMapInvestigator](#inbredsetmapinvestigator) +- [IndelAll](#indelall) +- [IndelXRef](#indelxref) +- [InfoFiles](#infofiles) +- [InfoFilesUser_md5](#infofilesuser_md5) +- [Investigators](#investigators) +- [LCorrRamin3](#lcorrramin3) +- [login](#login) +- [MachineAccessLog](#machineaccesslog) +- [MappingMethod](#mappingmethod) +- [metadata_audit](#metadata_audit) +- [mytest1](#mytest1) +- [News](#news) +- [NStrain](#nstrain) +- [Organizations](#organizations) +- [Phenotype](#phenotype) +- [Probe](#probe) +- [ProbeData](#probedata) +- [ProbeFreeze](#probefreeze) +- [ProbeH2](#probeh2) +- [ProbeSE](#probese) +- [ProbeSet](#probeset) +- [ProbeSetData](#probesetdata) +- [ProbeSetFreeze](#probesetfreeze) +- [ProbeSetSE](#probesetse) +- [ProbeSetXRef](#probesetxref) +- [ProbeSetXRef_old](#probesetxref_old) +- [ProbeXRef](#probexref) +- [Publication](#publication) +- [Publication_Test](#publication_test) +- [PublishData](#publishdata) +- [PublishFreeze](#publishfreeze) +- [PublishSE](#publishse) +- [PublishXRef](#publishxref) +- [pubmedsearch](#pubmedsearch) +- [RatSnpPattern](#ratsnppattern) +- [role](#role) +- [roles_users](#roles_users) +- [Sample](#sample) +- [SampleXRef](#samplexref) +- [SnpAll](#snpall) +- [SnpAllele_to_be_deleted](#snpallele_to_be_deleted) +- [SnpAllRat](#snpallrat) +- [SnpPattern](#snppattern) +- [SnpSource](#snpsource) +- [Species](#species) +- [Strain](#strain) +- [StrainXRef](#strainxref) +- [TableComments](#tablecomments) +- [TableFieldAnnotation](#tablefieldannotation) +- [Temp](#temp) +- [TempData](#tempdata) +- [temporary](#temporary) +- [test_table](#test_table) +- [Tissue](#tissue) +- [TissueProbeFreeze](#tissueprobefreeze) +- [TissueProbeSetData](#tissueprobesetdata) +- [TissueProbeSetFreeze](#tissueprobesetfreeze) +- [TissueProbeSetXRef](#tissueprobesetxref) +- [TraitMetadata](#traitmetadata) +- [User](#user) +- [user](#user) +- [user_collection](#user_collection) +- [user_openids](#user_openids) +- [UserPrivilege](#userprivilege) +- [Vlookup](#vlookup) + +## AccessLog + +```sql +CREATE TABLE `AccessLog` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `accesstime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', + `ip_address` char(20) NOT NULL DEFAULT '0.0.0.0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=1511441 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## AvgMethod + +```sql +CREATE TABLE `AvgMethod` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `AvgMethodId` int(5) DEFAULT NULL, + `Name` char(30) NOT NULL DEFAULT '', + `Normalization` varchar(30) DEFAULT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## BACKUP_CaseAttribute_20240601T01_34_02__842794 + +```sql +CREATE TABLE `BACKUP_CaseAttribute_20240601T01_34_02__842794` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `Name` varchar(30) NOT NULL DEFAULT '', + `Description` varchar(250) DEFAULT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## BACKUP_CaseAttributeXRefNew_20240601T01_34_02__842794 + +```sql +CREATE TABLE `BACKUP_CaseAttributeXRefNew_20240601T01_34_02__842794` ( + `Id` int(11) NOT NULL AUTO_INCREMENT, + `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0, + `StrainId` int(8) unsigned NOT NULL DEFAULT 0, + `CaseAttributeId` smallint(5) NOT NULL DEFAULT 0, + `Value` varchar(100) NOT NULL DEFAULT '', + PRIMARY KEY (`InbredSetId`,`StrainId`,`CaseAttributeId`), + UNIQUE KEY `Id` (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=390448 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## BXDSnpPosition + +```sql +CREATE TABLE `BXDSnpPosition` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `Chr` char(2) DEFAULT NULL, + `StrainId1` int(11) DEFAULT NULL, + `StrainId2` int(11) DEFAULT NULL, + `Mb` double DEFAULT NULL, + `Mb_2016` double DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `BXDSnpPosition` (`Chr`,`StrainId1`,`StrainId2`,`Mb`) +) ENGINE=InnoDB AUTO_INCREMENT=7791982 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## CaseAttribute + +```sql +CREATE TABLE `CaseAttribute` ( + `InbredSetId` int(5) unsigned NOT NULL, + `CaseAttributeId` int(5) unsigned NOT NULL, + `Name` varchar(30) NOT NULL, + `Description` varchar(250) NOT NULL, + PRIMARY KEY (`InbredSetId`,`CaseAttributeId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## caseattributes_audit + +```sql +CREATE TABLE `caseattributes_audit` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `status` enum('review','rejected','approved') NOT NULL, + `editor` varchar(255) NOT NULL, + `json_diff_data` longtext DEFAULT NULL, + `time_stamp` timestamp NOT NULL DEFAULT current_timestamp(), + PRIMARY KEY (`id`), + CONSTRAINT `CONSTRAINT_1` CHECK (json_valid(`json_diff_data`)) +) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## CaseAttributeXRef + +```sql +CREATE TABLE `CaseAttributeXRef` ( + `ProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, + `CaseAttributeId` smallint(5) NOT NULL DEFAULT 0, + `Value` varchar(100) NOT NULL DEFAULT '', + PRIMARY KEY (`ProbeSetFreezeId`,`StrainId`,`CaseAttributeId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## CaseAttributeXRefNew + +```sql +CREATE TABLE `CaseAttributeXRefNew` ( + `InbredSetId` int(5) unsigned NOT NULL, + `StrainId` int(20) unsigned NOT NULL, + `CaseAttributeId` int(5) unsigned NOT NULL, + `Value` varchar(100) NOT NULL, + PRIMARY KEY (`InbredSetId`,`StrainId`,`CaseAttributeId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## CeleraINFO_mm6 + +```sql +CREATE TABLE `CeleraINFO_mm6` ( + `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `SNPID` char(14) NOT NULL DEFAULT '', + `chromosome` char(3) DEFAULT NULL, + `MB_UCSC` double DEFAULT NULL, + `MB_celera` double DEFAULT NULL, + `allele_B6` char(4) DEFAULT NULL, + `allele_D2` char(4) DEFAULT NULL, + `allele_AJ` char(4) DEFAULT NULL, + `B6_D2` char(1) DEFAULT NULL, + `B6_AJ` char(1) DEFAULT NULL, + `D2_AJ` char(1) DEFAULT NULL, + `MB_UCSC_OLD` double DEFAULT NULL, + `allele_S1` char(4) DEFAULT NULL, + `allele_X1` char(4) DEFAULT NULL, + `flanking5` char(100) DEFAULT NULL, + `flanking3` char(100) DEFAULT NULL, + PRIMARY KEY (`Id`), + KEY `celeraIndex` (`chromosome`,`MB_celera`), + KEY `celeraIndex2` (`chromosome`,`MB_UCSC`), + KEY `chromosome_2` (`chromosome`,`MB_UCSC`), + KEY `MB_UCSC_2` (`MB_UCSC`,`chromosome`), + KEY `SNPID` (`SNPID`) +) ENGINE=InnoDB AUTO_INCREMENT=3028848 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Chr_Length + +```sql +CREATE TABLE `Chr_Length` ( + `Name` char(3) NOT NULL DEFAULT '', + `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0, + `OrderId` smallint(5) unsigned NOT NULL, + `Length` int(10) unsigned NOT NULL DEFAULT 0, + `Length_2016` int(10) unsigned NOT NULL DEFAULT 0, + `Length_mm8` int(10) unsigned DEFAULT NULL, + PRIMARY KEY (`SpeciesId`,`OrderId`), + UNIQUE KEY `nameIdx` (`SpeciesId`,`Name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## Dataset_mbat + +```sql +CREATE TABLE `Dataset_mbat` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `switch` int(1) DEFAULT NULL, + `species` varchar(255) DEFAULT NULL, + `cross` varchar(255) DEFAULT NULL, + `tissue` varchar(255) DEFAULT NULL, + `database` varchar(255) DEFAULT NULL, + `database_LongName` varchar(255) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## DatasetMapInvestigator + +```sql +CREATE TABLE `DatasetMapInvestigator` ( + `Id` mediumint(9) NOT NULL AUTO_INCREMENT, + `DatasetId` int(6) NOT NULL, + `ProbeFreezeId` int(6) DEFAULT NULL, + `InvestigatorId` int(6) NOT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=2409 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Datasets + +```sql +CREATE TABLE `Datasets` ( + `DatasetId` int(6) NOT NULL AUTO_INCREMENT, + `ProbeFreezeId` int(8) DEFAULT NULL, + `DatasetName` varchar(255) DEFAULT NULL, + `GeoSeries` varchar(30) DEFAULT NULL, + `PublicationTitle` longtext DEFAULT NULL, + `Summary` longtext DEFAULT NULL, + `ExperimentDesign` longtext DEFAULT NULL, + `AboutCases` longtext DEFAULT NULL, + `AboutTissue` longtext DEFAULT NULL, + `AboutPlatform` longtext DEFAULT NULL, + `AboutDataProcessing` longtext DEFAULT NULL, + `Contributors` longtext DEFAULT NULL, + `Citation` longtext DEFAULT NULL, + `Acknowledgment` longtext DEFAULT NULL, + `Notes` longtext DEFAULT NULL, + `InvestigatorId` int(5) NOT NULL, + `DatasetStatusId` int(5) NOT NULL, + PRIMARY KEY (`DatasetId`), + UNIQUE KEY `DatasetId` (`DatasetId`) +) ENGINE=InnoDB AUTO_INCREMENT=449 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## DatasetStatus + +```sql +CREATE TABLE `DatasetStatus` ( + `DatasetStatusId` int(5) NOT NULL, + `DatasetStatusName` varchar(20) DEFAULT NULL, + UNIQUE KEY `DatasetStatusId` (`DatasetStatusId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## DBList + +```sql +CREATE TABLE `DBList` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `DBTypeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `FreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `Name` char(50) NOT NULL DEFAULT '', + `Code` char(50) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `Cde` (`Code`), + KEY `DBIndex` (`DBTypeId`,`FreezeId`) +) ENGINE=InnoDB AUTO_INCREMENT=956 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## DBType + +```sql +CREATE TABLE `DBType` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `Name` char(30) NOT NULL DEFAULT '', + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Docs + +```sql +CREATE TABLE `Docs` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `entry` varchar(255) NOT NULL, + `title` varchar(255) NOT NULL, + `content` text NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## EnsemblChip + +```sql +CREATE TABLE `EnsemblChip` ( + `Id` int(11) NOT NULL, + `ProbeSetSize` int(11) NOT NULL, + `Name` varchar(40) NOT NULL, + `Type` enum('AFFY','OLIGO') DEFAULT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## EnsemblProbe + +```sql +CREATE TABLE `EnsemblProbe` ( + `Id` int(11) NOT NULL, + `ChipId` int(11) NOT NULL, + `ProbeSet` varchar(40) DEFAULT NULL, + `Name` varchar(40) DEFAULT NULL, + `length` int(11) NOT NULL, + KEY `EnsemblProbeId` (`Id`), + KEY `EnsemblProbeName` (`Name`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## EnsemblProbeLocation + +```sql +CREATE TABLE `EnsemblProbeLocation` ( + `Chr` char(2) NOT NULL, + `Start` int(11) NOT NULL, + `Start_2016` int(11) DEFAULT NULL, + `End` int(11) NOT NULL, + `End_2016` int(11) DEFAULT NULL, + `Strand` int(11) NOT NULL, + `MisMataches` int(11) DEFAULT NULL, + `ProbeId` int(11) NOT NULL, + KEY `EnsemblLocationProbeId` (`ProbeId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Genbank + +```sql +CREATE TABLE `Genbank` ( + `Id` varchar(20) NOT NULL DEFAULT '', + `Sequence` text DEFAULT NULL, + `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0, + PRIMARY KEY (`Id`), + KEY `Id` (`Id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneCategory + +```sql +CREATE TABLE `GeneCategory` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `Name` char(255) NOT NULL DEFAULT '', + PRIMARY KEY (`Id`), + KEY `name_idx` (`Name`) +) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneChip + +```sql +CREATE TABLE `GeneChip` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `GeneChipId` int(5) DEFAULT NULL, + `GeneChipName` varchar(200) DEFAULT NULL, + `Name` char(30) NOT NULL DEFAULT '', + `GeoPlatform` char(15) DEFAULT NULL, + `Title` varchar(100) DEFAULT NULL, + `SpeciesId` int(5) DEFAULT 1, + `GO_tree_value` varchar(50) DEFAULT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneChipEnsemblXRef + +```sql +CREATE TABLE `GeneChipEnsemblXRef` ( + `GeneChipId` int(11) NOT NULL, + `EnsemblChipId` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneIDXRef + +```sql +CREATE TABLE `GeneIDXRef` ( + `mouse` int(11) NOT NULL DEFAULT 0, + `rat` int(11) NOT NULL DEFAULT 0, + `human` int(11) NOT NULL DEFAULT 0, + KEY `mouse_index` (`mouse`), + KEY `rat_index` (`rat`), + KEY `human_index` (`human`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneInfo + +```sql +CREATE TABLE `GeneInfo` ( + `Id` int(10) NOT NULL AUTO_INCREMENT, + `GeneId` int(10) DEFAULT NULL, + `TaxId` int(10) DEFAULT NULL, + `SpeciesId` int(10) DEFAULT NULL, + `Symbol` varchar(255) DEFAULT NULL, + `Alias` longtext DEFAULT NULL, + `Chr` char(3) DEFAULT NULL, + `Mb` double DEFAULT NULL, + `Probe_set_Blat_Mb_start` double DEFAULT NULL, + `Probe_set_Blat_Mb_end` double DEFAULT NULL, + `BlatSeq` text DEFAULT NULL, + `Strand_Probe` char(1) DEFAULT NULL, + `Strand_Gene` char(1) DEFAULT NULL, + `OMIM` varchar(20) DEFAULT NULL, + `HomoloGeneID` varchar(20) DEFAULT NULL, + PRIMARY KEY (`Id`), + KEY `GeneId_Symbol` (`GeneId`,`Symbol`) +) ENGINE=InnoDB AUTO_INCREMENT=9560977 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneList + +```sql +CREATE TABLE `GeneList` ( + `SpeciesId` int(5) unsigned NOT NULL DEFAULT 1, + `Id` int(10) unsigned NOT NULL, + `GeneSymbol` varchar(15) DEFAULT NULL, + `GeneDescription` mediumtext DEFAULT NULL, + `Chromosome` varchar(10) DEFAULT NULL, + `TxStart` double DEFAULT NULL, + `TxStart_2016` double DEFAULT NULL, + `TxEnd` double DEFAULT NULL, + `TxEnd_2016` double DEFAULT NULL, + `Strand` char(1) DEFAULT NULL, + `GeneID` varchar(10) DEFAULT NULL, + `NM_ID` varchar(15) DEFAULT NULL, + `kgID` varchar(10) DEFAULT NULL, + `GenBankID` varchar(15) DEFAULT NULL, + `UnigenID` varchar(15) DEFAULT NULL, + `ProteinID` varchar(15) DEFAULT NULL, + `AlignID` varchar(10) DEFAULT NULL, + `exonCount` int(7) NOT NULL DEFAULT 0, + `exonStarts` mediumtext DEFAULT NULL, + `exonEnds` mediumtext DEFAULT NULL, + `cdsStart` double DEFAULT NULL, + `cdsStart_2016` double DEFAULT NULL, + `cdsEnd` double DEFAULT NULL, + `cdsEnd_2016` double DEFAULT NULL, + `TxStart_mm8` double DEFAULT NULL, + `TxEnd_mm8` double DEFAULT NULL, + `Strand_mm8` char(1) DEFAULT NULL, + `exonCount_mm8` int(7) DEFAULT NULL, + `exonStarts_mm8` mediumtext DEFAULT NULL, + `exonEnds_mm8` mediumtext DEFAULT NULL, + `cdsStart_mm8` double DEFAULT NULL, + `cdsEnd_mm8` double DEFAULT NULL, + `Chromosome_mm8` varchar(10) DEFAULT NULL, + `Info_mm9` mediumtext DEFAULT NULL, + `RGD_ID` int(10) DEFAULT NULL, + UNIQUE KEY `geneId` (`SpeciesId`,`Id`), + KEY `geneSymbol` (`GeneSymbol`), + KEY `geneSymbol2` (`SpeciesId`,`GeneSymbol`), + KEY `Loc1` (`SpeciesId`,`Chromosome`,`TxStart`), + KEY `Loc2` (`SpeciesId`,`Chromosome`,`TxEnd`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## GeneList081722 + +```sql +CREATE TABLE `GeneList081722` ( + `SpeciesId` int(5) unsigned NOT NULL DEFAULT 1, + `Id` int(20) unsigned NOT NULL AUTO_INCREMENT, + `GeneSymbol` varchar(20) DEFAULT NULL, + `GeneDescription` text DEFAULT NULL, + `alias` longtext DEFAULT NULL, + `Chr_mm11` varchar(10) DEFAULT NULL, + `TxStart_mm11` double DEFAULT NULL, + `TxEnd_mm11` double DEFAULT NULL, + `Strand_mm11` char(1) DEFAULT NULL, + `Chr_mm10` varchar(10) DEFAULT NULL, + `TxStart_mm10` double DEFAULT NULL, + `TxEnd_mm10` double DEFAULT NULL, + `Strand_mm10` char(1) DEFAULT NULL, + `Chr_mm9` varchar(10) DEFAULT NULL, + `TxStart_mm9` double DEFAULT NULL, + `TxEnd_mm9` double DEFAULT NULL, + `Strand_mm9` char(1) DEFAULT NULL, + `Chr_rn7` varchar(10) DEFAULT NULL, + `TxStart_rn7` double DEFAULT NULL, + `TxEnd_rn7` double DEFAULT NULL, + `Strand_rn7` char(1) DEFAULT NULL, + `Chr_rn6` varchar(10) DEFAULT NULL, + `TxStart_rn6` double DEFAULT NULL, + `TxEnd_rn6` double DEFAULT NULL, + `Strand_rn6` char(1) DEFAULT NULL, + `GeneID` varchar(15) DEFAULT NULL, + `NM_ID` varchar(20) DEFAULT NULL, + `kgID` varchar(10) DEFAULT NULL, + `GenBankID` varchar(20) DEFAULT NULL, + `UnigenID` varchar(20) DEFAULT NULL, + `ProteinID` varchar(20) DEFAULT NULL, + `AlignID` varchar(10) DEFAULT NULL, + `exonCount` int(7) NOT NULL DEFAULT 0, + `exonStarts` text DEFAULT NULL, + `exonEnds` text DEFAULT NULL, + `cdsStart` double DEFAULT NULL, + `cdsEnd` double DEFAULT NULL, + `RGD_ID` int(20) DEFAULT NULL, + `ENSEMBL_ID` varchar(50) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `geneId` (`SpeciesId`,`Id`), + KEY `geneSymbol` (`GeneSymbol`), + KEY `geneSymbol2` (`SpeciesId`,`GeneSymbol`), + KEY `Loc1` (`SpeciesId`,`Chr_mm10`,`TxStart_mm10`), + KEY `Loc2` (`SpeciesId`,`Chr_mm10`,`TxEnd_mm10`) +) ENGINE=InnoDB AUTO_INCREMENT=142506 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneList_rn3 + +```sql +CREATE TABLE `GeneList_rn3` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `ProbeSet` varchar(16) DEFAULT NULL, + `geneSymbol` varchar(15) DEFAULT NULL, + `geneID` varchar(10) DEFAULT NULL, + `kgID` varchar(10) DEFAULT NULL, + `geneDescription` text DEFAULT NULL, + `genBankID` varchar(15) DEFAULT NULL, + `unigenID` varchar(15) DEFAULT NULL, + `score` int(4) DEFAULT NULL, + `qStart` int(3) DEFAULT NULL, + `qEnd` int(3) DEFAULT NULL, + `qSize` int(3) DEFAULT NULL, + `identity` varchar(7) DEFAULT NULL, + `chromosome` varchar(8) DEFAULT NULL, + `strand` char(1) DEFAULT NULL, + `txStart` double DEFAULT NULL, + `txEnd` double DEFAULT NULL, + `txSize` double DEFAULT NULL, + `span` int(7) DEFAULT NULL, + `specificity` double DEFAULT NULL, + `sequence` text DEFAULT NULL, + `flag` int(1) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `geneSymbol` (`geneSymbol`), + KEY `Loc1` (`chromosome`,`txStart`), + KEY `Loc2` (`chromosome`,`txEnd`) +) ENGINE=InnoDB AUTO_INCREMENT=14917 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneList_rn33 + +```sql +CREATE TABLE `GeneList_rn33` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `geneSymbol` varchar(15) DEFAULT NULL, + `txStart` double DEFAULT NULL, + `txEnd` double DEFAULT NULL, + `exonCount` int(7) DEFAULT NULL, + `NM_ID` varchar(15) DEFAULT NULL, + `chromosome` varchar(8) DEFAULT NULL, + `strand` char(1) DEFAULT NULL, + `cdsStart` double DEFAULT NULL, + `cdsEnd` double DEFAULT NULL, + `exonStarts` text DEFAULT NULL, + `exonEnds` text DEFAULT NULL, + `kgID` varchar(10) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `geneSymbol` (`geneSymbol`), + KEY `Loc1` (`chromosome`,`txStart`), + KEY `Loc2` (`chromosome`,`txEnd`) +) ENGINE=InnoDB AUTO_INCREMENT=9790 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneMap_cuiyan + +```sql +CREATE TABLE `GeneMap_cuiyan` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `TranscriptID` varchar(255) DEFAULT NULL, + `GeneID` varchar(255) DEFAULT NULL, + `Symbol` varchar(255) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=10537 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GeneRIF + +```sql +CREATE TABLE `GeneRIF` ( + `Id` int(10) unsigned NOT NULL DEFAULT 0, + `versionId` smallint(5) unsigned NOT NULL DEFAULT 0, + `symbol` varchar(30) NOT NULL DEFAULT '', + `PubMed_ID` varchar(255) DEFAULT NULL, + `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1, + `comment` mediumtext DEFAULT NULL, + `email` varchar(50) DEFAULT NULL, + `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', + `user_ip` varchar(20) DEFAULT NULL, + `weburl` varchar(255) DEFAULT NULL, + `initial` varchar(10) DEFAULT NULL, + `display` tinyint(4) DEFAULT 1, + `reason` varchar(100) NOT NULL DEFAULT '', + PRIMARY KEY (`Id`,`versionId`), + KEY `name_idx` (`symbol`), + KEY `status` (`display`), + KEY `timestamp` (`createtime`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## GeneRIF_BASIC + +```sql +CREATE TABLE `GeneRIF_BASIC` ( + `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1, + `TaxID` int(10) DEFAULT NULL, + `GeneId` int(10) unsigned NOT NULL DEFAULT 0, + `symbol` varchar(255) NOT NULL DEFAULT '', + `PubMed_ID` int(10) unsigned NOT NULL DEFAULT 0, + `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', + `comment` mediumtext DEFAULT NULL, + `VersionId` smallint(5) unsigned NOT NULL, + PRIMARY KEY (`GeneId`,`SpeciesId`,`createtime`,`PubMed_ID`,`VersionId`), + KEY `symbol` (`symbol`,`SpeciesId`,`createtime`), + FULLTEXT KEY `commts` (`comment`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## GeneRIFXRef + +```sql +CREATE TABLE `GeneRIFXRef` ( + `GeneRIFId` int(10) unsigned NOT NULL DEFAULT 0, + `versionId` smallint(5) unsigned NOT NULL DEFAULT 0, + `GeneCategoryId` smallint(5) unsigned NOT NULL DEFAULT 0, + PRIMARY KEY (`GeneRIFId`,`versionId`,`GeneCategoryId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## Geno + +```sql +CREATE TABLE `Geno` ( + `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1, + `Name` varchar(40) NOT NULL DEFAULT '', + `Marker_Name` varchar(40) DEFAULT NULL, + `Chr` char(3) DEFAULT NULL, + `Mb` double DEFAULT NULL, + `Mb_2016` double DEFAULT NULL, + `Sequence` longtext DEFAULT NULL, + `Source` varchar(40) DEFAULT NULL, + `chr_num` smallint(5) unsigned DEFAULT NULL, + `Source2` varchar(40) DEFAULT NULL, + `Comments` varchar(255) DEFAULT NULL, + `used_by_geno_file` varchar(40) DEFAULT NULL, + `Mb_mm8` double DEFAULT NULL, + `Chr_mm8` char(3) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `species_name` (`SpeciesId`,`Name`) +) ENGINE=InnoDB AUTO_INCREMENT=1140082 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## GenoCode + +```sql +CREATE TABLE `GenoCode` ( + `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 1, + `AlleleType` char(3) NOT NULL DEFAULT '', + `AlleleSymbol` char(2) NOT NULL DEFAULT '', + `DatabaseValue` smallint(5) DEFAULT NULL, + PRIMARY KEY (`InbredSetId`,`AlleleType`,`AlleleSymbol`), + UNIQUE KEY `InbredSetId_AlleleType` (`InbredSetId`,`AlleleType`), + UNIQUE KEY `InbredSetId_AlleleSymbol` (`InbredSetId`,`AlleleSymbol`), + UNIQUE KEY `InbredSetId_DatabaseValue` (`InbredSetId`,`DatabaseValue`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GenoData + +```sql +CREATE TABLE `GenoData` ( + `Id` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` int(5) DEFAULT NULL, + `value` float NOT NULL, + UNIQUE KEY `DataId` (`Id`,`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## GenoFile + +```sql +CREATE TABLE `GenoFile` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `server` varchar(100) NOT NULL, + `InbredSetID` int(11) NOT NULL, + `location` varchar(255) NOT NULL, + `title` varchar(255) NOT NULL, + `sort` int(3) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GenoFreeze + +```sql +CREATE TABLE `GenoFreeze` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `Name` varchar(100) NOT NULL DEFAULT '', + `FullName` varchar(100) NOT NULL DEFAULT '', + `ShortName` varchar(100) NOT NULL DEFAULT '', + `CreateTime` date NOT NULL DEFAULT '2001-01-01', + `public` tinyint(4) NOT NULL DEFAULT 0, + `InbredSetId` smallint(5) unsigned DEFAULT 1, + `confidentiality` tinyint(3) unsigned DEFAULT 0, + `AuthorisedUsers` varchar(100) DEFAULT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## GenoSE + +```sql +CREATE TABLE `GenoSE` ( + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, + `error` float NOT NULL, + UNIQUE KEY `DataId` (`DataId`,`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## GenoXRef + +```sql +CREATE TABLE `GenoXRef` ( + `GenoFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `GenoId` int(10) unsigned NOT NULL DEFAULT 0, + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `cM` double DEFAULT 0, + `Used_for_mapping` char(1) DEFAULT 'N', + UNIQUE KEY `ProbeSetId` (`GenoFreezeId`,`GenoId`), + UNIQUE KEY `DataId` (`DataId`), + KEY `GenoId` (`GenoId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## GORef + +```sql +CREATE TABLE `GORef` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `goterm` varchar(255) DEFAULT NULL, + `genes` text DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=17510 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## H2 + +```sql +CREATE TABLE `H2` ( + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `ICH2` double NOT NULL DEFAULT 0, + `H2SE` double NOT NULL DEFAULT 0, + `HPH2` double NOT NULL DEFAULT 0, + UNIQUE KEY `DataId` (`DataId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Homologene + +```sql +CREATE TABLE `Homologene` ( + `HomologeneId` int(11) DEFAULT NULL, + `GeneId` int(11) DEFAULT NULL, + `TaxonomyId` int(11) DEFAULT NULL, + KEY `GeneId` (`GeneId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## InbredSet + +```sql +CREATE TABLE `InbredSet` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `InbredSetId` int(5) unsigned NOT NULL, + `InbredSetName` varchar(100) DEFAULT NULL, + `Name` char(30) NOT NULL DEFAULT '', + `SpeciesId` smallint(5) unsigned DEFAULT 1, + `FullName` varchar(100) DEFAULT NULL, + `public` tinyint(3) unsigned DEFAULT 2, + `MappingMethodId` char(50) DEFAULT '1', + `GeneticType` varchar(255) DEFAULT NULL, + `Family` varchar(100) DEFAULT NULL, + `FamilyOrder` int(5) DEFAULT NULL, + `MenuOrderId` double NOT NULL, + `InbredSetCode` varchar(5) DEFAULT NULL, + `Description` longtext DEFAULT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## InbredSetMapInvestigator + +```sql +CREATE TABLE `InbredSetMapInvestigator` ( + `Id` mediumint(9) NOT NULL AUTO_INCREMENT, + `InbredSetId` int(6) NOT NULL DEFAULT 0, + `InvestigatorId` int(6) NOT NULL DEFAULT 177, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## IndelAll + +```sql +CREATE TABLE `IndelAll` ( + `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `SpeciesId` smallint(5) unsigned DEFAULT 1, + `SourceId` smallint(5) unsigned DEFAULT NULL, + `Name` char(30) DEFAULT NULL, + `Chromosome` char(2) DEFAULT NULL, + `Mb_start` double DEFAULT NULL, + `Mb_start_2016` double DEFAULT NULL, + `Strand` char(1) DEFAULT NULL, + `Type` char(15) DEFAULT NULL, + `Mb_end` double DEFAULT NULL, + `Mb_end_2016` double DEFAULT NULL, + `Size` double DEFAULT NULL, + `InDelSequence` char(30) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `SnpId` (`SpeciesId`,`Name`), + KEY `SnpId2` (`Name`), + KEY `Position` (`SpeciesId`,`Chromosome`,`Mb_start`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=142895 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## IndelXRef + +```sql +CREATE TABLE `IndelXRef` ( + `IndelId` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId1` smallint(5) unsigned NOT NULL DEFAULT 0, + `StrainId2` smallint(5) unsigned DEFAULT NULL, + PRIMARY KEY (`IndelId`,`StrainId1`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## InfoFiles + +```sql +CREATE TABLE `InfoFiles` ( + `DatasetId` int(5) DEFAULT NULL, + `SpeciesId` int(5) DEFAULT NULL, + `TissueId` int(5) DEFAULT NULL, + `InbredSetId` int(5) DEFAULT NULL, + `GeneChipId` int(5) DEFAULT NULL, + `AvgMethodId` int(5) DEFAULT NULL, + `InfoFileTitle` longtext DEFAULT NULL, + `Specifics` longtext DEFAULT NULL, + `Status` varchar(255) DEFAULT NULL, + `Title` varchar(255) DEFAULT NULL, + `Organism` varchar(255) DEFAULT NULL, + `Experiment_Type` longtext DEFAULT NULL, + `Summary` longtext DEFAULT NULL, + `Overall_Design` longtext DEFAULT NULL, + `Contributor` longtext DEFAULT NULL, + `Citation` longtext DEFAULT NULL, + `Submission_Date` varchar(255) DEFAULT NULL, + `Contact_Name` varchar(255) DEFAULT NULL, + `Emails` varchar(255) DEFAULT NULL, + `Phone` varchar(255) DEFAULT NULL, + `URL` varchar(255) DEFAULT NULL, + `Organization_Name` varchar(255) DEFAULT NULL, + `Department` varchar(255) DEFAULT NULL, + `Laboratory` varchar(255) DEFAULT NULL, + `Street` varchar(255) DEFAULT NULL, + `City` varchar(255) DEFAULT NULL, + `State` varchar(255) DEFAULT NULL, + `ZIP` varchar(255) DEFAULT NULL, + `Country` varchar(255) DEFAULT NULL, + `Platforms` varchar(255) DEFAULT NULL, + `Samples` longtext DEFAULT NULL, + `Species` varchar(255) DEFAULT NULL, + `Normalization` varchar(255) DEFAULT NULL, + `InbredSet` varchar(255) DEFAULT NULL, + `InfoPageName` varchar(255) NOT NULL, + `DB_Name` varchar(255) DEFAULT NULL, + `Organism_Id` varchar(60) DEFAULT NULL, + `InfoPageTitle` varchar(255) DEFAULT NULL, + `GN_AccesionId` int(4) DEFAULT NULL, + `Tissue` varchar(60) DEFAULT NULL, + `AuthorizedUsers` varchar(100) DEFAULT NULL, + `About_Cases` longtext DEFAULT NULL, + `About_Tissue` longtext DEFAULT NULL, + `About_Download` longtext DEFAULT NULL, + `About_Array_Platform` longtext DEFAULT NULL, + `About_Data_Values_Processing` longtext DEFAULT NULL, + `Data_Source_Acknowledge` longtext DEFAULT NULL, + `Progreso` varchar(20) DEFAULT NULL, + `QualityControlStatus` longtext DEFAULT NULL, + `InfoFileId` int(6) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`InfoFileId`), + UNIQUE KEY `InfoPageName` (`InfoPageName`), + UNIQUE KEY `GN_AccesionId` (`GN_AccesionId`) +) ENGINE=InnoDB AUTO_INCREMENT=1530 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## InfoFilesUser_md5 + +```sql +CREATE TABLE `InfoFilesUser_md5` ( + `Username` varchar(16) DEFAULT NULL, + `Password` varchar(32) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Investigators + +```sql +CREATE TABLE `Investigators` ( + `FirstName` varchar(20) DEFAULT NULL, + `LastName` varchar(20) DEFAULT NULL, + `Address` varchar(200) DEFAULT NULL, + `City` varchar(20) DEFAULT NULL, + `State` varchar(20) DEFAULT NULL, + `ZipCode` varchar(20) DEFAULT NULL, + `Phone` varchar(200) DEFAULT NULL, + `Email` varchar(200) DEFAULT NULL, + `Country` varchar(35) DEFAULT NULL, + `Url` text DEFAULT NULL, + `UserName` varchar(30) DEFAULT NULL, + `UserPass` varchar(255) DEFAULT NULL, + `UserDate` datetime /* mariadb-5.3 */ DEFAULT NULL, + `UserLevel` int(8) DEFAULT NULL, + `active` enum('0','1') DEFAULT NULL, + `token` varchar(255) DEFAULT NULL, + `OrganizationId` int(5) DEFAULT NULL, + `InvestigatorId` int(5) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`InvestigatorId`) +) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## LCorrRamin3 + +```sql +CREATE TABLE `LCorrRamin3` ( + `GeneId1` int(12) unsigned DEFAULT NULL, + `GeneId2` int(12) unsigned DEFAULT NULL, + `value` double DEFAULT NULL, + KEY `GeneId1` (`GeneId1`), + KEY `GeneId2` (`GeneId2`), + KEY `GeneId1_2` (`GeneId1`,`GeneId2`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## login + +```sql +CREATE TABLE `login` ( + `id` varchar(36) NOT NULL, + `user` varchar(36) DEFAULT NULL, + `timestamp` datetime /* mariadb-5.3 */ DEFAULT NULL, + `ip_address` varchar(39) DEFAULT NULL, + `successful` tinyint(1) NOT NULL, + `session_id` text DEFAULT NULL, + `assumed_by` varchar(36) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `user` (`user`), + KEY `assumed_by` (`assumed_by`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## MachineAccessLog + +```sql +CREATE TABLE `MachineAccessLog` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `accesstime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', + `ip_address` char(20) NOT NULL DEFAULT '0.0.0.0', + `db_id` tinyint(3) unsigned NOT NULL DEFAULT 0, + `data_id` int(10) unsigned DEFAULT NULL, + `action` char(10) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=514946 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## MappingMethod + +```sql +CREATE TABLE `MappingMethod` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `Name` varchar(100) NOT NULL DEFAULT '', + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## metadata_audit + +```sql +CREATE TABLE `metadata_audit` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `dataset_id` int(11) NOT NULL, + `editor` varchar(255) NOT NULL, + `json_diff_data` longtext DEFAULT NULL, + `time_stamp` timestamp NOT NULL DEFAULT current_timestamp(), + PRIMARY KEY (`id`), + CONSTRAINT `CONSTRAINT_1` CHECK (json_valid(`json_diff_data`)) +) ENGINE=InnoDB AUTO_INCREMENT=1228 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## mytest1 + +```sql +CREATE TABLE `mytest1` ( + `Id` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` mediumint(8) unsigned NOT NULL DEFAULT 0, + `value` float NOT NULL, + PRIMARY KEY (`Id`,`StrainId`), + KEY `StrainId` (`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## News + +```sql +CREATE TABLE `News` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `date` date DEFAULT NULL, + `details` text DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=296 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## NStrain + +```sql +CREATE TABLE `NStrain` ( + `DataId` int(10) unsigned DEFAULT NULL, + `StrainId` int(20) DEFAULT NULL, + `count` varchar(5) DEFAULT NULL, + UNIQUE KEY `DataId` (`DataId`,`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## Organizations + +```sql +CREATE TABLE `Organizations` ( + `OrganizationId` int(5) NOT NULL AUTO_INCREMENT, + `OrganizationName` varchar(200) NOT NULL, + PRIMARY KEY (`OrganizationId`), + UNIQUE KEY `OrganizationId` (`OrganizationId`), + UNIQUE KEY `OrganizationName` (`OrganizationName`) +) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Phenotype + +```sql +CREATE TABLE `Phenotype` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `Pre_publication_description` mediumtext DEFAULT NULL, + `Post_publication_description` mediumtext DEFAULT NULL, + `Original_description` mediumtext DEFAULT NULL, + `Units` varchar(100) NOT NULL DEFAULT 'Unknown', + `Pre_publication_abbreviation` varchar(60) DEFAULT NULL, + `Post_publication_abbreviation` varchar(60) DEFAULT NULL, + `Lab_code` varchar(255) DEFAULT NULL, + `Submitter` varchar(255) DEFAULT NULL, + `Owner` varchar(255) DEFAULT NULL, + `Authorized_Users` varchar(255) DEFAULT NULL, + PRIMARY KEY (`Id`), + KEY `Post_publication_description_Index` (`Post_publication_description`(250)), + KEY `Pre_publication_description_Index` (`Pre_publication_description`(250)), + KEY `Pre_publication_abbreviation_Index` (`Pre_publication_abbreviation`), + KEY `Post_publication_abbreviation_Index` (`Post_publication_abbreviation`), + FULLTEXT KEY `index_table` (`Post_publication_description`,`Pre_publication_description`,`Pre_publication_abbreviation`,`Post_publication_abbreviation`,`Lab_code`) +) ENGINE=InnoDB AUTO_INCREMENT=47278 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## Probe + +```sql +CREATE TABLE `Probe` ( + `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `ProbeSetId` int(10) unsigned NOT NULL DEFAULT 0, + `Name` char(20) DEFAULT NULL, + `Sequence` char(30) DEFAULT NULL, + `ExonNo` char(7) DEFAULT NULL, + `SerialOrder` double DEFAULT NULL, + `Tm` double DEFAULT NULL, + `E_GSB` double DEFAULT NULL, + `E_NSB` double DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `ProbeSetId` (`ProbeSetId`,`Name`), + KEY `SerialOrder` (`ProbeSetId`,`SerialOrder`) +) ENGINE=InnoDB AUTO_INCREMENT=19054073 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## ProbeData + +```sql +CREATE TABLE `ProbeData` ( + `Id` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, + `value` float NOT NULL, + UNIQUE KEY `DataId` (`Id`,`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## ProbeFreeze + +```sql +CREATE TABLE `ProbeFreeze` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `ProbeFreezeId` int(5) DEFAULT NULL, + `ChipId` smallint(5) unsigned NOT NULL DEFAULT 0, + `TissueId` smallint(5) unsigned NOT NULL DEFAULT 0, + `Name` varchar(100) NOT NULL DEFAULT '', + `FullName` varchar(100) NOT NULL DEFAULT '', + `ShortName` varchar(100) NOT NULL DEFAULT '', + `CreateTime` date NOT NULL DEFAULT '0000-00-00', + `InbredSetId` smallint(5) unsigned DEFAULT 1, + PRIMARY KEY (`Id`), + UNIQUE KEY `Name` (`Name`) +) ENGINE=InnoDB AUTO_INCREMENT=451 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## ProbeH2 + +```sql +CREATE TABLE `ProbeH2` ( + `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `ProbeId` int(10) unsigned NOT NULL DEFAULT 0, + `h2` double DEFAULT NULL, + `weight` double DEFAULT NULL, + UNIQUE KEY `ProbeId` (`ProbeFreezeId`,`ProbeId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## ProbeSE + +```sql +CREATE TABLE `ProbeSE` ( + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, + `error` float NOT NULL, + UNIQUE KEY `DataId` (`DataId`,`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## ProbeSet + +```sql +CREATE TABLE `ProbeSet` ( + `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `ChipId` smallint(5) unsigned NOT NULL DEFAULT 0, + `Name` varchar(100) DEFAULT NULL, + `TargetId` varchar(150) DEFAULT NULL, + `Symbol` varchar(100) DEFAULT NULL, + `description` longtext DEFAULT NULL, + `Chr` char(3) DEFAULT NULL, + `Mb` double DEFAULT NULL, + `Chr_2016` char(3) DEFAULT NULL, + `Mb_2016` double DEFAULT NULL, + `alias` longtext DEFAULT NULL, + `GeneId` varchar(20) DEFAULT NULL, + `GenbankId` varchar(1000) DEFAULT NULL, + `SNP` int(2) DEFAULT NULL, + `BlatSeq` mediumtext DEFAULT NULL, + `TargetSeq` mediumtext DEFAULT NULL, + `UniGeneId` varchar(100) DEFAULT NULL, + `Strand_Probe` char(1) DEFAULT NULL, + `Strand_Gene` char(1) DEFAULT NULL, + `OMIM` varchar(20) DEFAULT NULL, + `comments` mediumtext DEFAULT NULL, + `Probe_set_target_region` varchar(255) DEFAULT NULL, + `Probe_set_specificity` double DEFAULT NULL, + `Probe_set_BLAT_score` double DEFAULT NULL, + `Probe_set_Blat_Mb_start` double DEFAULT NULL, + `Probe_set_Blat_Mb_end` double DEFAULT NULL, + `Probe_set_Blat_Mb_start_2016` double DEFAULT NULL, + `Probe_set_Blat_Mb_end_2016` double DEFAULT NULL, + `Probe_set_strand` varchar(255) DEFAULT NULL, + `Probe_set_Note_by_RW` varchar(255) DEFAULT NULL, + `flag` char(1) DEFAULT NULL, + `Symbol_H` varchar(100) DEFAULT NULL, + `description_H` varchar(255) DEFAULT NULL, + `chromosome_H` char(3) DEFAULT NULL, + `MB_H` double DEFAULT NULL, + `alias_H` varchar(255) DEFAULT NULL, + `GeneId_H` varchar(20) DEFAULT NULL, + `chr_num` smallint(5) unsigned DEFAULT 30, + `name_num` int(10) unsigned DEFAULT 4294967290, + `Probe_Target_Description` varchar(225) DEFAULT NULL, + `RefSeq_TranscriptId` varchar(255) DEFAULT NULL, + `ENSEMBLGeneId` varchar(50) DEFAULT NULL, + `Chr_mm8` char(3) DEFAULT NULL, + `Mb_mm8` double DEFAULT NULL, + `Probe_set_Blat_Mb_start_mm8` double DEFAULT NULL, + `Probe_set_Blat_Mb_end_mm8` double DEFAULT NULL, + `HomoloGeneID` varchar(20) DEFAULT NULL, + `Biotype_ENS` varchar(255) DEFAULT NULL, + `ProteinID` varchar(50) DEFAULT NULL, + `ProteinName` varchar(50) DEFAULT NULL, + `UniProtID` varchar(20) DEFAULT NULL, + `Flybase_Id` varchar(25) DEFAULT NULL, + `RGD_ID` int(10) DEFAULT NULL, + `HGNC_ID` int(10) DEFAULT NULL, + `HMDB_ID` varchar(255) DEFAULT NULL, + `Confidence` int(5) DEFAULT NULL, + `ChEBI_ID` int(10) DEFAULT NULL, + `ChEMBL_ID` varchar(100) DEFAULT NULL, + `CAS_number` varchar(100) DEFAULT NULL, + `PubChem_ID` int(10) DEFAULT NULL, + `ChemSpider_ID` int(10) DEFAULT NULL, + `UNII_ID` varchar(100) DEFAULT NULL, + `EC_number` varchar(100) DEFAULT NULL, + `KEGG_ID` varchar(100) DEFAULT NULL, + `Molecular_Weight` double DEFAULT NULL, + `Nugowiki_ID` int(10) DEFAULT NULL, + `Type` varchar(255) DEFAULT NULL, + `Tissue` varchar(255) DEFAULT NULL, + `PrimaryName` varchar(255) DEFAULT NULL, + `SecondaryNames` longtext DEFAULT NULL, + `PeptideSequence` varchar(20) DEFAULT NULL, + `id64` varchar(100) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `ProbeSetId` (`ChipId`,`Name`), + KEY `Name_IDX` (`Name`), + KEY `symbol_IDX` (`Symbol`), + KEY `RefSeq_TranscriptId` (`RefSeq_TranscriptId`), + KEY `GENBANK_IDX` (`GenbankId`), + KEY `TargetId` (`TargetId`), + KEY `Position` (`Chr`), + KEY `GeneId_IDX` (`GeneId`), + FULLTEXT KEY `ft_ProbeSet_Symbol` (`Symbol`), + FULLTEXT KEY `ft_ProbeSet_RefSeq_TranscriptId` (`RefSeq_TranscriptId`), + FULLTEXT KEY `ft_ProbeSet_Name` (`Name`), + FULLTEXT KEY `ft_ProbeSet_Alias` (`alias`), + FULLTEXT KEY `ft_ProbeSet_full` (`Name`,`description`,`Symbol`,`alias`,`GenbankId`,`UniGeneId`,`Probe_Target_Description`) +) ENGINE=InnoDB AUTO_INCREMENT=13424654 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## ProbeSetData + +```sql +CREATE TABLE `ProbeSetData` ( + `Id` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` int(20) NOT NULL, + `value` float NOT NULL, + UNIQUE KEY `DataId` (`Id`,`StrainId`), + KEY `strainid` (`StrainId`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## ProbeSetFreeze + +```sql +CREATE TABLE `ProbeSetFreeze` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `AvgID` smallint(5) unsigned NOT NULL DEFAULT 0, + `Name` varchar(40) DEFAULT NULL, + `Name2` varchar(100) NOT NULL DEFAULT '', + `FullName` varchar(100) NOT NULL DEFAULT '', + `ShortName` varchar(100) NOT NULL DEFAULT '', + `CreateTime` date NOT NULL DEFAULT '0000-00-00', + `OrderList` int(5) DEFAULT NULL, + `public` tinyint(4) NOT NULL DEFAULT 0, + `confidentiality` tinyint(4) NOT NULL DEFAULT 0, + `AuthorisedUsers` varchar(300) NOT NULL, + `DataScale` varchar(20) NOT NULL DEFAULT 'log2', + PRIMARY KEY (`Id`), + UNIQUE KEY `FullName` (`FullName`), + UNIQUE KEY `Name` (`Name`), + KEY `NameIndex` (`Name2`) +) ENGINE=InnoDB AUTO_INCREMENT=1083 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## ProbeSetSE + +```sql +CREATE TABLE `ProbeSetSE` ( + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` int(20) NOT NULL, + `error` float DEFAULT NULL, + PRIMARY KEY (`DataId`,`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## ProbeSetXRef + +```sql +CREATE TABLE `ProbeSetXRef` ( + `ProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `ProbeSetId` int(10) unsigned NOT NULL DEFAULT 0, + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `Locus_old` char(20) DEFAULT NULL, + `LRS_old` double DEFAULT NULL, + `pValue_old` double DEFAULT NULL, + `mean` double DEFAULT NULL, + `se` double DEFAULT NULL, + `Locus` varchar(50) DEFAULT NULL, + `LRS` double DEFAULT NULL, + `pValue` double DEFAULT NULL, + `additive` double DEFAULT NULL, + `h2` float DEFAULT NULL, + PRIMARY KEY (`DataId`), + KEY `ProbeSetFreezeId` (`ProbeSetFreezeId`), + KEY `ProbeSetId` (`ProbeSetId`), + KEY `Locus_2` (`Locus`(5)) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## ProbeSetXRef_old + +```sql +CREATE TABLE `ProbeSetXRef_old` ( + `ProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `ProbeSetId` int(10) unsigned NOT NULL DEFAULT 0, + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `Locus_old` char(20) DEFAULT NULL, + `LRS_old` double DEFAULT NULL, + `pValue_old` double DEFAULT NULL, + `mean` double DEFAULT NULL, + `se` double DEFAULT NULL, + `Locus` varchar(50) DEFAULT NULL, + `LRS` double DEFAULT NULL, + `pValue` double DEFAULT NULL, + `additive` double DEFAULT NULL, + `h2` float DEFAULT NULL, + PRIMARY KEY (`ProbeSetFreezeId`,`ProbeSetId`), + UNIQUE KEY `DataId_IDX` (`DataId`), + KEY `Locus_IDX` (`Locus`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## ProbeXRef + +```sql +CREATE TABLE `ProbeXRef` ( + `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `ProbeId` int(10) unsigned NOT NULL DEFAULT 0, + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + UNIQUE KEY `ProbeId` (`ProbeFreezeId`,`ProbeId`), + UNIQUE KEY `DataId_IDX` (`DataId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## Publication + +```sql +CREATE TABLE `Publication` ( + `Id` int(10) NOT NULL AUTO_INCREMENT, + `PubMed_ID` int(10) unsigned DEFAULT NULL, + `Abstract` mediumtext DEFAULT NULL, + `Authors` mediumtext NOT NULL, + `Title` varchar(255) DEFAULT NULL, + `Journal` varchar(255) DEFAULT NULL, + `Volume` varchar(255) DEFAULT NULL, + `Pages` varchar(255) DEFAULT NULL, + `Month` varchar(255) DEFAULT NULL, + `Year` varchar(255) NOT NULL DEFAULT '0', + PRIMARY KEY (`Id`), + UNIQUE KEY `Name` (`PubMed_ID`), + FULLTEXT KEY `index_table` (`Title`,`Abstract`,`Authors`) +) ENGINE=InnoDB AUTO_INCREMENT=39815 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## Publication_Test + +```sql +CREATE TABLE `Publication_Test` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `PubMed_ID` int(10) unsigned DEFAULT NULL, + `Abstract` mediumtext DEFAULT NULL, + `Authors` mediumtext NOT NULL, + `Title` varchar(255) DEFAULT NULL, + `Journal` varchar(255) DEFAULT NULL, + `Volume` varchar(255) DEFAULT NULL, + `Pages` varchar(255) DEFAULT NULL, + `Month` varchar(255) DEFAULT NULL, + `Year` varchar(255) NOT NULL DEFAULT '0', + PRIMARY KEY (`Id`), + UNIQUE KEY `Name` (`PubMed_ID`) +) ENGINE=InnoDB AUTO_INCREMENT=26076 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## PublishData + +```sql +CREATE TABLE `PublishData` ( + `Id` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` int(20) NOT NULL, + `value` float(14,6) DEFAULT NULL, + UNIQUE KEY `DataId` (`Id`,`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## PublishFreeze + +```sql +CREATE TABLE `PublishFreeze` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `Name` varchar(100) NOT NULL DEFAULT '', + `FullName` varchar(100) NOT NULL DEFAULT '', + `ShortName` varchar(100) NOT NULL DEFAULT '', + `CreateTime` date NOT NULL DEFAULT '2001-01-01', + `public` tinyint(4) NOT NULL DEFAULT 0, + `InbredSetId` smallint(5) unsigned DEFAULT 1, + `confidentiality` tinyint(3) DEFAULT 0, + `AuthorisedUsers` varchar(100) DEFAULT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## PublishSE + +```sql +CREATE TABLE `PublishSE` ( + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` int(20) NOT NULL, + `error` float NOT NULL, + UNIQUE KEY `DataId` (`DataId`,`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## PublishXRef + +```sql +CREATE TABLE `PublishXRef` ( + `Id` int(10) unsigned NOT NULL, + `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0, + `PhenotypeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `PublicationId` smallint(5) unsigned NOT NULL DEFAULT 0, + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `mean` double DEFAULT NULL, + `Locus` char(50) DEFAULT NULL, + `LRS` double DEFAULT NULL, + `additive` double DEFAULT NULL, + `Sequence` smallint(5) unsigned NOT NULL DEFAULT 1, + `comments` mediumtext NOT NULL, + `NSamples` int(11) DEFAULT NULL, + UNIQUE KEY `InbredSet` (`InbredSetId`,`Id`), + UNIQUE KEY `record` (`InbredSetId`,`PhenotypeId`,`PublicationId`,`Sequence`), + UNIQUE KEY `PhenotypeId` (`PhenotypeId`), + UNIQUE KEY `DataId` (`DataId`), + KEY `InbredSetId` (`InbredSetId`), + KEY `Locus_IDX` (`Locus`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## pubmedsearch + +```sql +CREATE TABLE `pubmedsearch` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `pubmedid` bigint(20) DEFAULT NULL, + `title` mediumtext DEFAULT NULL, + `authorfullname` mediumtext DEFAULT NULL, + `authorshortname` mediumtext DEFAULT NULL, + `institute` mediumtext DEFAULT NULL, + `geneid` varchar(20) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `NewIndex4` (`geneid`), + FULLTEXT KEY `NewIndex1` (`institute`), + FULLTEXT KEY `NewIndex3` (`authorfullname`,`authorshortname`) +) ENGINE=InnoDB AUTO_INCREMENT=1401371 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## RatSnpPattern + +```sql +CREATE TABLE `RatSnpPattern` ( + `Id` int(12) NOT NULL AUTO_INCREMENT, + `SnpId` int(12) NOT NULL, + `BN` char(1) DEFAULT NULL, + `F344` char(1) DEFAULT NULL, + `ACI` char(1) DEFAULT NULL, + `BBDP` char(1) DEFAULT NULL, + `FHH` char(1) DEFAULT NULL, + `FHL` char(1) DEFAULT NULL, + `GK` char(1) DEFAULT NULL, + `LE` char(1) DEFAULT NULL, + `LEW` char(1) DEFAULT NULL, + `LH` char(1) DEFAULT NULL, + `LL` char(1) DEFAULT NULL, + `LN` char(1) DEFAULT NULL, + `MHS` char(1) DEFAULT NULL, + `MNS` char(1) DEFAULT NULL, + `SBH` char(1) DEFAULT NULL, + `SBN` char(1) DEFAULT NULL, + `SHR` char(1) DEFAULT NULL, + `SHRSP` char(1) DEFAULT NULL, + `SR` char(1) DEFAULT NULL, + `SS` char(1) DEFAULT NULL, + `WAG` char(1) DEFAULT NULL, + `WLI` char(1) DEFAULT NULL, + `WMI` char(1) DEFAULT NULL, + `WKY` char(1) DEFAULT NULL, + `ACI_N` char(1) DEFAULT NULL, + `BN_N` char(1) DEFAULT NULL, + `BUF_N` char(1) DEFAULT NULL, + `F344_N` char(1) DEFAULT NULL, + `M520_N` char(1) DEFAULT NULL, + `MR_N` char(1) DEFAULT NULL, + `WKY_N` char(1) DEFAULT NULL, + `WN_N` char(1) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `SnpId` (`SnpId`) +) ENGINE=InnoDB AUTO_INCREMENT=4711685 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## role + +```sql +CREATE TABLE `role` ( + `the_id` varchar(36) NOT NULL, + `name` varchar(80) NOT NULL, + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`the_id`), + UNIQUE KEY `name` (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## roles_users + +```sql +CREATE TABLE `roles_users` ( + `user_id` int(11) DEFAULT NULL, + `role_id` int(11) DEFAULT NULL, + KEY `user_id` (`user_id`), + KEY `role_id` (`role_id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Sample + +```sql +CREATE TABLE `Sample` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, + `Name` varchar(30) DEFAULT NULL, + `Age` smallint(6) NOT NULL DEFAULT 0, + `Sex` enum('F','M') NOT NULL DEFAULT 'F', + `CreateTime` date NOT NULL DEFAULT '2001-01-01', + `TissueType` varchar(30) DEFAULT NULL, + `FromSrc` varchar(10) DEFAULT NULL, + `ImageURL` varchar(100) DEFAULT NULL, + `CELURL` varchar(120) DEFAULT NULL, + `DATURL` varchar(100) DEFAULT NULL, + `CHPURL` varchar(100) DEFAULT NULL, + `RPTURL` varchar(100) DEFAULT NULL, + `EXPURL` varchar(100) DEFAULT NULL, + `TXTURL` varchar(100) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `Name` (`StrainId`,`Name`,`CreateTime`) +) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## SampleXRef + +```sql +CREATE TABLE `SampleXRef` ( + `SampleId` smallint(5) unsigned NOT NULL DEFAULT 0, + `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + PRIMARY KEY (`ProbeFreezeId`,`SampleId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## SnpAll + +```sql +CREATE TABLE `SnpAll` ( + `Id` int(20) unsigned NOT NULL AUTO_INCREMENT, + `SpeciesId` smallint(5) unsigned DEFAULT 1, + `SnpName` char(30) DEFAULT NULL, + `Rs` char(30) DEFAULT NULL, + `Chromosome` char(2) DEFAULT NULL, + `Position` double DEFAULT NULL, + `Position_2016` double DEFAULT NULL, + `Alleles` char(5) DEFAULT NULL, + `Source` char(35) DEFAULT NULL, + `ConservationScore` double DEFAULT NULL, + `3Prime_UTR` mediumtext DEFAULT NULL, + `5Prime_UTR` mediumtext DEFAULT NULL, + `Upstream` mediumtext DEFAULT NULL, + `Downstream` mediumtext DEFAULT NULL, + `Intron` char(1) DEFAULT NULL, + `Non_Splice_Site` mediumtext DEFAULT NULL, + `Splice_Site` mediumtext DEFAULT NULL, + `Intergenic` char(1) DEFAULT NULL, + `Exon` char(1) DEFAULT NULL, + `Non_Synonymous_Coding` mediumtext DEFAULT NULL, + `Synonymous_Coding` mediumtext DEFAULT NULL, + `Start_Gained` mediumtext DEFAULT NULL, + `Start_Lost` mediumtext DEFAULT NULL, + `Stop_Gained` mediumtext DEFAULT NULL, + `Stop_Lost` mediumtext DEFAULT NULL, + `Unknown_Effect_In_Exon` mediumtext DEFAULT NULL, + `Domain` varchar(50) DEFAULT NULL, + `Gene` varchar(30) DEFAULT NULL, + `Transcript` varchar(50) DEFAULT NULL, + PRIMARY KEY (`Id`), + KEY `SnpName` (`SnpName`), + KEY `Rs` (`Rs`), + KEY `Position` (`Chromosome`,`Position`), + KEY `Source` (`Source`) +) ENGINE=InnoDB AUTO_INCREMENT=84086331 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## SnpAllele_to_be_deleted + +```sql +CREATE TABLE `SnpAllele_to_be_deleted` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `Base` char(20) DEFAULT NULL, + `Info` char(255) DEFAULT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## SnpAllRat + +```sql +CREATE TABLE `SnpAllRat` ( + `Id` int(20) NOT NULL AUTO_INCREMENT, + `SpeciesId` int(5) DEFAULT 2, + `SnpName` char(30) DEFAULT NULL, + `Chromosome` char(2) DEFAULT NULL, + `Position` double DEFAULT NULL, + `Alleles` char(5) DEFAULT NULL, + `Source` char(35) DEFAULT NULL, + `ConservationScore` double DEFAULT NULL, + `Domain` varchar(50) DEFAULT NULL, + `Gene` varchar(30) DEFAULT NULL, + `Transcript` varchar(50) DEFAULT NULL, + `Function` varchar(50) DEFAULT NULL, + PRIMARY KEY (`Id`), + KEY `SnpName` (`SnpName`), + KEY `Position` (`Chromosome`,`Position`), + KEY `Source` (`Source`) +) ENGINE=InnoDB AUTO_INCREMENT=97663615 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## SnpPattern + +```sql +CREATE TABLE `SnpPattern` ( + `SnpId` int(10) unsigned NOT NULL DEFAULT 0, + `129P2/OlaHsd` char(1) DEFAULT NULL, + `129S1/SvImJ` char(1) DEFAULT NULL, + `129S5/SvEvBrd` char(1) DEFAULT NULL, + `AKR/J` char(1) DEFAULT NULL, + `A/J` char(1) DEFAULT NULL, + `BALB/cJ` char(1) DEFAULT NULL, + `C3H/HeJ` char(1) DEFAULT NULL, + `C57BL/6J` char(1) DEFAULT NULL, + `CAST/EiJ` char(1) DEFAULT NULL, + `CBA/J` char(1) DEFAULT NULL, + `DBA/2J` char(1) DEFAULT NULL, + `LP/J` char(1) DEFAULT NULL, + `NOD/ShiLtJ` char(1) DEFAULT NULL, + `NZO/HlLtJ` char(1) DEFAULT NULL, + `PWK/PhJ` char(1) DEFAULT NULL, + `SPRET/EiJ` char(1) DEFAULT NULL, + `WSB/EiJ` char(1) DEFAULT NULL, + `PWD/PhJ` char(1) DEFAULT NULL, + `SJL/J` char(1) DEFAULT NULL, + `NZL/LtJ` char(1) DEFAULT NULL, + `CZECHII/EiJ` char(1) DEFAULT NULL, + `CALB/RkJ` char(1) DEFAULT NULL, + `ST/bJ` char(1) DEFAULT NULL, + `ISS/IbgTejJ` char(1) DEFAULT NULL, + `C57L/J` char(1) DEFAULT NULL, + `Qsi5` char(1) DEFAULT NULL, + `B6A6_Esline_Regeneron` char(1) DEFAULT NULL, + `129T2/SvEmsJ` char(1) DEFAULT NULL, + `BALB/cByJ` char(1) DEFAULT NULL, + `NZB/BlNJ` char(1) DEFAULT NULL, + `P/J` char(1) DEFAULT NULL, + `I/LnJ` char(1) DEFAULT NULL, + `PERC/EiJ` char(1) DEFAULT NULL, + `TALLYHO/JngJ` char(1) DEFAULT NULL, + `CE/J` char(1) DEFAULT NULL, + `MRL/MpJ` char(1) DEFAULT NULL, + `PERA/EiJ` char(1) DEFAULT NULL, + `IS/CamRkJ` char(1) DEFAULT NULL, + `ZALENDE/EiJ` char(1) DEFAULT NULL, + `Fline` char(1) DEFAULT NULL, + `BTBRT<+>tf/J` char(1) DEFAULT NULL, + `O20` char(1) DEFAULT NULL, + `C58/J` char(1) DEFAULT NULL, + `BPH/2J` char(1) DEFAULT NULL, + `DDK/Pas` char(1) DEFAULT NULL, + `C57BL/6NHsd` char(1) DEFAULT NULL, + `C57BL/6NTac` char(1) DEFAULT NULL, + `129S4/SvJae` char(1) DEFAULT NULL, + `BPL/1J` char(1) DEFAULT NULL, + `BPN/3J` char(1) DEFAULT NULL, + `PL/J` char(1) DEFAULT NULL, + `DBA/1J` char(1) DEFAULT NULL, + `MSM/Ms` char(1) DEFAULT NULL, + `MA/MyJ` char(1) DEFAULT NULL, + `NZW/LacJ` char(1) DEFAULT NULL, + `C57BL/10J` char(1) DEFAULT NULL, + `C57BL/6ByJ` char(1) DEFAULT NULL, + `RF/J` char(1) DEFAULT NULL, + `C57BR/cdJ` char(1) DEFAULT NULL, + `129S6/SvEv` char(1) DEFAULT NULL, + `MAI/Pas` char(1) DEFAULT NULL, + `RIIIS/J` char(1) DEFAULT NULL, + `C57BL/6NNIH` char(1) DEFAULT NULL, + `FVB/NJ` char(1) DEFAULT NULL, + `SEG/Pas` char(1) DEFAULT NULL, + `MOLF/EiJ` char(1) DEFAULT NULL, + `C3HeB/FeJ` char(1) DEFAULT NULL, + `Lline` char(1) DEFAULT NULL, + `SKIVE/EiJ` char(1) DEFAULT NULL, + `C57BL/6NCrl` char(1) DEFAULT NULL, + `KK/HlJ` char(1) DEFAULT NULL, + `LG/J` char(1) DEFAULT NULL, + `C57BLKS/J` char(1) DEFAULT NULL, + `SM/J` char(1) DEFAULT NULL, + `NOR/LtJ` char(1) DEFAULT NULL, + `ILS/IbgTejJ` char(1) DEFAULT NULL, + `C57BL/6JOlaHsd` char(1) DEFAULT NULL, + `SWR/J` char(1) DEFAULT NULL, + `C57BL/6JBomTac` char(1) DEFAULT NULL, + `SOD1/EiJ` char(1) DEFAULT NULL, + `NON/LtJ` char(1) DEFAULT NULL, + `JF1/Ms` char(1) DEFAULT NULL, + `129X1/SvJ` char(1) DEFAULT NULL, + `C2T1_Esline_Nagy` char(1) DEFAULT NULL, + `C57BL/6NJ` char(1) DEFAULT NULL, + `LEWES/EiJ` char(1) DEFAULT NULL, + `RBA/DnJ` char(1) DEFAULT NULL, + `DDY/JclSidSeyFrkJ` char(1) DEFAULT NULL, + `SEA/GnJ` char(1) DEFAULT NULL, + `C57BL/6JCrl` char(1) DEFAULT NULL, + `EL/SuzSeyFrkJ` char(1) DEFAULT NULL, + `HTG/GoSfSnJ` char(1) DEFAULT NULL, + `129S2/SvHsd` char(1) DEFAULT NULL, + `MOLG/DnJ` char(1) DEFAULT NULL, + `BUB/BnJ` char(1) DEFAULT NULL, + PRIMARY KEY (`SnpId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## SnpSource + +```sql +CREATE TABLE `SnpSource` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `Name` char(35) DEFAULT NULL, + `DateCreated` date DEFAULT NULL, + `DateAdded` date DEFAULT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Species + +```sql +CREATE TABLE `Species` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `SpeciesId` int(5) DEFAULT NULL, + `SpeciesName` varchar(50) DEFAULT NULL, + `Name` char(30) NOT NULL DEFAULT '', + `MenuName` char(50) DEFAULT NULL, + `FullName` char(100) NOT NULL DEFAULT '', + `Family` varchar(50) DEFAULT NULL, + `FamilyOrderId` smallint(6) DEFAULT NULL, + `TaxonomyId` int(11) DEFAULT NULL, + `OrderId` smallint(6) DEFAULT NULL, + PRIMARY KEY (`Id`), + KEY `Name` (`Name`) +) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## Strain + +```sql +CREATE TABLE `Strain` ( + `Id` int(20) NOT NULL AUTO_INCREMENT, + `Name` varchar(100) DEFAULT NULL, + `Name2` varchar(100) DEFAULT NULL, + `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0, + `Symbol` varchar(20) DEFAULT NULL, + `Alias` varchar(255) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `Name` (`Name`,`SpeciesId`), + KEY `Symbol` (`Symbol`) +) ENGINE=InnoDB AUTO_INCREMENT=88253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## StrainXRef + +```sql +CREATE TABLE `StrainXRef` ( + `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0, + `StrainId` int(20) NOT NULL, + `OrderId` int(20) DEFAULT NULL, + `Used_for_mapping` char(1) DEFAULT 'N', + `PedigreeStatus` varchar(255) DEFAULT NULL, + PRIMARY KEY (`InbredSetId`,`StrainId`), + UNIQUE KEY `Orders` (`InbredSetId`,`OrderId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## TableComments + +```sql +CREATE TABLE `TableComments` ( + `TableName` varchar(100) NOT NULL DEFAULT '', + `Comment` text DEFAULT NULL, + PRIMARY KEY (`TableName`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## TableFieldAnnotation + +```sql +CREATE TABLE `TableFieldAnnotation` ( + `TableField` varchar(100) NOT NULL DEFAULT '', + `Foreign_Key` varchar(100) DEFAULT NULL, + `Annotation` text DEFAULT NULL, + PRIMARY KEY (`TableField`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Temp + +```sql +CREATE TABLE `Temp` ( + `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `dbdisplayname` varchar(255) DEFAULT NULL, + `Name` varchar(30) DEFAULT NULL, + `description` mediumtext DEFAULT NULL, + `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '2004-01-01 12:00:00', + `DataId` int(11) NOT NULL DEFAULT 0, + `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 1, + `IP` varchar(20) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `Name` (`Name`) +) ENGINE=InnoDB AUTO_INCREMENT=178077 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## TempData + +```sql +CREATE TABLE `TempData` ( + `Id` int(10) unsigned NOT NULL DEFAULT 0, + `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, + `value` double NOT NULL DEFAULT 0, + `SE` double DEFAULT NULL, + `NStrain` smallint(6) DEFAULT NULL, + UNIQUE KEY `DataId` (`Id`,`StrainId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## temporary + +```sql +CREATE TABLE `temporary` ( + `tax_id` varchar(20) DEFAULT NULL, + `GeneID` varchar(20) DEFAULT NULL, + `Symbol` varchar(100) DEFAULT NULL, + `OMIM` varchar(100) DEFAULT NULL, + `HomoloGene` varchar(100) DEFAULT NULL, + `Other_GeneID` varchar(20) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## test_table + +```sql +CREATE TABLE `test_table` ( + `first_col` int(11) DEFAULT NULL, + `second_col` varchar(255) DEFAULT NULL, + `third_col` varchar(255) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Tissue + +```sql +CREATE TABLE `Tissue` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `TissueId` int(5) DEFAULT NULL, + `TissueName` varchar(50) DEFAULT NULL, + `Name` char(50) DEFAULT NULL, + `Short_Name` char(30) NOT NULL DEFAULT '', + `BIRN_lex_ID` char(30) DEFAULT NULL, + `BIRN_lex_Name` char(30) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `Short_Name` (`Short_Name`), + UNIQUE KEY `Name` (`Name`) +) ENGINE=InnoDB AUTO_INCREMENT=189 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## TissueProbeFreeze + +```sql +CREATE TABLE `TissueProbeFreeze` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `ChipId` smallint(5) unsigned NOT NULL DEFAULT 0, + `StrainId` varchar(100) NOT NULL DEFAULT '0', + `Name` varchar(100) NOT NULL DEFAULT '', + `FullName` varchar(100) NOT NULL DEFAULT '', + `ShortName` varchar(100) NOT NULL DEFAULT '', + `CreateTime` date NOT NULL DEFAULT '0000-00-00', + `InbredSetId` smallint(5) unsigned DEFAULT 1, + PRIMARY KEY (`Id`), + UNIQUE KEY `Name` (`Name`), + UNIQUE KEY `FullName` (`FullName`) +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## TissueProbeSetData + +```sql +CREATE TABLE `TissueProbeSetData` ( + `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `TissueID` int(10) unsigned NOT NULL DEFAULT 0, + `value` float NOT NULL DEFAULT 0, + PRIMARY KEY (`Id`,`TissueID`) +) ENGINE=InnoDB AUTO_INCREMENT=90563 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## TissueProbeSetFreeze + +```sql +CREATE TABLE `TissueProbeSetFreeze` ( + `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `TissueProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `AvgID` smallint(5) unsigned NOT NULL DEFAULT 0, + `Name` varchar(40) DEFAULT NULL, + `Name2` varchar(100) NOT NULL DEFAULT '', + `FullName` varchar(100) NOT NULL DEFAULT '', + `ShortName` varchar(100) NOT NULL DEFAULT '', + `CreateTime` date NOT NULL DEFAULT '0000-00-00', + `public` tinyint(4) NOT NULL DEFAULT 0, + `confidentiality` tinyint(4) NOT NULL DEFAULT 0, + `AuthorisedUsers` varchar(100) DEFAULT NULL, + PRIMARY KEY (`Id`), + UNIQUE KEY `FullName` (`FullName`), + UNIQUE KEY `Name` (`Name`), + KEY `NameIndex` (`Name2`) +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## TissueProbeSetXRef + +```sql +CREATE TABLE `TissueProbeSetXRef` ( + `TissueProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, + `ProbesetId` int(10) unsigned NOT NULL DEFAULT 0, + `DataId` int(10) unsigned NOT NULL DEFAULT 0, + `Mean` float DEFAULT 0, + `useStatus` char(1) DEFAULT NULL, + `Symbol` varchar(100) DEFAULT NULL, + `GeneId` varchar(20) DEFAULT NULL, + `Chr` char(3) DEFAULT NULL, + `Mb` double DEFAULT NULL, + `Mb_2016` double DEFAULT NULL, + `description` varchar(255) DEFAULT NULL, + `Probe_Target_Description` varchar(225) DEFAULT NULL, + PRIMARY KEY (`TissueProbeSetFreezeId`,`ProbesetId`), + UNIQUE KEY `DataId_IDX` (`DataId`), + KEY `symbol_IDX` (`Symbol`), + KEY `GeneId_IDX` (`GeneId`), + KEY `Position` (`Chr`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` + +## TraitMetadata + +```sql +CREATE TABLE `TraitMetadata` ( + `type` varchar(255) DEFAULT NULL, + `value` longtext DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## User + +```sql +CREATE TABLE `User` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `name` varchar(100) NOT NULL DEFAULT '', + `password` varchar(100) NOT NULL DEFAULT '', + `email` varchar(100) DEFAULT NULL, + `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', + `user_ip` varchar(20) DEFAULT NULL, + `lastlogin` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', + `disable` enum('Y','N') DEFAULT 'N', + `privilege` enum('guest','user','admin','root') DEFAULT NULL, + `grpName` varchar(40) DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name_index` (`name`) +) ENGINE=InnoDB AUTO_INCREMENT=358 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +``` + +## user + +```sql +CREATE TABLE `user` ( + `id` varchar(36) NOT NULL, + `email_address` varchar(50) NOT NULL, + `password` text NOT NULL, + `full_name` varchar(50) DEFAULT NULL, + `organization` varchar(50) DEFAULT NULL, + `active` tinyint(1) NOT NULL, + `registration_info` text DEFAULT NULL, + `confirmed` text DEFAULT NULL, + `superuser` text DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `email_address` (`email_address`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## user_collection + +```sql +CREATE TABLE `user_collection` ( + `id` varchar(36) NOT NULL, + `user` varchar(36) DEFAULT NULL, + `name` text DEFAULT NULL, + `created_timestamp` datetime /* mariadb-5.3 */ DEFAULT NULL, + `changed_timestamp` datetime /* mariadb-5.3 */ DEFAULT NULL, + `members` text DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `user` (`user`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## user_openids + +```sql +CREATE TABLE `user_openids` ( + `openid_url` varchar(255) NOT NULL, + `user_id` varchar(36) NOT NULL, + PRIMARY KEY (`openid_url`), + KEY `user_id` (`user_id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## UserPrivilege + +```sql +CREATE TABLE `UserPrivilege` ( + `UserId` int(10) unsigned NOT NULL, + `ProbeSetFreezeId` smallint(5) unsigned NOT NULL, + `download_result_priv` enum('N','Y') NOT NULL DEFAULT 'N', + KEY `userId` (`UserId`,`ProbeSetFreezeId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; +``` + +## Vlookup + +```sql +CREATE TABLE `Vlookup` ( + `Id` int(11) NOT NULL AUTO_INCREMENT, + `VLProbeSetId` mediumtext DEFAULT NULL, + `VLBlatSeq` longtext DEFAULT NULL, + `InfoFileId` int(5) DEFAULT NULL, + `DatasetId` int(5) DEFAULT NULL, + `SpeciesId` int(5) DEFAULT NULL, + `TissueId` int(5) DEFAULT NULL, + `InbredSetId` int(5) DEFAULT NULL, + `GeneChipId` int(5) DEFAULT NULL, + `AvgMethodId` int(5) DEFAULT NULL, + `InfoPageName` varchar(255) DEFAULT NULL, + `GN_AccesionId` int(5) DEFAULT NULL, + `Name` varchar(100) DEFAULT NULL, + `GeneId` varchar(10) DEFAULT NULL, + `Mb` double DEFAULT NULL, + `Chr` varchar(10) DEFAULT NULL, + `Probe_set_Blat_Mb_start` double DEFAULT NULL, + `Probe_set_Blat_Mb_end` double DEFAULT NULL, + `Strand` char(1) DEFAULT NULL, + `TxStart` double DEFAULT NULL, + `TxEnd` double DEFAULT NULL, + `cdsStart` double DEFAULT NULL, + `cdsEnd` double DEFAULT NULL, + `exonCount` int(7) DEFAULT NULL, + `exonStarts` mediumtext DEFAULT NULL, + `exonEnds` mediumtext DEFAULT NULL, + `ProteinID` varchar(15) DEFAULT NULL, + `AlignID` varchar(10) DEFAULT NULL, + `kgID` varchar(10) DEFAULT NULL, + `NM_ID` varchar(15) DEFAULT NULL, + `SnpName` char(30) DEFAULT NULL, + `Position` double DEFAULT NULL, + `HMDB_ID` varchar(255) DEFAULT NULL, + `Symbol` varchar(100) DEFAULT NULL, + `description` longtext DEFAULT NULL, + `alias` longtext DEFAULT NULL, + `Full_Description` longtext DEFAULT NULL, + `BlatSeq` mediumtext DEFAULT NULL, + `ChEBI_ID` int(10) DEFAULT NULL, + `ChEMBL_ID` varchar(100) DEFAULT NULL, + `CAS_number` varchar(100) DEFAULT NULL, + `PubChem_ID` int(10) DEFAULT NULL, + `ChemSpider_ID` varchar(10) DEFAULT NULL, + `UNII_ID` varchar(100) DEFAULT NULL, + `EC_number` varchar(100) DEFAULT NULL, + `KEGG_ID` varchar(100) DEFAULT NULL, + `Molecular_Weight` varchar(100) DEFAULT NULL, + `Nugowiki_ID` varchar(100) DEFAULT NULL, + `assembly` varchar(10) DEFAULT NULL, + PRIMARY KEY (`Id`), + KEY `Id` (`Id`) +) ENGINE=InnoDB AUTO_INCREMENT=754396017 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; +``` |
