Changeset 16730 for trunk/dbconfig/warp.md

Timestamp:

Feb 28, 2008, 3:03:17 PM (18 years ago)

Author:

jhoblitt

Message:

VERSION 1.1.31
remove warpInputExp table

File:

• trunk/dbconfig/warp.md (modified) (4 diffs)

trunk/dbconfig/warp.md

@@ -1 @@
-# $Id: warp.md,v 1.12 2008-01-26 04:24:33 eugene Exp $
+# $Id: warp.md,v 1.13 2008-02-29 01:03:17 jhoblitt Exp $
 
 #
@@ -11 +11 @@
 warpRun METADATA
     warp_id     S64         0       # Primary Key AUTO_INCREMENT
+    cam_id      S64         0       # Key INDEX(warp_id, cam_id) fkey(cam_id) ref camProcessedExp(cam_id)
     mode        STR         64      # Key
     state       STR         64      # Key
@@ -19 +20 @@
     end_stage   STR         64      # Key
     registered  TAI         NULL
-END
-
-#
-# Warp to Sky Cell Mode
-#
-
-# the list of imfiles in our skycell keyed against phase 3
-# only allow one cam_version of an exp_id per warpRun
-warpInputExp METADATA
-    warp_id     S64         0       # Primary Key fkey(warp_id) ref warpRun(warp_id)
-    cam_id      S64         0       # Primary Key fkey(cam_id) ref camProcessedExp(cam_id)
 # if magic is T then look for the exp_id in the magic output tables
     magiced     BOOL        f       # Key
@@ -35 +25 @@
 
 warpSkyCellMap METADATA
-    warp_id     S64         0       # Primary Key fkey(warp_id, cam_id) ref warpInputExp(warp_id, cam_id)
+    warp_id     S64         0       # Primary Key fkey(warp_id, cam_id) ref warpRun(warp_id, cam_id)
     skycell_id  STR         64      # Primary Key
     tess_id     STR         64      # Primary Key