Changeset 13992

Timestamp:

Jun 29, 2007, 3:23:27 PM (19 years ago)

Author:

jhoblitt

Message:

refactor chiptool & db to preserve metadata history

File:

• branches/backtrack/dbconfig/chip.md (modified) (3 diffs)

branches/backtrack/dbconfig/chip.md

@@ -2 +2 @@
 # 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 +16 @@
 
 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 +32 @@
 
 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