Changeset 12531 for trunk/dbconfig
- Timestamp:
- Mar 21, 2007, 3:10:12 PM (19 years ago)
- Location:
- trunk/dbconfig
- Files:
-
- 7 added
- 3 deleted
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/ipp.m4
r11815 r12531 9 9 dnl include(telescope.md) 10 10 include(tasks.md) 11 include(p4.md) 12 include(p5.md) 13 include(p6.md) 11 include(guide.md) 12 include(chip.md) 13 include(cam.md) 14 include(warp.md) 15 include(diff.md) 16 include(stack.md) 17 include(det.md) 14 18 dnl include(skycell.md) -
trunk/dbconfig/tasks.md
r12425 r12531 1 # $Id: tasks.md,v 1.13 1 2007-03-13 03:52:45jhoblitt Exp $1 # $Id: tasks.md,v 1.132 2007-03-22 01:10:12 jhoblitt Exp $ 2 2 3 3 # this table records all exposure ID ever seen from the summit … … 157 157 # XXX - temporarily (???) stot carrying around class in imfiles after rawImfile 158 158 # 159 160 guidePendingExp METADATA161 guide_id S64 0 # Primary Key AUTO_INCREMENT162 exp_tag STR 64 # Key163 recipe STR 64164 END165 166 # do we need nclass?167 # class is missing168 169 chipPendingExp METADATA170 chip_id S64 0 # Primary Key AUTO_INCREMENT171 exp_tag STR 64 # Primary Key172 guide_id S64 0 # Not NULL173 workdir STR 255174 label STR 64 # key175 recipe STR 64176 expgroup STR 64 # key177 dvodb STR 255178 END179 180 # uris in & out ?181 182 chipPendingImfile METADATA183 chip_id S64 0 # Primary Key184 class_id STR 64 # Primary Key185 uri STR 255186 END187 188 # nclass & ndone?189 # and/or logging imfile done better?190 191 chipProcessedExp METADATA192 chip_id S64 0 # Primary Key193 exp_tag STR 64 # Primary Key194 guide_id S64 0 # Not NULL195 workdir STR 255196 label STR 64 # key197 recipe STR 64198 expgroup STR 64 # key199 dvodb STR 255200 END201 202 chipMask METADATA203 label STR 64 # Primary Key204 END205 206 # uris in & out ?207 # state?208 209 chipProcessedImfile METADATA210 chip_id S64 0 # Primary Key211 # exp_tag/guide_id are redudant with the values stored in chipProcessedExp.212 # exp_tag can be removed at virtually any time (SQL queriers will need to be213 # fixed) but guide_id needs to wait until we know if this can be tracked at214 # just the exp level.215 class_id STR 64 # Primary Key216 uri STR 255217 bg F64 0.0218 bg_stdev F64 0.0219 bg_mean_stdev F64 0.0220 path_base STR 255221 fault S16 0 # Key NOT NULL222 END223 224 # imfiles is not here... is it needed?225 226 camPendingExp METADATA227 cam_id S64 0 # Primary Key AUTO_INCREMENT228 chip_id S64 0 # Primary Key229 workdir STR 255230 label STR 64 # key231 recipe STR 64232 expgroup STR 64 # key233 dvodb STR 255234 END235 236 camProcessedExp METADATA237 cam_id S64 0 # Primary Key238 chip_id S64 0 # Primary Key239 workdir STR 255240 label STR 64 # key241 recipe STR 64242 expgroup STR 64 # key243 dvodb STR 255244 uri STR 255245 bg F64 0.0246 bg_stdev F64 0.0247 bg_mean_stdev F64 0.0248 sigma_ra F32 0.0249 sigma_dec F32 0.0250 nastro S32 0251 path_base STR 255252 zp_mean F32 0.0253 zp_stdev F32 0.0254 fault S16 0 # Key NOT NULL255 END256 257 camMask METADATA258 label STR 64 # Primary Key259 END260 261 detRun METADATA262 det_id S64 0 # Primary Key AUTO_INCREMENT263 iteration S32 0 # Key264 det_type STR 64 # Key265 mode STR 64 # Key266 state STR 64 # Key267 filelevel STR 64268 workdir STR 255 # destination for output files269 camera STR 64270 telescope STR 64271 exp_type STR 64 # XXX this should be dropped272 filter STR 64273 airmass_min F32 0.0274 airmass_max F32 0.0275 exp_time_min F32 0.0276 exp_time_max F32 0.0277 ccd_temp_min F32 0.0278 ccd_temp_max F32 0.0279 posang_min F64 0.0280 posang_max F64 0.0281 registered TAI 0001-01-01T00:00:00Z282 time_begin TAI 0001-01-01T00:00:00Z283 time_end TAI 0001-01-01T00:00:00Z284 use_begin TAI 0001-01-01T00:00:00Z285 use_end TAI 0001-01-01T00:00:00Z286 solang_min F32 0.0287 solang_max F32 0.0288 label STR 64 # key289 parent S32 0 # Key290 END291 292 detInputExp METADATA293 det_id S64 0 # Primary Key294 iteration S32 0 # Primary Key295 exp_tag STR 64 # Primary Key296 include BOOL f297 END298 299 detProcessedImfile METADATA300 det_id S64 0 # Primary Key301 exp_tag STR 64 # Primary Key302 class_id STR 64 # Primary Key303 uri STR 255304 recipe STR 64305 bg F64 0.0306 bg_stdev F64 0.0307 bg_mean_stdev F64 0.0308 path_base STR 255309 fault S16 0 # Key NOT NULL310 END311 312 detProcessedExp METADATA313 det_id S64 0 # Primary Key314 exp_tag STR 64 # Primary Key315 recipe STR 64316 bg F64 0.0317 bg_stdev F64 0.0318 bg_mean_stdev F64 0.0319 path_base STR 255320 fault S16 0 # Key NOT NULL321 END322 323 detStackedImfile METADATA324 det_id S64 0 # Primary Key325 iteration S32 0 # Primary Key326 class_id STR 64 # Primary Key327 uri STR 255328 recipe STR 64329 bg F64 0.0330 bg_stdev F64 0.0331 bg_mean_stdev F64 0.0332 fault S16 0 # Key NOT NULL333 END334 335 detNormalizedStatImfile METADATA336 det_id S64 0 # Primary Key337 iteration S32 0 # Primary Key338 class_id STR 64 # Primary Key339 norm F32 0.0340 fault S16 0 # Key NOT NULL341 END342 343 detNormalizedImfile METADATA344 det_id S64 0 # Primary Key345 iteration S32 0 # Primary Key346 class_id STR 64 # Primary Key347 uri STR 255348 bg F64 0.0349 bg_stdev F64 0.0350 bg_mean_stdev F64 0.0351 path_base STR 255352 fault S16 0 # Key NOT NULL353 END354 355 detNormalizedExp METADATA356 det_id S64 0 # Primary Key357 iteration S32 0 # Primary Key358 recipe STR 64359 bg F64 0.0360 bg_stdev F64 0.0361 bg_mean_stdev F64 0.0362 path_base STR 255363 fault S16 0 # Key NOT NULL364 END365 366 #detMasterFrame METADATA367 # det_id S64 0 # Primary Key368 # iteration S32 0 # Primary Key369 # comment STR 255370 #END371 #372 ## drop?373 #detMasterImfile METADATA374 # det_id S64 0 # Primary Key375 # class_id STR 64 # Primary Key376 # uri STR 255377 # recipe STR 64378 #END379 380 detResidImfile METADATA381 det_id S64 0 # Primary Key382 iteration S32 0 # Primary Key383 exp_tag STR 64 # Primary Key384 class_id STR 64 # Primary Key385 uri STR 255386 recipe STR 64387 bg F64 0.0388 bg_stdev F64 0.0389 bg_mean_stdev F64 0.0390 path_base STR 255391 fault S16 0 # Key NOT NULL392 END393 394 detResidExp METADATA395 det_id S64 0 # Primary Key396 iteration S32 0 # Primary Key397 exp_tag STR 64 # Primary Key398 recipe STR 64399 bg F64 0.0400 bg_stdev F64 0.0401 bg_mean_stdev F64 0.0402 path_base STR 255403 accept BOOL f404 fault S16 0 # Key NOT NULL405 END406 407 detRunSummary METADATA408 det_id S64 0 # Primary Key409 iteration S32 0 # Primary Key410 bg F64 0.0411 bg_stdev F64 0.0412 bg_mean_stdev F64 0.0413 accept BOOL f414 fault S16 0 # Key NOT NULL415 END
Note:
See TracChangeset
for help on using the changeset viewer.
