Changeset 16588 for trunk/dbconfig

Timestamp:

Feb 21, 2008, 6:09:46 PM (18 years ago)

Author:

jhoblitt

Message:

replumb pz* steps

File:

• trunk/dbconfig/tasks.md (modified) (3 diffs)

trunk/dbconfig/tasks.md

@@ -1 @@
-# $Id: tasks.md,v 1.147 2008-02-15 19:54:44 eugene Exp $
+# $Id: tasks.md,v 1.148 2008-02-22 04:09:46 jhoblitt Exp $
 
 # this table records all exposure ID ever seen from the summit
@@ -43 +43 @@
 # list of source images -- updated as exposures/filesets are queried
 summitImfile METADATA
-    exp_name    STR         64      # Primary Key
+    exp_name    STR         64      # Primary Key fkey(exp_name, camera, telescope) ref summitExp(exp_name, camera, telescope)
     camera      STR         64      # Primary Key
     telescope   STR         64      # Primary Key
@@ -56 +56 @@
 # list of exposures that have had their imfiles/files registered (but not
 # downloaded) 
-pzPendingExp METADATA
-    exp_name    STR         64      # Primary Key
-    camera      STR         64      # Primary Key
-    telescope   STR         64      # Primary Key
-END
-
-pzPendingImfile METADATA
-    exp_name    STR         64      # Primary Key
-    camera      STR         64      # Primary Key
-    telescope   STR         64      # Primary Key
-    class       STR         64      # Primary Key
-    class_id    STR         64      # Primary Key
-END
-
-# list of exposures that have had all of their imfiles downloaded
-pzDoneExp METADATA
-    exp_name    STR         64      # Primary Key
-    camera      STR         64      # Primary Key
-    telescope   STR         64      # Primary Key
-END
-
-pzDoneImfile METADATA
-    exp_name    STR         64      # Primary Key
-    camera      STR         64      # Primary Key
+pzDownloadExp METADATA
+    exp_name    STR         64      # Primary Key fkey(exp_name, camera, telescope) ref summitExp(exp_name, camera, telescope)
+    camera      STR         64      # Primary Key
+    telescope   STR         64      # Primary Key
+    state       STR         64      # Key 
+END
+
+pzDownloadImfile METADATA
+    exp_name    STR         64      # Primary Key fkey(exp_name, camera, telescope) ref pzDownloadExp(exp_name, camera, telescope)
+    camera      STR         64      # Primary Key fkey(exp_name, camera, telescope, class, class_id) ref summitImfile(exp_name, camera, telescope, class, class_id)
     telescope   STR         64      # Primary Key
     class       STR         64      # Primary Key