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

chipProcessedImfile METADATA
    chip_id         S64     0       # Primary Key fkey (chip_id, exp_id) ref chipRun(chip_id, exp_id)
    exp_id          S64     64      # Primary Key fkey (exp_id, class_id) ref rawImfile(exp_id, class_id)
    class_id        STR     64      # Primary Key
    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

chipMask METADATA
    label       STR         64      # Primary Key
END
