Changeset 6656

Timestamp:

Mar 20, 2006, 4:38:36 PM (20 years ago)

Author:

jhoblitt

Message:

add phase Z

File:

• trunk/dbconfig/tasks.md (modified) (1 diff)

trunk/dbconfig/tasks.md

@@ -1 @@
-# $Id: tasks.md,v 1.20 2006-02-03 21:13:25 jhoblitt Exp $
+# $Id: tasks.md,v 1.21 2006-03-21 02:38:36 jhoblitt Exp $
+
+# this table records all exposure ID ever seen from the summit
+# exp_id == fileset
+summitExp METADATA
+    exp_id      STR         64     # Primary Key
+    camera      STR         255
+    telescope   STR         255
+    # time
+    exp_type    STR         255
+    uri         STR         255
+END
+
+# class == type
+# class_id == type
+pzPendingImfiles METADATA
+    exp_id      STR         64      # Key
+    bytes       S32         0
+    md5sum      STR         32
+    class       STR         64
+    class_id    STR         64
+    uri         STR         255
+END
+
+pzPendingExp METADATA
+    exp_id      STR         64      # Primary Key
+    camera      STR         255
+    telescope   STR         255
+    # time
+    exp_type    STR         64
+    class       STR         64
+    imfiles     S32         0
+END
 
 newExp METADATA
-    exp_id      STR         255     # Primary Key
+    exp_id      STR         64      # Primary Key
     camera      STR         255
     telescope   STR         255
-    exp_type    STR         255
-    class       STR         255
+    # time
+    exp_type    STR         64
+    class       STR         64
     imfiles     S32         0
 END
 
 newImfile METADATA
-    exp_id      STR         255     # Key
-    class_id    STR         255
+    exp_id      STR         64      # Key
+    class       STR         64
+    class_id    STR         64
     url         STR         255
 END