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
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
    sigma_ra       F32      0.0
    sigma_dec      F32      0.0
    zp_mean        F32      0.0
    zp_stdev       F32      0.0
    fwhm           F32      0.0
    fwhm_range     F32      0.0
    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
