src/hg/instinct/bioInt2/bioIntDb.as 1.2

1.2 2009/03/21 19:54:10 jsanborn
added routine to set cohorts
Index: src/hg/instinct/bioInt2/bioIntDb.as
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/bioInt2/bioIntDb.as,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 4 -r1.1 -r1.2
--- src/hg/instinct/bioInt2/bioIntDb.as	20 Mar 2009 06:06:31 -0000	1.1
+++ src/hg/instinct/bioInt2/bioIntDb.as	21 Mar 2009 19:54:10 -0000	1.2
@@ -47,8 +47,22 @@
 string probe_table; "Probe tablename"
 string probe_to_gene_table; "Probe to gene tablename"
 )
 
+table cohorts
+"All cohorts"
+(
+uint id;             "Cohort Id"
+string name;         "Cohort name"
+)
+
+table datasetCohort
+"Dataset cohort lookup"
+(
+uint dataset_id;     "Dataset Id"
+uint cohort_id;      "Cohort Id"
+)
+
 table geneLookup
 "Lookup table linking knownGene"
 (
 uint id;            "Unique Id"
@@ -117,19 +131,36 @@
 double val;          "Value"
 string code;         "Coded Value"
 )
 
+table analyses
+"All analyses run"
+(
+uint id;             "Analysis id"
+uint cohort_id;      "Cohort Id"
+string module;       "Analysis Module"
+string result_table; "Table containing result"
+)
+
+table analysisParams
+"All analysis parameters"
+(
+uint analysis_id;      "Module Id"
+string key;          "Parameter key"
+string val;          "Parameter val"
+)
+
 table analysisFeatures
 "All analysis features"
 (
-uint feature_id;      "Feature Id"
+uint id;              "Feature Id"
 string feature_name;  "Feature Name"
 )
 
 table analysisVals
 "All analysis vals"
 (
 uint sample_id;       "Sample Id"
-uint feature_id;      "Feature Id"
+uint feature_id;      "Analysis Feature Id"
 float val;            "Val"
 float conf;           "Confidence"
 )