Changeset 12534 for trunk/dbconfig/cam.md

Timestamp:

Mar 21, 2007, 5:13:04 PM (19 years ago)

Author:

jhoblitt

Message:

VERSION 1.1.19
initial round of foreign key constraints

File:

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

trunk/dbconfig/cam.md

@@ -3 +3 @@
 camPendingExp METADATA
     cam_id      S64         0       # Primary Key AUTO_INCREMENT
-    chip_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
@@ -12 +12 @@
 
 camProcessedExp METADATA
+# 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
+    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipProcessedExp.chip_id)
     workdir     STR         255 
     label       STR         64      # key