Index: /branches/eam_branches/ipp-20230313/dbconfig/xcadd.md =================================================================== --- /branches/eam_branches/ipp-20230313/dbconfig/xcadd.md (revision 42569) +++ /branches/eam_branches/ipp-20230313/dbconfig/xcadd.md (revision 42569) @@ -0,0 +1,35 @@ +# XXX rename these 'addstarRun', etc... (add_id -> addstar_id) +addRun METADATA + add_id S64 0 # Primary Key AUTO_INCREMENT + stage STR 64 # what the stage is (warp, cam, diff, + stage_id S64 0 # Key INDEX(add_id,cam_id) fkey(cam_id) ref camRun(cam_id) + stage_extra1 S32 0 + state STR 64 # Key + workdir STR 255 + workdir_state STR 64 + reduction STR 64 + label STR 64 + data_group STR 64 # Key + dvodb STR 255 + note STR 255 + image_only BOOL f + minidvodb BOOL f + minidvodb_group STR 64 + minidvodb_name STR 64 + minidvodb_host STR 64 +END + +addProcessedExp METADATA + add_id S64 0 # Primary Key AUTO_INCREMENT + dtime_addstar F32 0.0 + path_base STR 255 + dvodb_path STR 255 + fault S16 0 # Key NOT NULL +END + +addMask METADATA + label STR 64 # Primary Key +END + + + Index: /branches/eam_branches/ipp-20230313/dbconfig/xcff.md =================================================================== --- /branches/eam_branches/ipp-20230313/dbconfig/xcff.md (revision 42569) +++ /branches/eam_branches/ipp-20230313/dbconfig/xcff.md (revision 42569) @@ -0,0 +1,49 @@ + +# there can be xcForceRun entries for the same xcstackRun in multiple cameras +# xcForceRun should be defined in camera database which owns the warps +# the xcForceRun connects the xcstackRun in the camera database for +# where the xcstackRun took place to the stackRun used to generate +# that stack in this camera database + +xcForceRun METADATA + xcff_id S64 0 + cal_id S64 0 # join to xccalRun + sources_path_base STR 255 # path to cmf file generated by xccal + state STR 64 + workdir STR 255 + label STR 64 + data_group STR 64 + dist_group STR 64 + note STR 255 + reduction STR 64 + registered TAI NULL +END + +# join to xcstackInputSkyfile to get the camera_id, stack_id for this xcstack +xcForceInput METADATA + xcff_id S64 0 + warp_id S64 0 + camera_id S64 0 # ID of camera database used for the xcstackRun +END + +xcForceResult METADATA + xcff_id S64 0 + warp_id S64 0 + path_base STR 255 + dtime_script F32 0.0 + quality S16 0 + hostname STR 64 + software_ver STR 16 + fault S16 0 +END + +xcForceSummary METADATA + ff_id S64 0 + path_base STR 255 + dtime_script F32 0.0 + quality S16 0 + hostname STR 64 + software_ver STR 16 + fault S16 0 +END + Index: /branches/eam_branches/ipp-20230313/dbconfig/xcsky.md =================================================================== --- /branches/eam_branches/ipp-20230313/dbconfig/xcsky.md (revision 42569) +++ /branches/eam_branches/ipp-20230313/dbconfig/xcsky.md (revision 42569) @@ -0,0 +1,67 @@ +# Tables for static sky analysis +# XXX add tess_id and skycell_id here? + +xcskyRun METADATA + sky_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 + +xcskyInput METADATA + sky_id S64 0 # Primary Key fkey(sky_id) ref xcskyRun(sky_id) + xcstack_id S64 0 # Primary Key fkey(xcstack_id) ref stackSumSkyfile(xcstack_id) +END + +xcskyResult METADATA + sky_id S64 0 # Primary Key fkey(sky_id) ref xcskyRun(sky_id) + path_base STR 255 + dtime_phot F32 0.0 + dtime_script F32 0.0 + sources S32 0 + num_inputs S32 0 + hostname STR 64 + good_frac F32 0.0 # Key + fault S16 0 # Key + quality S16 0 # Key +END + +xccalRun METADATA + cal_id S64 0 # Primary Key AUTO_INCREMENT + sky_id S64 0 # fkey(sky_id) ref xcskyRun(sky_id) + xcstack_id S64 0 # fkey(xcstack_id) ref xcstackRun(xcstack_id) + 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 + +xccalResult METADATA + cal_id S64 0 # Primary Key fkey(cal_id) ref xccalRun(cal_id) + path_base STR 255 + dtime_script F32 0.0 + dtime_astrom F32 0.0 + sigma_ra F32 0.0 + sigma_dec F32 0.0 + n_astrom S32 0 + n_detections S32 0 + n_extended S32 0 + n_forced S32 0 + zpt_obs F32 0.0 + zpt_stdev F32 0.0 + fwhm_major F32 0.0 + fwhm_minor F32 0.0 + quality S16 0 # Key + software_ver STR 16 + hostname STR 64 + fault S16 0 # Key +END