Index: /branches/haf_branches/videophot2010/dbconfig/ipp.m4 =================================================================== --- /branches/haf_branches/videophot2010/dbconfig/ipp.m4 (revision 29945) +++ /branches/haf_branches/videophot2010/dbconfig/ipp.m4 (revision 29946) @@ -35,2 +35,3 @@ include(background.md) include(diffphot.md) +include(videophot.md) Index: /branches/haf_branches/videophot2010/dbconfig/videophot.md =================================================================== --- /branches/haf_branches/videophot2010/dbconfig/videophot.md (revision 29946) +++ /branches/haf_branches/videophot2010/dbconfig/videophot.md (revision 29946) @@ -0,0 +1,95 @@ +videophotRun METADATA + videophot_id S64 0 # Primary Key AUTO_INCREMENT + exp_id S64 64 # Key INDEX(videophot_id, exp_id) fkey (exp_id) ref rawExp(exp_id) + state STR 64 # Key + workdir STR 255 + workdir_state STR 64 # Key + label STR 64 # Key + data_group STR 64 # Key + dist_group STR 64 # Key + reduction STR 64 # Reduction class + expgroup STR 64 # Key + dvodb STR 255 + tess_id STR 64 + end_stage STR 64 # Key + magicked S64 0 + software_ver STR 16 + note STR 255 +END + +videophotImfile METADATA + videophot_id S64 0 # Primary Key fkey (videophot_id) ref videophotRun (videophot_id) + class_id STR 64 # Primary Key + videophot_imfile_id S64 0 # Key AUTO_INCREMENT +END + +videophotProcessedImfile METADATA + videophot_id S64 0 # Primary Key fkey (videophot_id, exp_id) ref videophotRun(videophot_id, exp_id) + exp_id S64 64 # Primary Key fkey (exp_id, class_id) ref rawImfile(exp_id, class_id) + class_id STR 64 # Primary Key + data_state STR 64 # Key + uri STR 255 + bg F32 0.0 + bg_stdev F32 0.0 + bg_mean_stdev F32 0.0 + bias F32 0.0 + bias_stdev F32 0.0 + ap_resid F32 0.0 + ap_resid_stdev F32 0.0 + + fwhm_major F32 0.0 + fwhm_major_lq F32 0.0 + fwhm_major_uq F32 0.0 + + fwhm_minor F32 0.0 + fwhm_minor_lq F32 0.0 + fwhm_minor_uq F32 0.0 + + iq_fwhm_major F32 0.0 + iq_fwhm_major_err F32 0.0 + iq_fwhm_minor F32 0.0 + iq_fwhm_minor_err F32 0.0 + + iq_m2 F32 0.0 + iq_m2_err F32 0.0 + iq_m2_lq F32 0.0 + iq_m2_uq F32 0.0 + + iq_m2c F32 0.0 + iq_m2c_err F32 0.0 + iq_m2c_lq F32 0.0 + iq_m2c_uq F32 0.0 + + iq_m2s F32 0.0 + iq_m2s_err F32 0.0 + iq_m2s_lq F32 0.0 + iq_m2s_uq F32 0.0 + + iq_m3 F32 0.0 + iq_m3_err F32 0.0 + iq_m3_lq F32 0.0 + iq_m3_uq F32 0.0 + + iq_m4 F32 0.0 + iq_m4_err F32 0.0 + iq_m4_lq F32 0.0 + iq_m4_uq F32 0.0 + + dtime_detrend F32 0.0 + dtime_photom F32 0.0 + dtime_total F32 0.0 + dtime_script F32 0.0 + + hostname STR 64 + n_stars S32 0 + n_psfstars S32 0 + n_iqstars S32 0 + n_extended S32 0 + n_cr S32 0 + path_base STR 255 + fault S16 0 # Key NOT NULL + quality S16 0 + magicked S64 0 + software_ver STR 16 +END +