Index: trunk/dbconfig/cam.md
===================================================================
--- trunk/dbconfig/cam.md	(revision 12531)
+++ trunk/dbconfig/cam.md	(revision 12534)
@@ -3,5 +3,5 @@
 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,6 +12,7 @@
 
 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
Index: trunk/dbconfig/config.md
===================================================================
--- trunk/dbconfig/config.md	(revision 12531)
+++ trunk/dbconfig/config.md	(revision 12534)
@@ -2,4 +2,4 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.18
+    pkg_version     STR     1.1.19
 END
Index: trunk/dbconfig/diff.md
===================================================================
--- trunk/dbconfig/diff.md	(revision 12531)
+++ trunk/dbconfig/diff.md	(revision 12534)
@@ -1,3 +1,3 @@
-# $Id: diff.md,v 1.1 2007-03-22 01:10:12 jhoblitt Exp $
+# $Id: diff.md,v 1.2 2007-03-22 03:13:04 jhoblitt Exp $
 
 diffRun METADATA
@@ -17,6 +17,6 @@
 # only ever 2 per run
 diffInputSkyfile METADATA
-    diff_id     S64         0       # Primary Key
-    warp_id     S64         0       # Primary Key
+    diff_id     S64         0       # Primary Key fkey(diff_id) ref diffRun(diff_id)
+    warp_id     S64         0       # Primary Key fkey(warp_id, skycell_id, tess_id) ref warpSkyfile(warp_id, skycell_id, tess_id)
     skycell_id  STR         64      # Primary Key
     tess_id     STR         64      # Primary Key
@@ -27,5 +27,5 @@
 
 diffSkyfile METADATA
-    diff_id     S64         0       # Primary Key
+    diff_id     S64         0       # Primary Key fkey(diff_id) ref diffRun(diff_id)
     uri         STR         255
     bg          F64         0.0
Index: trunk/dbconfig/stack.md
===================================================================
--- trunk/dbconfig/stack.md	(revision 12531)
+++ trunk/dbconfig/stack.md	(revision 12534)
@@ -1,3 +1,3 @@
-# $Id: stack.md,v 1.1 2007-03-22 01:10:12 jhoblitt Exp $
+# $Id: stack.md,v 1.2 2007-03-22 03:13:04 jhoblitt Exp $
 
 stackRun METADATA
@@ -12,10 +12,10 @@
 
 stackInputSkyfile METADATA
-    stack_id    S64         0       # Primary Key
-    warp_id     S64         0       # Primary Key
+    stack_id    S64         0       # Primary Key fkey(stack_id) ref stackRun(stack_id)
+    warp_id     S64         0       # Primary Key fkey(warp_id) ref warpSkyfile(warp_id)
 END
 
 stackSumSkyfile METADATA
-    stack_id    S64         0       # Primary Key
+    stack_id    S64         0       # Primary Key fkey(stack_id) ref stackRun(stack_id)
     uri         STR         255
     bg          F64         0.0
Index: trunk/dbconfig/warp.md
===================================================================
--- trunk/dbconfig/warp.md	(revision 12531)
+++ trunk/dbconfig/warp.md	(revision 12534)
@@ -1,3 +1,3 @@
-# $Id: warp.md,v 1.1 2007-03-22 01:10:12 jhoblitt Exp $
+# $Id: warp.md,v 1.2 2007-03-22 03:13:04 jhoblitt Exp $
 
 #
@@ -32,5 +32,5 @@
 
 warpSkyCellMap METADATA
-    warp_id     S64         0       # Primary Key
+    warp_id     S64         0       # Primary Key fkey(warp_id, cam_id) ref warpInputExp(warp_id, cam_id)
     skycell_id  STR         64      # Primary Key
     tess_id     STR         64      # Primary Key
@@ -43,5 +43,5 @@
 
 warpSkyfile METADATA
-    warp_id     S64         0       # Primary Key
+    warp_id     S64         0       # Primary Key fkey(warp_id, skycell_id, tess_id) ref warpSkyCellMap(warp_id, skycell_id, tess_id)
     skycell_id  STR         64      # Primary Key
     tess_id     STR         64      # Primary Key