# imfiles is not here... is it needed?

camPendingExp METADATA
    cam_id      S64         0       # Primary Key AUTO_INCREMENT
    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipProcessedExp(chip_id)
    workdir     STR         255 
    label       STR         64      # key
    recipe      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(chip_id) ref chipProcessedExp(chip_id)
    workdir        STR      255 
    label          STR      64      # key
    recipe         STR      64
    expgroup       STR      64      # key
    dvodb          STR      255
    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
