# Tables for static sky analysis

staticskyRun METADATA
    ss_id       S64         0       # Primary Key AUTO_INCREMENT
    state       STR         64      # Key
    workdir     STR         255
    label       STR         64      # Key
    data_group  STR         64      # Key
    dist_group  STR         64      # Key
    reduction   STR         64      # Reduction class
    registered  TAI         NULL
    note        STR         255
END

staticskyInput METADATA
    ss_id       S64         0       # Primary Key fkey(ss_id) ref staticskyRun(ss_id)
    stack_id    S64         0       # Primary Key fkey(stack_id) ref stackSumSkyfile(stack_id)
END

staticSkyResult METADATA
    ss_id              S64    0       # Primary Key fkey(ss_id) ref staticskyRun(ss_id)
    path_base          STR    255
    dtime_phot         F32    0.0
    dtime_script       F32    0.0
    sources            S32    0
    hostname           STR    64
    good_frac          F32    0.0     # Key
    fault              S16    0       # Key
    quality            S16    0	      # Key
END
