Changeset 14597 for trunk/dbconfig/magic.md

Timestamp:

Aug 21, 2007, 4:25:06 PM (19 years ago)

Author:

jhoblitt

Message:

remove exp_id field from pz* tables
formatting

File:

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

trunk/dbconfig/magic.md

@@ -1 @@
-# $Id: magic.md,v 1.3 2007-08-14 04:04:30 jhoblitt Exp $
+# $Id: magic.md,v 1.4 2007-08-22 02:25:06 jhoblitt Exp $
 
 magicRun METADATA
@@ -13 +13 @@
 magicInputSkyfile METADATA
     magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
-    diff_id     S64         0       # Primary Key fkey(diff_id) ref diffRun(diff_id)
-    node        S32         0       # AUTO_INCREMENT
+    diff_id     S64         0       # Key fkey(diff_id) ref diffRun(diff_id)
+    node        S32         0       # AUTO_INCREMENT INDEX(magic_id, node)
 END
 
 magicTree METADATA
     magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
-    node        STR         64 
-    dep         STR         64
+    node        STR         64      # Primary Key fkey(magic_id, node) ref magicInputSkyfile(magic_id, node)
+    dep         STR         64      # fkey(magic_id, dep) ref magicInputSkyfile(magic_id, node)
+
 END
 
 magicNodeResult METADATA
     magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
-    node        STR         64 
+    node        STR         64      # Primary Key fkey(magic_id, node) ref magicInputSkyfile(magic_id, node)
     uri         STR         255
 END
 
 magicMask METADATA
-    magic_id    S64         0       # Primary Key AUTO_INCREMENT
+    magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
     uri         STR         255
 END