Index: /branches/backtrack/dbconfig/chip.md
===================================================================
--- /branches/backtrack/dbconfig/chip.md	(revision 13991)
+++ /branches/backtrack/dbconfig/chip.md	(revision 13992)
@@ -2,9 +2,9 @@
 # class is missing
 
-chipPendingExp METADATA
+chipRun METADATA
     chip_id     S64         0       # Primary Key AUTO_INCREMENT
-    exp_tag     STR         64      # Primary Key
-    guide_id    S64         0       # Not NULL
+    state       STR         64      # key
     workdir     STR         255 
+    workdir_state STR       64      # key
     label       STR         64      # key
     reduction   STR         64      # Reduction class
@@ -16,22 +16,11 @@
 
 chipPendingImfile METADATA
-    chip_id     S64         0       # Primary Key
+    chip_id     S64         0       # Primary Key fkey (chip_id) ref chipRun(chip_id)
+    exp_tag     STR         64      # Primary Key fkey (exp_tag, class_id) ref rawImfile (exp_tag, class_id)
     class_id    STR         64      # Primary Key
-    uri         STR         255
 END
 
 # nclass & ndone?
 # and/or logging imfile done better?
-
-chipProcessedExp METADATA
-    chip_id     S64         0       # Primary Key
-    exp_tag     STR         64      # Primary Key
-    guide_id    S64         0       # Not NULL
-    workdir     STR         255 
-    label       STR         64      # key
-    reduction   STR         64
-    expgroup    STR         64      # key
-    dvodb       STR         255
-END
 
 chipMask METADATA
@@ -43,9 +32,6 @@
 
 chipProcessedImfile METADATA
-    chip_id     S64         0       # Primary Key
-# exp_tag/guide_id are redudant with the values stored in chipProcessedExp.
-# exp_tag can be removed at virtually any time (SQL queriers will need to be
-# fixed) but guide_id needs to wait until we know if this can be tracked at
-# just the exp level.
+    chip_id     S64         0       # Primary Key fkey (chip_id, exp_tag, class_id) ref chipPendingImfile(chip_id, exp_tag, class_id)
+    exp_tag     STR         64      # Primary Key
     class_id        STR     64      # Primary Key
     uri             STR     255