Index: /trunk/dbconfig/p4.md
===================================================================
--- /trunk/dbconfig/p4.md	(revision 10640)
+++ /trunk/dbconfig/p4.md	(revision 10640)
@@ -0,0 +1,81 @@
+# $Id: p4.md,v 1.1 2006-12-12 03:53:01 jhoblitt Exp $
+
+# define a new p4run for a single skycell
+p4Run METADATA
+    p4_id       S32         0       # Primary Key AUTO_INCREMENT
+    survey_mode  STR       64      # Key
+    state       STR         64      # Key
+    filter      STR         64
+    skycell_id  STR         64
+    tess_id     STR         64
+    ra          F64         0.0
+    decl        F64         0.0
+    input_ss    STR         64
+    output_ss   STR         64
+END
+
+# the list of imfiles in our skycell keyed against phase 3
+p4InputImfile  METADATA
+    p4_id       S32         0       # Primary Key
+    exp_tag     STR         64      # Primary Key
+    p3_version  S32         0       # Primary Key
+# class is not yet consistently carried through pXtools
+#    class       STR         64      # Primary Key
+    class_id    STR         64      # Primary Key
+END
+
+p4PWarpedImfile METADATA
+    p4_id       S32         0       # Primary Key
+    exp_tag     STR         64      # Primary Key
+    p3_version  S32         0       # Primary Key
+# class is not yet consistently carried through pXtools
+#    class       STR         64      # Primary Key
+    class_id    STR         64      # Primary Key
+    uri         STR         255
+    bg          F64         0.0
+    bg_stdev    F64         0.0
+    bg_mean_stdev   F64     0.0
+    b1_uri      STR         255
+    b2_uri      STR         255
+END
+
+p4PStackedImfile METADATA
+    p4_id       S32         0       # Primary Key
+# class is not yet consistently carried through pXtools
+#    class       STR         64      # Primary Key
+    class_id    STR         64      # Primary Key
+    uri         STR         255
+    bg          F64         0.0
+    bg_stdev    F64         0.0
+    bg_mean_stdev   F64     0.0
+    b1_uri      STR         255
+    b2_uri      STR         255
+END
+
+# one diff image per input to the current stack
+# XXX how will diff against the static sky be handled?
+p4PDiffImfile METADATA
+    p4_id       S32         0       # Primary Key
+    exp_tag     STR         64      # Primary Key
+    p3_version  S32         0       # Primary Key
+# class is not yet consistently carried through pXtools
+#    class       STR         64      # Primary Key
+    class_id    STR         64      # Primary Key
+    uri         STR         255
+    bg          F64         0.0
+    bg_stdev    F64         0.0
+    bg_mean_stdev   F64     0.0
+    b1_uri      STR         255
+    b2_uri      STR         255
+END
+
+# output from magic
+p4PMagicMaskImfile METADATA
+    p4_id       S32         0       # Primary Key
+    exp_tag     STR         64      # Primary Key
+    p3_version  S32         0       # Primary Key
+# class is not yet consistently carried through pXtools
+#    class       STR         64      # Primary Key
+    class_id    STR         64      # Primary Key
+    uri         STR         255
+END