Changeset 14065 for trunk/dbconfig

Timestamp:

Jul 6, 2007, 5:42:07 PM (19 years ago)

Author:

jhoblitt

Message:

remove chipInputImfile table

File:

• trunk/dbconfig/chip.md (modified) (1 diff)

trunk/dbconfig/chip.md

@@ -1 @@
-#
-#  We are dependant on the assumption that there is only ever one exp_id in a
-#  chipRun although the database does not enforce this.
-#
-
 chipRun METADATA
     chip_id     S64         0       # Primary Key AUTO_INCREMENT
-    state       STR         64      # key
+    exp_id      S64         64      # Primary Key fkey (exp_id) ref rawExp(exp_id)
+    state       STR         64      # Key
     workdir     STR         255 
-    workdir_state STR       64      # key
-    label       STR         64      # key
+    workdir_state STR       64      # Key
+    label       STR         64      # Key
     reduction   STR         64      # Reduction class
-    expgroup    STR         64      # key
+    expgroup    STR         64      # Key
     dvodb       STR         255
 END
 
-chipInputImfile METADATA
-    chip_id     S64         0       # Primary Key fkey (chip_id) ref chipRun(chip_id)
-    exp_id      S64         64      # Primary Key fkey (exp_id, class_id) ref rawImfile (exp_id, class_id)
-    class_id    STR         64      # Primary Key
-END
-
 chipProcessedImfile METADATA
-    chip_id     S64         0       # Primary Key fkey (chip_id, exp_id, class_id) ref chipInputImfile(chip_id, exp_id, class_id)
-    exp_id     S64         64      # Primary Key
+    chip_id         S64     0       # Primary Key fkey (chip_id, exp_id) ref chipRun(chip_id, exp_id)
+    exp_id          S64     64      # Primary Key fkey (exp_id, class_id) ref rawImfile(exp_id, class_id)
     class_id        STR     64      # Primary Key
     uri             STR     255