camRun METADATA
    cam_id      S64         0       # Primary Key AUTO_INCREMENT
    chip_id     S64         0       # Key INDEX(cam_id, chip_id) fkey(chip_id) ref chipRun(chip_id)
    state       STR         64      # key
    workdir     STR         255 
    workdir_state STR       64      # key
    label       STR         64      # key
    reduction   STR         64
    expgroup    STR         64      # key
    dvodb       STR         255
    tess_id     STR         64
    end_stage   STR         64      # Key
END

camProcessedExp METADATA
# the camPendingExp row gets deleted so we can not put a fkey on cam_id
    cam_id         S64      0       # Primary Key
    chip_id        S64      0       # Primary Key fkey(cam_id, chip_id) ref camRun(cam_id, chip_id)
    uri            STR      255
    bg             F32      0.0
    bg_stdev       F32      0.0
    bg_mean_stdev  F32      0.0
    bias	   F32	    0.0
    bias_stdev     F32	    0.0
    fringe_0       F32      0.0
    fringe_1       F32      0.0
    fringe_2       F32      0.0
    sigma_ra       F32      0.0
    sigma_dec      F32      0.0
    ap_resid       F32	    0.0
    ap_resid_stdev F32	    0.0
    zp_mean        F32      0.0
    zp_stdev       F32      0.0
    fwhm_major     F32      0.0
    fwhm_minor     F32      0.0
    dtime_detrend  F32      0.0
    dtime_photom   F32      0.0
    dtime_astrom   F32      0.0
    hostname       STR      64
    n_stars        S32      0
    n_extended     S32      0
    n_cr           S32      0
    n_astrom       S32      0
    path_base      STR      255
    fault          S16      0       # Key NOT NULL
END

camMask METADATA
    label       STR         64      # Primary Key
END
