From 0f8a4bb658bbea15c75dc30d590cb3818dd182eb Mon Sep 17 00:00:00 2001 From: Arun Isaac Date: Thu, 22 Jul 2021 13:26:25 +0530 Subject: sql: Add schema and schema map. * sql/map-database.sh, sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New files. --- sql/schema.svg | 1430 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 1430 insertions(+) create mode 100644 sql/schema.svg (limited to 'sql/schema.svg') diff --git a/sql/schema.svg b/sql/schema.svg new file mode 100644 index 0000000..2451899 --- /dev/null +++ b/sql/schema.svg @@ -0,0 +1,1430 @@ + + + + + + +test + + +cluster_Others + +Others + + + +node2 + +BXDSnpPosition + +- id +- Chr +- StrainId1 +- StrainId2 +- Mb +- Mb_2016 + + + +node3 + +CaseAttribute + +- Id +- Name + + + +node4 + +CaseAttributeXRef + +- ProbeSetFreezeId +- StrainId +- CaseAttributeId +- Value + + + +node3->node4 + + + + + +node5 + +CaseAttributeXRefNew + +- InbredSetId +- StrainId +- CaseAttributeId +- Value + + + +node3->node5 + + + + + +node6 + +DBList + +- Id +- DBTypeId +- FreezeId +- Name +- Code + + + +node7 + +DBType + +- Id +- Name + + + +node7->node6 + + + + + +node8 + +Datasets + +- DatasetId +- DatasetName +- GeoSeries +- PublicationTitle +- Summary +- ExperimentDesign +- AboutCases +- AboutTissue +- AboutPlatform +- AboutDataProcessing +- Contributors +- Citation +- Acknowledgment +- Notes +- InvestigatorId +- DatasetStatusId + + + +node10 + +EnsemblChip + +- Id +- ProbeSetSize +- Name +- Type + + + +node13 + +GeneChipEnsemblXRef + +- GeneChipId +- EnsemblChipId + + + +node10->node13 + + + + + +node11 + +Genbank + +- Id +- Sequence +- SpeciesId + + + +node14 + +GeneList + +- SpeciesId +- Id +- GeneSymbol +- GeneDescription +- Chromosome +- TxStart +- TxStart_2016 +- TxEnd +- TxEnd_2016 +- Strand +- GeneID +- NM_ID +- kgID +- GenBankID +- UnigenID +- ProteinID +- AlignID +- exonCount +- exonStarts +- exonEnds +- cdsStart +- cdsStart_2016 +- cdsEnd +- cdsEnd_2016 +- TxStart_mm8 +- TxEnd_mm8 +- Strand_mm8 +- exonCount_mm8 +- exonStarts_mm8 +- exonEnds_mm8 +- cdsStart_mm8 +- cdsEnd_mm8 +- Chromosome_mm8 +- Info_mm9 +- RGD_ID + + + +node11->node14 + + + + + +node12 + +GeneChip + +- Id +- GeneChipId +- GeneChipName +- Name +- GeoPlatform +- Title +- SpeciesId +- GO_tree_value + + + +node12->node13 + + + + + +node15 + +GeneRIF + +- Id +- versionId +- symbol +- PubMed_ID +- SpeciesId +- comment +- email +- createtime +- user_ip +- weburl +- initial +- display +- reason + + + +node16 + +GeneRIF_BASIC + +- SpeciesId +- GeneId +- symbol +- PubMed_ID +- createtime +- comment +- VersionId + + + +node17 + +Geno + +- Id +- SpeciesId +- Name +- Marker_Name +- Chr +- Mb +- Mb_2016 +- Sequence +- Source +- chr_num +- Source2 +- Comments +- used_by_geno_file +- Mb_mm8 +- Chr_mm8 + + + +node20 + +GenoXRef + +- GenoFreezeId +- GenoId +- DataId +- cM +- Used_for_mapping + + + +node17->node20 + + + + + +node18 + +GenoData + +- Id +- StrainId +- value + + + +node19 + +GenoFreeze + +- Id +- Name +- FullName +- ShortName +- CreateTime +- public +- InbredSetId +- confidentiality +- AuthorisedUsers + + + +node19->node20 + + + + + +node21 + +Homologene + +- HomologeneId +- GeneId +- TaxonomyId + + + +node37 + +ProbeSet + +- Id +- ChipId +- Name +- TargetId +- Symbol +- description +- Chr +- Mb +- Chr_2016 +- Mb_2016 +- alias +- GeneId +- GenbankId +- SNP +- BlatSeq +- TargetSeq +- UniGeneId +- Strand_Probe +- Strand_Gene +- OMIM +- comments +- Probe_set_target_region +- Probe_set_specificity +- Probe_set_BLAT_score +- Probe_set_Blat_Mb_start +- Probe_set_Blat_Mb_end +- Probe_set_Blat_Mb_start_2016 +- Probe_set_Blat_Mb_end_2016 +- Probe_set_strand +- Probe_set_Note_by_RW +- flag +- Symbol_H +- description_H +- chromosome_H +- MB_H +- alias_H +- GeneId_H +- chr_num +- name_num +- Probe_Target_Description +- RefSeq_TranscriptId +- ENSEMBLGeneId +- Chr_mm8 +- Mb_mm8 +- Probe_set_Blat_Mb_start_mm8 +- Probe_set_Blat_Mb_end_mm8 +- HomoloGeneID +- Biotype_ENS +- ProteinID +- ProteinName +- UniProtID +- Flybase_Id +- RGD_ID +- HMDB_ID +- Confidence +- ChEBI_ID +- ChEMBL_ID +- CAS_number +- PubChem_ID +- ChemSpider_ID +- UNII_ID +- EC_number +- KEGG_ID +- Molecular_Weight +- Nugowiki_ID +- Type +- Tissue +- PrimaryName +- SecondaryNames +- PeptideSequence + + + +node21->node37 + + + + + +node22 + +InbredSet + +- Id +- InbredSetId +- InbredSetName +- Name +- SpeciesId +- FullName +- public +- MappingMethodId +- GeneticType +- Family +- FamilyOrder +- MenuOrderId +- InbredSetCode + + + +node22->node5 + + + + + +node22->node19 + + + + + +node45 + +PublishFreeze + +- Id +- Name +- FullName +- ShortName +- CreateTime +- public +- InbredSetId +- confidentiality +- AuthorisedUsers + + + +node22->node45 + + + + + +node47 + +PublishXRef + +- Id +- InbredSetId +- PhenotypeId +- PublicationId +- DataId +- mean +- Locus +- LRS +- additive +- Sequence +- comments + + + +node22->node47 + + + + + +node51 + +StrainXRef + +- InbredSetId +- StrainId +- OrderId +- Used_for_mapping +- PedigreeStatus + + + +node22->node51 + + + + + +node54 + +Temp + +- Id +- dbdisplayname +- Name +- description +- createtime +- DataId +- InbredSetId +- IP + + + +node22->node54 + + + + + +node23 + +IndelAll + +- Id +- SpeciesId +- SourceId +- Name +- Chromosome +- Mb_start +- Mb_start_2016 +- Strand +- Type +- Mb_end +- Mb_end_2016 +- Size +- InDelSequence + + + +node24 + +IndelXRef + +- IndelId +- StrainId1 +- StrainId2 + + + +node23->node24 + + + + + +node27 + +MappingMethod + +- Id +- Name + + + +node27->node22 + + + + + +node28 + +NStrain + +- DataId +- StrainId +- count + + + +node31 + +Phenotype + +- Id +- Pre_publication_description +- Post_publication_description +- Original_description +- Units +- Pre_publication_abbreviation +- Post_publication_abbreviation +- Lab_code +- Submitter +- Owner +- Authorized_Users + + + +node31->node47 + + + + + +node32 + +Probe + +- Id +- ProbeSetId +- Name +- Sequence +- ExonNo +- SerialOrder +- Tm +- E_GSB +- E_NSB + + + +node35 + +ProbeH2 + +- ProbeFreezeId +- ProbeId +- h2 +- weight + + + +node32->node35 + + + + + +node42 + +ProbeXRef + +- ProbeFreezeId +- ProbeId +- DataId + + + +node32->node42 + + + + + +node33 + +ProbeData + +- Id +- StrainId +- value + + + +node34 + +ProbeFreeze + +- Id +- ProbeFreezeId +- ChipId +- TissueId +- Name +- FullName +- ShortName +- CreateTime +- InbredSetId + + + +node34->node35 + + + + + +node39 + +ProbeSetFreeze + +- Id +- ProbeFreezeId +- AvgID +- Name +- Name2 +- FullName +- ShortName +- CreateTime +- OrderList +- public +- confidentiality +- AuthorisedUsers +- DataScale + + + +node34->node39 + + + + + +node34->node42 + + + + + +node36 + +ProbeSE + +- DataId +- StrainId +- error + + + +node37->node32 + + + + + +node41 + +ProbeSetXRef + +- ProbeSetFreezeId +- ProbeSetId +- DataId +- Locus_old +- LRS_old +- pValue_old +- mean +- se +- Locus +- LRS +- pValue +- additive +- h2 + + + +node37->node41 + + + + + +node60 + +TissueProbeSetXRef + +- TissueProbeSetFreezeId +- ProbesetId +- DataId +- Mean +- useStatus +- Symbol +- GeneId +- Chr +- Mb +- Mb_2016 +- description +- Probe_Target_Description + + + +node37->node60 + + + + + +node38 + +ProbeSetData + +- Id +- StrainId +- value + + + +node39->node4 + + + + + +node39->node41 + + + + + +node63 + +UserPrivilege + +- UserId +- ProbeSetFreezeId +- download_result_priv + + + +node39->node63 + + + + + +node40 + +ProbeSetSE + +- DataId +- StrainId +- error + + + +node43 + +Publication + +- Id +- PubMed_ID +- Abstract +- Authors +- Title +- Journal +- Volume +- Pages +- Month +- Year + + + +node43->node47 + + + + + +node44 + +PublishData + +- Id +- StrainId +- value + + + +node46 + +PublishSE + +- DataId +- StrainId +- error + + + +node48 + +SnpAll + +- Id +- SpeciesId +- SnpName +- Rs +- Chromosome +- Position +- Position_2016 +- Alleles +- Source +- ConservationScore +- 3Prime_UTR +- 5Prime_UTR +- Upstream +- Downstream +- Intron +- Non_Splice_Site +- Splice_Site +- Intergenic +- Exon +- Non_Synonymous_Coding +- Synonymous_Coding +- Start_Gained +- Start_Lost +- Stop_Gained +- Stop_Lost +- Unknown_Effect_In_Exon +- Domain +- Gene +- Transcript + + + +node49 + +Species + +- Id +- SpeciesId +- SpeciesName +- Name +- MenuName +- FullName +- TaxonomyId +- OrderId + + + +node49->node11 + + + + + +node49->node12 + + + + + +node49->node14 + + + + + +node49->node15 + + + + + +node49->node16 + + + + + +node49->node17 + + + + + +node49->node22 + + + + + +node49->node23 + + + + + +node49->node48 + + + + + +node50 + +Strain + +- Id +- Name +- Name2 +- SpeciesId +- Symbol +- Alias + + + +node49->node50 + + + + + +node50->node2 + + + + + +node50->node4 + + + + + +node50->node5 + + + + + +node50->node18 + + + + + +node50->node24 + + + + + +node50->node28 + + + + + +node50->node33 + + + + + +node50->node36 + + + + + +node50->node38 + + + + + +node50->node40 + + + + + +node50->node44 + + + + + +node50->node46 + + + + + +node50->node51 + + + + + +node55 + +TempData + +- Id +- StrainId +- value +- SE +- NStrain + + + +node50->node55 + + + + + +node57 + +TissueProbeFreeze + +- Id +- ChipId +- StrainId +- Name +- FullName +- ShortName +- CreateTime +- InbredSetId + + + +node50->node57 + + + + + +node56 + +Tissue + +- Id +- TissueId +- TissueName +- Name +- Short_Name +- BIRN_lex_ID +- BIRN_lex_Name + + + +node56->node34 + + + + + +node58 + +TissueProbeSetData + +- Id +- TissueID +- value + + + +node56->node58 + + + + + +node59 + +TissueProbeSetFreeze + +- Id +- TissueProbeFreezeId +- AvgID +- Name +- Name2 +- FullName +- ShortName +- CreateTime +- public +- confidentiality +- AuthorisedUsers + + + +node57->node59 + + + + + +node59->node60 + + + + + +node61 + +TraitMetadata + +- type +- value + + + +node30 + +Organizations + +- OrganizationId +- OrganizationName + + + +node25 + +Investigators + +- FirstName +- LastName +- Address +- City +- State +- ZipCode +- Phone +- Email +- Country +- Url +- UserName +- UserPass +- UserDate +- UserLevel +- OrganizationId +- InvestigatorId + + + +node30->node25 + + + + + +node62 + +User + +- id +- name +- password +- email +- createtime +- user_ip +- lastlogin +- disable +- privilege +- grpName + + + +node62->node63 + + + + + +node67 + +user + +- id +- email_address +- password +- full_name +- organization +- active +- registration_info +- confirmed +- superuser + + + +node64 + +login + +- id +- user +- timestamp +- ip_address +- successful +- session_id +- assumed_by + + + +node67->node64 + + + + + +node68 + +user_collection + +- id +- user +- name +- created_timestamp +- changed_timestamp +- members + + + +node67->node68 + + + + + +node69 + +user_openids + +- openid_url +- user_id + + + +node67->node69 + + + + + +node1 + +AccessLog + +- id +- accesstime +- ip_address + + + +node9 + +Docs + +- id +- entry +- title +- content + + + +node26 + +MachineAccessLog + +- id +- accesstime +- ip_address +- db_id +- data_id +- action + + + +node29 + +News + +- id +- date +- details + + + +node52 + +TableComments + +- TableName +- Comment + + + +node53 + +TableFieldAnnotation + +- TableField +- Foreign_Key +- Annotation + + + +node65 + +role + +- the_id +- name +- description + + + +node66 + +roles_users + +- user_id +- role_id + + + -- cgit v1.2.3