Changeset 14023 for trunk/dbconfig/chip.md

Timestamp:

Jul 5, 2007, 3:16:08 PM (19 years ago)

Author:

jhoblitt

Message:

rename exp_id -> exp_name
rename exp_tag -> exp_id
add add rawExp.exp_tag for use as an external name only

File:

• trunk/dbconfig/chip.md (modified) (2 diffs)

trunk/dbconfig/chip.md

@@ -1 +1 @@
 #
-#  We are dependant on the assumption that there is only ever one exp_tag in a
+#  We are dependant on the assumption that there is only ever one exp_id in a
 #  chipRun although the database does not enforce this.
 #
@@ -17 +17 @@
 chipInputImfile METADATA
     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)
+    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_tag, class_id) ref chipPendingImfile(chip_id, exp_tag, class_id)
-    exp_tag     STR         64      # Primary Key
+    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
     class_id        STR     64      # Primary Key
     uri             STR     255