# 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          F64         0.0
    bg_stdev    F64         0.0
    bg_mean_stdev   F64     0.0
    sigma_ra    F32         0.0
    sigma_dec   F32         0.0
    nastro      S32         0
    path_base   STR         255
    zp_mean     F32         0.0
    zp_stdev    F32         0.0
    fault       S16         0       # Key NOT NULL
END

camMask METADATA
    label       STR         64      # Primary Key
END
