Index: trunk/dbconfig/tasks.md =================================================================== --- trunk/dbconfig/tasks.md (revision 12425) +++ trunk/dbconfig/tasks.md (revision 12531) @@ -1,3 +1,3 @@ -# $Id: tasks.md,v 1.131 2007-03-13 03:52:45 jhoblitt Exp $ +# $Id: tasks.md,v 1.132 2007-03-22 01:10:12 jhoblitt Exp $ # this table records all exposure ID ever seen from the summit @@ -157,259 +157,2 @@ # XXX - temporarily (???) stot carrying around class in imfiles after rawImfile # - -guidePendingExp METADATA - guide_id S64 0 # Primary Key AUTO_INCREMENT - exp_tag STR 64 # Key - recipe STR 64 -END - -# do we need nclass? -# class is missing - -chipPendingExp METADATA - chip_id S64 0 # Primary Key AUTO_INCREMENT - exp_tag STR 64 # Primary Key - guide_id S64 0 # Not NULL - workdir STR 255 - label STR 64 # key - recipe STR 64 - expgroup STR 64 # key - dvodb STR 255 -END - -# uris in & out ? - -chipPendingImfile METADATA - chip_id S64 0 # Primary Key - class_id STR 64 # Primary Key - uri STR 255 -END - -# nclass & ndone? -# and/or logging imfile done better? - -chipProcessedExp METADATA - chip_id S64 0 # Primary Key - exp_tag STR 64 # Primary Key - guide_id S64 0 # Not NULL - workdir STR 255 - label STR 64 # key - recipe STR 64 - expgroup STR 64 # key - dvodb STR 255 -END - -chipMask METADATA - label STR 64 # Primary Key -END - -# uris in & out ? -# state? - -chipProcessedImfile METADATA - chip_id S64 0 # Primary Key -# exp_tag/guide_id are redudant with the values stored in chipProcessedExp. -# exp_tag can be removed at virtually any time (SQL queriers will need to be -# fixed) but guide_id needs to wait until we know if this can be tracked at -# just the exp level. - class_id STR 64 # Primary Key - uri STR 255 - bg F64 0.0 - bg_stdev F64 0.0 - bg_mean_stdev F64 0.0 - path_base STR 255 - fault S16 0 # Key NOT NULL -END - -# imfiles is not here... is it needed? - -camPendingExp METADATA - cam_id S64 0 # Primary Key AUTO_INCREMENT - chip_id S64 0 # Primary Key - workdir STR 255 - label STR 64 # key - recipe STR 64 - expgroup STR 64 # key - dvodb STR 255 -END - -camProcessedExp METADATA - cam_id S64 0 # Primary Key - chip_id S64 0 # Primary Key - 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 - -detRun METADATA - det_id S64 0 # Primary Key AUTO_INCREMENT - iteration S32 0 # Key - det_type STR 64 # Key - mode STR 64 # Key - state STR 64 # Key - filelevel STR 64 - workdir STR 255 # destination for output files - camera STR 64 - telescope STR 64 - exp_type STR 64 # XXX this should be dropped - filter STR 64 - airmass_min F32 0.0 - airmass_max F32 0.0 - exp_time_min F32 0.0 - exp_time_max F32 0.0 - ccd_temp_min F32 0.0 - ccd_temp_max F32 0.0 - posang_min F64 0.0 - posang_max F64 0.0 - registered TAI 0001-01-01T00:00:00Z - time_begin TAI 0001-01-01T00:00:00Z - time_end TAI 0001-01-01T00:00:00Z - use_begin TAI 0001-01-01T00:00:00Z - use_end TAI 0001-01-01T00:00:00Z - solang_min F32 0.0 - solang_max F32 0.0 - label STR 64 # key - parent S32 0 # Key -END - -detInputExp METADATA - det_id S64 0 # Primary Key - iteration S32 0 # Primary Key - exp_tag STR 64 # Primary Key - include BOOL f -END - -detProcessedImfile METADATA - det_id S64 0 # Primary Key - exp_tag STR 64 # Primary Key - class_id STR 64 # Primary Key - uri STR 255 - recipe STR 64 - bg F64 0.0 - bg_stdev F64 0.0 - bg_mean_stdev F64 0.0 - path_base STR 255 - fault S16 0 # Key NOT NULL -END - -detProcessedExp METADATA - det_id S64 0 # Primary Key - exp_tag STR 64 # Primary Key - recipe STR 64 - bg F64 0.0 - bg_stdev F64 0.0 - bg_mean_stdev F64 0.0 - path_base STR 255 - fault S16 0 # Key NOT NULL -END - -detStackedImfile METADATA - det_id S64 0 # Primary Key - iteration S32 0 # Primary Key - class_id STR 64 # Primary Key - uri STR 255 - recipe STR 64 - bg F64 0.0 - bg_stdev F64 0.0 - bg_mean_stdev F64 0.0 - fault S16 0 # Key NOT NULL -END - -detNormalizedStatImfile METADATA - det_id S64 0 # Primary Key - iteration S32 0 # Primary Key - class_id STR 64 # Primary Key - norm F32 0.0 - fault S16 0 # Key NOT NULL -END - -detNormalizedImfile METADATA - det_id S64 0 # Primary Key - iteration S32 0 # Primary Key - class_id STR 64 # Primary Key - uri STR 255 - bg F64 0.0 - bg_stdev F64 0.0 - bg_mean_stdev F64 0.0 - path_base STR 255 - fault S16 0 # Key NOT NULL -END - -detNormalizedExp METADATA - det_id S64 0 # Primary Key - iteration S32 0 # Primary Key - recipe STR 64 - bg F64 0.0 - bg_stdev F64 0.0 - bg_mean_stdev F64 0.0 - path_base STR 255 - fault S16 0 # Key NOT NULL -END - -#detMasterFrame METADATA -# det_id S64 0 # Primary Key -# iteration S32 0 # Primary Key -# comment STR 255 -#END -# -## drop? -#detMasterImfile METADATA -# det_id S64 0 # Primary Key -# class_id STR 64 # Primary Key -# uri STR 255 -# recipe STR 64 -#END - -detResidImfile METADATA - det_id S64 0 # Primary Key - iteration S32 0 # Primary Key - exp_tag STR 64 # Primary Key - class_id STR 64 # Primary Key - uri STR 255 - recipe STR 64 - bg F64 0.0 - bg_stdev F64 0.0 - bg_mean_stdev F64 0.0 - path_base STR 255 - fault S16 0 # Key NOT NULL -END - -detResidExp METADATA - det_id S64 0 # Primary Key - iteration S32 0 # Primary Key - exp_tag STR 64 # Primary Key - recipe STR 64 - bg F64 0.0 - bg_stdev F64 0.0 - bg_mean_stdev F64 0.0 - path_base STR 255 - accept BOOL f - fault S16 0 # Key NOT NULL -END - -detRunSummary METADATA - det_id S64 0 # Primary Key - iteration S32 0 # Primary Key - bg F64 0.0 - bg_stdev F64 0.0 - bg_mean_stdev F64 0.0 - accept BOOL f - fault S16 0 # Key NOT NULL -END