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

1.5 2009/04/27 06:15:48 jsanborn
updated lots of stuff, will break older implementation of database
Index: src/hg/instinct/bioInt2/bioIntDb.as
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/bioInt2/bioIntDb.as,v
retrieving revision 1.4
retrieving revision 1.5
diff -b -B -U 4 -r1.4 -r1.5
--- src/hg/instinct/bioInt2/bioIntDb.as	29 Mar 2009 01:40:42 -0000	1.4
+++ src/hg/instinct/bioInt2/bioIntDb.as	27 Apr 2009 06:15:48 -0000	1.5
@@ -1,20 +1,20 @@
-table pathways
+table genesets
 "Pathway List"
 (
 uint id;            "Unique id"
 string name;        "Pathway name"
 string source;      "Pathway Source, i.e. KEGG, BioCarta"
 )
 
-table pathwayGenes
+table genesetGenes
 "Pathway Genes"
 (
 uint id;            "Unique id"
 uint gene_id;	    "Gene id"
 )
 
-table pathwayInfo
+table genesetInfo
 "Pathway Information"
 (
 uint id;             "Unique id"
 lstring description; "Description of pathway"
@@ -43,10 +43,8 @@
 uint type_id;       "Type of genomics data"
 uint num_samples;   "Number of samples in study"
 string name;        "Dataset name"
 string data_table;  "Array Data tablename"  
-string probe_table; "Probe tablename"
-string probe_to_gene_table; "Probe to gene tablename"
 )
 
 table cohorts
 "All cohorts"
@@ -61,32 +59,8 @@
 uint dataset_id;     "Dataset Id"
 uint cohort_id;      "Cohort Id"
 )
 
-table geneLookup
-"Lookup table linking knownGene"
-(
-uint id;            "Unique Id"
-string kgId;        "Known Gene Id"
-)
-
-table probeInfo
-"Probe Information"
-(
-uint id;            "Unique Id"
-string chrom;       "Chromosome"
-uint start;         "Start Base"
-uint stop;          "Stop Base"
-string name;        "Probe Name"
-)
-
-table probeToGene
-"Lookup table linking probe id and gene id"
-(
-uint probe_id;      "Probe Id"
-uint gene_id;       "Gene Id"
-)
-
 table probeSampleVal
 "Probe values for single sample"
 (
 uint probe_id;      "Probe Id"
@@ -109,9 +83,8 @@
 string name;         "Sample Name"
 uint patient_id;     "Patient Id"
 string patient_name; "Patient Name"
 uint dataset_id;     "Dataset Id"
-uint exp_id;         "Index in dataset -- for probeVals format"
 uint tissue_id;      "Tissue Type Id"
 )
 
 table features
@@ -162,8 +135,9 @@
 "All analysis features"
 (
 uint id;              "Feature Id"
 string feature_name;  "Feature Name"
+string type;          "Feature Type"
 )
 
 table analysisVals
 "All analysis vals"