Index: trunk/dbconfig/magic.md
===================================================================
--- trunk/dbconfig/magic.md	(revision 11813)
+++ trunk/dbconfig/magic.md	(revision 11813)
@@ -0,0 +1,85 @@
+# $Id: magic.md,v 1.1 2007-02-15 02:12:42 jhoblitt Exp $
+
+#
+# Feed imfiles to Magic Mode
+#
+
+# also uses p4InputExp
+
+# output from magic
+p4MagicMaskImfile 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
+
+# output from magic
+# p4MagicMaskImfile 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
+# 
+# # the list of imfiles in our skycell keyed against phase 3
+# p4InputImfile  METADATA
+#     p4_id       S32         0       # Primary Key
+#     skycell_id  STR         64      # Primary Key
+#     tess_id     STR         64      # 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
+# # either a input or a template
+#     kind        STR         64      # Key 
+# END
+# 
+# 
+# # one diff image per input to the current stack
+# # XXX how will diff against the static sky be handled?
+# p4DiffImfile METADATA
+#     p4_id       S32         0       # Primary Key
+#     skycell_id  STR         64      # Primary Key
+#     tess_id     STR         64      # 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_mean_stdev   F64     0.0
+# END
+# 
+# p4StackedImfile METADATA
+#     p4_id       S32         0       # Primary Key
+#     skycell_id  STR         64      # Primary Key
+#     tess_id     STR         64      # 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_mean_stdev   F64     0.0
+# END
+# 
+# # output from magic
+# p4MagicMaskImfile 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
