Changeset 12129
- Timestamp:
- Feb 28, 2007, 6:43:18 PM (19 years ago)
- Location:
- trunk/dbconfig
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/config.md
r12060 r12129 2 2 pkg_name STR ippdb 3 3 pkg_namespace STR ippdb 4 pkg_version STR 1.1.1 34 pkg_version STR 1.1.14 5 5 END -
trunk/dbconfig/p4.md
r12032 r12129 1 # $Id: p4.md,v 1.1 8 2007-02-24 02:46:19jhoblitt Exp $1 # $Id: p4.md,v 1.19 2007-03-01 04:43:18 jhoblitt Exp $ 2 2 3 3 # … … 10 10 # define a new warprun for a single skycell 11 11 warpRun METADATA 12 warp_id S 320 # Primary Key AUTO_INCREMENT12 warp_id S64 0 # Primary Key AUTO_INCREMENT 13 13 mode STR 64 # Key 14 14 state STR 64 # Key … … 25 25 # only allow one cam_version of an exp_tag per warpRun 26 26 warpInputExp METADATA 27 warp_id S32 0 # Primary Key 28 exp_tag STR 64 # Primary Key 29 cam_version S32 0 # Key 27 warp_id S64 0 # Primary Key 28 cam_id S64 0 # Primary Key 30 29 # if magic is T then look for the exp_tag in the magic output tables 31 30 magiced BOOL f # Key … … 33 32 34 33 warpSkyCellMap METADATA 35 warp_id S 320 # Primary Key34 warp_id S64 0 # Primary Key 36 35 skycell_id STR 64 # Primary Key 37 36 tess_id STR 64 # Primary Key 38 exp_tag STR 64 # Primary Key 39 cam_version S32 0 # Primary Key 37 cam_id S64 0 # Primary Key 40 38 # class is not yet consistently carried through pXtools 41 39 # class STR 64 # Primary Key … … 45 43 46 44 warpSkyfile METADATA 47 warp_id S 320 # Primary Key45 warp_id S64 0 # Primary Key 48 46 skycell_id STR 64 # Primary Key 49 47 tess_id STR 64 # Primary Key -
trunk/dbconfig/p5.md
r12028 r12129 1 # $Id: p5.md,v 1. 8 2007-02-24 02:29:51jhoblitt Exp $1 # $Id: p5.md,v 1.9 2007-03-01 04:43:18 jhoblitt Exp $ 2 2 3 3 diffRun METADATA 4 diff_id S 320 # Primary Key AUTO_INCREMENT4 diff_id S64 0 # Primary Key AUTO_INCREMENT 5 5 state STR 64 # Key 6 6 workdir STR 255 … … 17 17 # only ever 2 per run 18 18 diffInputSkyfile METADATA 19 diff_id S 320 # Primary Key20 warp_id S 320 # Primary Key19 diff_id S64 0 # Primary Key 20 warp_id S64 0 # Primary Key 21 21 skycell_id STR 64 # Primary Key 22 22 tess_id STR 64 # Primary Key … … 27 27 28 28 diffSkyfile METADATA 29 diff_id S 320 # Primary Key29 diff_id S64 0 # Primary Key 30 30 uri STR 255 31 31 bg F64 0.0 -
trunk/dbconfig/p6.md
r12028 r12129 1 # $Id: p6.md,v 1. 8 2007-02-24 02:29:51jhoblitt Exp $1 # $Id: p6.md,v 1.9 2007-03-01 04:43:18 jhoblitt Exp $ 2 2 3 3 stackRun METADATA 4 stack_id S 320 # Primary Key AUTO_INCREMENT4 stack_id S64 0 # Primary Key AUTO_INCREMENT 5 5 state STR 64 # Key 6 6 workdir STR 255 … … 12 12 13 13 stackInputSkyfile METADATA 14 stack_id S 320 # Primary Key15 warp_id S 320 # Primary Key14 stack_id S64 0 # Primary Key 15 warp_id S64 0 # Primary Key 16 16 END 17 17 18 18 stackSumSkyfile METADATA 19 stack_id S 320 # Primary Key19 stack_id S64 0 # Primary Key 20 20 uri STR 255 21 21 bg F64 0.0 22 bg_stdev F640.022 bg_stdev F64 0.0 23 23 END -
trunk/dbconfig/tasks.md
r12117 r12129 1 # $Id: tasks.md,v 1.12 2 2007-02-28 21:48:12jhoblitt Exp $1 # $Id: tasks.md,v 1.123 2007-03-01 04:43:18 jhoblitt Exp $ 2 2 3 3 # this table records all exposure ID ever seen from the summit … … 155 155 156 156 guidePendingExp METADATA 157 exp_tag STR 64 # Primary Key158 guide_version S32 0 # Primary Key157 guide_id S64 0 # Primary Key AUTO_INCREMENT 158 exp_tag STR 64 # Key 159 159 recipe STR 64 160 160 END … … 164 164 165 165 chipPendingExp METADATA 166 exp_tag STR 64 # Primary Key167 chip_version S32 0# Primary Key168 guide_ version S32 0166 chip_id S64 0 # Primary Key AUTO_INCREMENT 167 exp_tag STR 64 # Primary Key 168 guide_id S64 0 # Not NULL 169 169 label STR 64 # key 170 170 recipe STR 64 … … 176 176 177 177 chipPendingImfile METADATA 178 exp_tag STR 64# Primary Key179 chip_version S32 0# Primary Key180 guide_ version S32 0178 chip_id S64 0 # Primary Key 179 exp_tag STR 64 # Primary Key 180 guide_id S64 0 # Not NULL 181 181 class_id STR 64 # Primary Key 182 182 recipe STR 64 … … 188 188 189 189 chipProcessedExp METADATA 190 exp_tag STR 64 # Primary Key 191 chip_version S32 0 # Primary Key 192 guide_version S32 0 193 label STR 64 # key 194 expgroup STR 64 # key 195 dvodb STR 255 196 END 197 198 chipMask METADATA 199 label STR 64 # Primary Key 200 END 201 202 # uris in & out ? 203 # state? 204 205 chipProcessedImfile METADATA 206 exp_tag STR 64 # Primary Key 207 chip_version S32 0 # Primary Key 208 guide_version S32 0 209 class_id STR 64 # Primary Key 210 recipe STR 64 211 uri STR 255 212 bg F64 0.0 213 bg_stdev F64 0.0 214 bg_mean_stdev F64 0.0 215 path_base STR 255 216 fault S16 0 # Key NOT NULL 217 END 218 219 # imfiles is not here... is it needed? 220 221 camPendingExp METADATA 222 exp_tag STR 64 # Primary Key 223 cam_version S32 0 # Primary Key 224 chip_version S32 0 190 chip_id S64 0 # Primary Key 191 exp_tag STR 64 # Primary Key 192 guide_id S64 0 # Not NULL 225 193 label STR 64 # key 226 194 expgroup STR 64 # key … … 228 196 END 229 197 198 chipMask METADATA 199 label STR 64 # Primary Key 200 END 201 202 # uris in & out ? 203 # state? 204 205 chipProcessedImfile METADATA 206 chip_id S64 0 # Primary Key 207 # exp_tag/guide_id are redudant with the values stored in chipProcessedExp. 208 # exp_tag can be removed at virtually any time (SQL queriers will need to be 209 # fixed) but guide_id needs to wait until we know if this can be tracked at 210 # just the exp level. 211 exp_tag STR 64 # Primary Key 212 guide_id S64 0 # Not NULL 213 class_id STR 64 # Primary Key 214 recipe STR 64 215 uri STR 255 216 bg F64 0.0 217 bg_stdev F64 0.0 218 bg_mean_stdev F64 0.0 219 path_base STR 255 220 fault S16 0 # Key NOT NULL 221 END 222 223 # imfiles is not here... is it needed? 224 225 camPendingExp METADATA 226 cam_id S64 0 # Primary Key AUTO_INCREMENT 227 chip_id S64 0 # Primary Key 228 label STR 64 # key 229 expgroup STR 64 # key 230 dvodb STR 255 231 END 232 230 233 camProcessedExp METADATA 231 exp_tag STR 64 # Primary Key 232 cam_version S32 0 # Primary Key 233 chip_version S32 0 234 cam_id S64 0 # Primary Key 235 chip_id S64 0 # Primary Key 234 236 label STR 64 # key 235 237 uri STR 255 … … 254 256 255 257 detRun METADATA 256 det_id S 320 # Primary Key AUTO_INCREMENT258 det_id S64 0 # Primary Key AUTO_INCREMENT 257 259 iteration S32 0 # Key 258 260 det_type STR 64 # Key … … 284 286 285 287 detInputExp METADATA 286 det_id S 320 # Primary Key288 det_id S64 0 # Primary Key 287 289 iteration S32 0 # Primary Key 288 290 exp_tag STR 64 # Primary Key … … 291 293 292 294 detProcessedImfile METADATA 293 det_id S 320 # Primary Key295 det_id S64 0 # Primary Key 294 296 exp_tag STR 64 # Primary Key 295 297 class_id STR 64 # Primary Key … … 304 306 305 307 detProcessedExp METADATA 306 det_id S 320 # Primary Key308 det_id S64 0 # Primary Key 307 309 exp_tag STR 64 # Primary Key 308 310 recipe STR 64 … … 315 317 316 318 detStackedImfile METADATA 317 det_id S 320 # Primary Key319 det_id S64 0 # Primary Key 318 320 iteration S32 0 # Primary Key 319 321 class_id STR 64 # Primary Key … … 327 329 328 330 detNormalizedStatImfile METADATA 329 det_id S 320 # Primary Key331 det_id S64 0 # Primary Key 330 332 iteration S32 0 # Primary Key 331 333 class_id STR 64 # Primary Key … … 335 337 336 338 detNormalizedImfile METADATA 337 det_id S 320 # Primary Key339 det_id S64 0 # Primary Key 338 340 iteration S32 0 # Primary Key 339 341 class_id STR 64 # Primary Key … … 347 349 348 350 detNormalizedExp METADATA 349 det_id S 320 # Primary Key351 det_id S64 0 # Primary Key 350 352 iteration S32 0 # Primary Key 351 353 recipe STR 64 … … 358 360 359 361 #detMasterFrame METADATA 360 # det_id S 320 # Primary Key362 # det_id S64 0 # Primary Key 361 363 # iteration S32 0 # Primary Key 362 364 # comment STR 255 … … 365 367 ## drop? 366 368 #detMasterImfile METADATA 367 # det_id S 320 # Primary Key369 # det_id S64 0 # Primary Key 368 370 # class_id STR 64 # Primary Key 369 371 # uri STR 255 … … 372 374 373 375 detResidImfile METADATA 374 det_id S 320 # Primary Key376 det_id S64 0 # Primary Key 375 377 iteration S32 0 # Primary Key 376 378 exp_tag STR 64 # Primary Key … … 386 388 387 389 detResidExp METADATA 388 det_id S 320 # Primary Key390 det_id S64 0 # Primary Key 389 391 iteration S32 0 # Primary Key 390 392 exp_tag STR 64 # Primary Key … … 399 401 400 402 detRunSummary METADATA 401 det_id S 320 # Primary Key403 det_id S64 0 # Primary Key 402 404 iteration S32 0 # Primary Key 403 405 bg F64 0.0
Note:
See TracChangeset
for help on using the changeset viewer.
