Changeset 12129 for trunk/dbconfig/tasks.md
- Timestamp:
- Feb 28, 2007, 6:43:18 PM (19 years ago)
- File:
-
- 1 edited
-
trunk/dbconfig/tasks.md (modified) (19 diffs)
Legend:
- Unmodified
- Added
- Removed
-
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.
