Changeset 12534 for trunk/dbconfig/diff.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/diff.md (modified) (3 diffs)

trunk/dbconfig/diff.md

@@ -1 @@
-# $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 +17 @@
 # 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 +27 @@
 
 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