Index: trunk/dbconfig/tasks.md
===================================================================
--- trunk/dbconfig/tasks.md	(revision 13617)
+++ trunk/dbconfig/tasks.md	(revision 14017)
@@ -1,3 +1,3 @@
-# $Id: tasks.md,v 1.134 2007-06-05 00:24:52 eugene Exp $
+# $Id: tasks.md,v 1.135 2007-07-05 20:13:45 jhoblitt Exp $
 
 # this table records all exposure ID ever seen from the summit
@@ -85,8 +85,10 @@
     exp_tag     STR         64      # Primary Key
     exp_id      STR         64      # Key
+    state       STR         64      # Key
     camera      STR         64      # Key
     telescope   STR         64      # Key
     imfiles     S32         0
     workdir     STR         255     # destination for output files
+    workdir_state STR       64      # key
 END
 
@@ -94,6 +96,5 @@
 # from there
 newImfile METADATA
-    exp_tag     STR         64      # Primary Key
-    class       STR         64      # Primary Key
+    exp_tag     STR         64      # Primary Key fkey(exp_tag) ref newExp(exp_tag)
     class_id    STR         64      # Primary Key
     uri         STR         255
@@ -102,5 +103,5 @@
 # paired with rawImfile
 rawExp METADATA
-    exp_tag     STR         64      # Primary Key
+    exp_tag     STR         64      # Primary Key fkey(exp_tag) ref newExp(exp_tag)
     exp_id      STR         64      # Key
     camera      STR         64
@@ -135,5 +136,5 @@
 
 rawImfile METADATA
-    exp_tag     STR         64      # Primary Key
+    exp_tag     STR         64      # Primary Key fkey(exp_tag, class_id) ref newImfile(exp_tag, class_id)
     class_id    STR         64      # Primary Key
     uri         STR         255