# $Id: p4.md,v 1.5 2007-01-19 00:11:41 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
    workdir     STR         255
    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

p4WarpedImfile 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

p4StackedImfile 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?
p4DiffImfile 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
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
