From 047f236857d075b9cf9d1447b8c65bc0d7089a8a Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Mon, 1 Jan 2024 16:26:48 +0100
Subject: Doc database layout

---
 doc/database.org | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'doc')

diff --git a/doc/database.org b/doc/database.org
index 8bf2a404..82026697 100644
--- a/doc/database.org
+++ b/doc/database.org
@@ -32,6 +32,7 @@ select table_name,round(((data_length + index_length) / 1024 / 1024), 2) `Size i
 | ProbeSet                |    2880.21 | ProbeSetInfo        <- trait, e.g. 100001_at
 | ProbeSetFreeze          |       0.22 | DatasetInfo         <- dataset, e.g. "Hippocampus_BXD_Jun06"
 | Probe                   |    2150.30 | ProbeInfo           <- trait info incl sequence
+| ProbeFreeze             |       0.06 |
 | Phenotype               |       6.50 | PhenotypeMeta       <- "Hippocampus weight"
 | ProbeXRef               |     743.38 | ProbeFreezeDataIDs  <- link ProbeFreezeId,ProbeId with DataId
 | Datasets                |       2.31 | DatasetMeta         <- "Data generated by..."
@@ -42,6 +43,7 @@ select table_name,round(((data_length + index_length) / 1024 / 1024), 2) `Size i
 | PublishData             |      22.54 | PublishStrainValues <- id, strainId, value (3M traits)
 | PublishSE               |       4.71 | Published SE (300K traits)
 | PublishXRef             |       2.18 | List of changes on editing data (mostly Rob)
+| InbredSet               |       0.01 | InbredSetMeta -> Id,SpeciesId,FullName
 +-------------------------+------------+
 
 Less commonly used tables:
@@ -53,7 +55,7 @@ Less commonly used tables:
 | SnpAll                  |   15484.67 |
 | SnpPattern              |    9177.05 |
 | QuickSearch             |    5972.86 |
-| GenoData                |    3291.91 |
+| GenoData                |    3291.91 | Strain by genotype - only used in GN1
 | CeleraINFO_mm6          |     989.80 |
 | pubmedsearch            |    1032.50 |
 | GeneRIF_BASIC           |     448.54 |
@@ -63,7 +65,7 @@ Less commonly used tables:
 | Genbank                 |      37.71 |
 | AccessLog               |      42.38 |
 | GeneList                |      34.11 |
-| Geno                    |      33.90 |
+| Geno                    |      33.90 | Marker probe info (incl. sequence)
 | MachineAccessLog        |      28.34 |
 | IndelAll                |      22.42 |
 | ProbeH2                 |      13.26 |
@@ -94,7 +96,6 @@ Less commonly used tables:
 | TableFieldAnnotation    |       0.05 |
 | DatasetMapInvestigator  |       0.05 |
 | User                    |       0.04 |
-| ProbeFreeze             |       0.06 |
 | TableComments           |       0.02 |
 | Investigators           |       0.02 |
 | DBList                  |       0.03 |
@@ -102,11 +103,10 @@ Less commonly used tables:
 | GeneChip                |       0.01 |
 | GeneCategory            |       0.01 |
 | SampleXRef              |       0.01 |
-| InbredSet               |       0.01 | InbredSetMeta -> Id,SpeciesId,FullName
 | SnpAllele_to_be_deleted |       0.00 |
 | Organizations           |       0.01 |
 | PublishFreeze           |       0.00 |
-| GenoFreeze              |       0.00 |
+| GenoFreeze              |       0.00 | Used for public/private
 | Chr_Length              |       0.01 |
 | SnpSource               |       0.00 |
 | AvgMethod               |       0.00 |
-- 
cgit v1.2.3