Changeset 14017
- Timestamp:
- Jul 5, 2007, 10:13:45 AM (19 years ago)
- Location:
- trunk/dbconfig
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/cam.md
r13937 r14017 1 # imfiles is not here... is it needed? 2 3 camPendingExp METADATA 1 camRun METADATA 4 2 cam_id S64 0 # Primary Key AUTO_INCREMENT 5 chip_id S64 0 # Primary Key fkey(chip_id) ref chipProcessedExp(chip_id) 3 chip_id S64 0 # Primary Key fkey(chip_id) ref chipRun(chip_id) 4 state STR 64 # key 6 5 workdir STR 255 6 workdir_state STR 64 # key 7 7 label STR 64 # key 8 8 reduction STR 64 … … 14 14 # the camPendingExp row gets deleted so we can not put a fkey on cam_id 15 15 cam_id S64 0 # Primary Key 16 chip_id S64 0 # Primary Key fkey(chip_id) ref chipProcessedExp(chip_id) 17 workdir STR 255 18 label STR 64 # key 19 reduction STR 64 20 expgroup STR 64 # key 21 dvodb STR 255 16 chip_id S64 0 # Primary Key fkey(cam_id, chip_id) ref camRun(cam_id, chip_id) 22 17 uri STR 255 23 18 bg F32 0.0 -
trunk/dbconfig/chip.md
r13937 r14017 1 # do we need nclass? 2 # class is missing 1 # 2 # We are dependant on the assumption that there is only ever one exp_tag in a 3 # chipRun although the database does not enforce this. 4 # 3 5 4 chip PendingExpMETADATA6 chipRun METADATA 5 7 chip_id S64 0 # Primary Key AUTO_INCREMENT 6 exp_tag STR 64 # Primary Key 7 guide_id S64 0 # Not NULL 8 state STR 64 # key 8 9 workdir STR 255 10 workdir_state STR 64 # key 9 11 label STR 64 # key 10 12 reduction STR 64 # Reduction class … … 13 15 END 14 16 15 # uris in & out ? 16 17 chipPendingImfile METADATA 18 chip_id S64 0 # Primary Key 17 chipInputImfile METADATA 18 chip_id S64 0 # Primary Key fkey (chip_id) ref chipRun(chip_id) 19 exp_tag STR 64 # Primary Key fkey (exp_tag, class_id) ref rawImfile (exp_tag, class_id) 19 20 class_id STR 64 # Primary Key 20 uri STR 25521 21 END 22 22 23 # nclass & ndone? 24 # and/or logging imfile done better? 25 26 chipProcessedExp METADATA 27 chip_id S64 0 # Primary Key 23 chipProcessedImfile METADATA 24 chip_id S64 0 # Primary Key fkey (chip_id, exp_tag, class_id) ref chipPendingImfile(chip_id, exp_tag, class_id) 28 25 exp_tag STR 64 # Primary Key 29 guide_id S64 0 # Not NULL30 workdir STR 25531 label STR 64 # key32 reduction STR 6433 expgroup STR 64 # key34 dvodb STR 25535 END36 37 chipMask METADATA38 label STR 64 # Primary Key39 END40 41 # uris in & out ?42 # state?43 44 chipProcessedImfile METADATA45 chip_id S64 0 # Primary Key46 # exp_tag/guide_id are redudant with the values stored in chipProcessedExp.47 # exp_tag can be removed at virtually any time (SQL queriers will need to be48 # fixed) but guide_id needs to wait until we know if this can be tracked at49 # just the exp level.50 26 class_id STR 64 # Primary Key 51 27 uri STR 255 … … 71 47 fault S16 0 # Key NOT NULL 72 48 END 49 50 chipMask METADATA 51 label STR 64 # Primary Key 52 END -
trunk/dbconfig/tasks.md
r13617 r14017 1 # $Id: tasks.md,v 1.13 4 2007-06-05 00:24:52 eugeneExp $1 # $Id: tasks.md,v 1.135 2007-07-05 20:13:45 jhoblitt Exp $ 2 2 3 3 # this table records all exposure ID ever seen from the summit … … 85 85 exp_tag STR 64 # Primary Key 86 86 exp_id STR 64 # Key 87 state STR 64 # Key 87 88 camera STR 64 # Key 88 89 telescope STR 64 # Key 89 90 imfiles S32 0 90 91 workdir STR 255 # destination for output files 92 workdir_state STR 64 # key 91 93 END 92 94 … … 94 96 # from there 95 97 newImfile METADATA 96 exp_tag STR 64 # Primary Key 97 class STR 64 # Primary Key 98 exp_tag STR 64 # Primary Key fkey(exp_tag) ref newExp(exp_tag) 98 99 class_id STR 64 # Primary Key 99 100 uri STR 255 … … 102 103 # paired with rawImfile 103 104 rawExp METADATA 104 exp_tag STR 64 # Primary Key 105 exp_tag STR 64 # Primary Key fkey(exp_tag) ref newExp(exp_tag) 105 106 exp_id STR 64 # Key 106 107 camera STR 64 … … 135 136 136 137 rawImfile METADATA 137 exp_tag STR 64 # Primary Key 138 exp_tag STR 64 # Primary Key fkey(exp_tag, class_id) ref newImfile(exp_tag, class_id) 138 139 class_id STR 64 # Primary Key 139 140 uri STR 255
Note:
See TracChangeset
for help on using the changeset viewer.
