Changeset 13994 for branches/backtrack/dbconfig/cam.md

Timestamp:

Jul 2, 2007, 3:46:36 PM (19 years ago)

Author:

jhoblitt

Message:

refactor camtool & db to preserve metadata history

File:

• branches/backtrack/dbconfig/cam.md (modified) (2 diffs)

branches/backtrack/dbconfig/cam.md

@@ -1 +1 @@
 # imfiles is not here... is it needed?
 
-camPendingExp METADATA
+camRun METADATA
     cam_id      S64         0       # Primary Key AUTO_INCREMENT
-    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipProcessedExp(chip_id)
+    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipRun(chip_id)
+    state       STR         64      # key
     workdir     STR         255 
+    workdir_state STR       64      # key
     label       STR         64      # key
     reduction   STR         64
@@ -14 +16 @@
 # the camPendingExp row gets deleted so we can not put a fkey on cam_id
     cam_id         S64      0       # Primary Key
-    chip_id        S64      0       # Primary Key fkey(chip_id) ref chipProcessedExp(chip_id)
-    workdir        STR      255 
-    label          STR      64      # key
-    reduction      STR      64
-    expgroup       STR      64      # key
-    dvodb          STR      255
+    chip_id        S64      0       # Primary Key fkey(cam_id, chip_id) ref camRun(cam_id, chip_id)
     uri            STR      255
     bg             F32      0.0