Changeset 14023 for trunk/dbconfig
- Timestamp:
- Jul 5, 2007, 3:16:08 PM (19 years ago)
- Location:
- trunk/dbconfig
- Files:
-
- 7 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/chip.md
r14017 r14023 1 1 # 2 # We are dependant on the assumption that there is only ever one exp_ tagin a2 # We are dependant on the assumption that there is only ever one exp_id in a 3 3 # chipRun although the database does not enforce this. 4 4 # … … 17 17 chipInputImfile METADATA 18 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 exp_id S64 64 # Primary Key fkey (exp_id, class_id) ref rawImfile (exp_id, class_id) 20 20 class_id STR 64 # Primary Key 21 21 END 22 22 23 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)25 exp_ tag STR64 # Primary Key24 chip_id S64 0 # Primary Key fkey (chip_id, exp_id, class_id) ref chipInputImfile(chip_id, exp_id, class_id) 25 exp_id S64 64 # Primary Key 26 26 class_id STR 64 # Primary Key 27 27 uri STR 255 -
trunk/dbconfig/det.md
r13937 r14023 34 34 det_id S64 0 # Primary Key 35 35 iteration S32 0 # Primary Key 36 exp_ tag STR64 # Primary Key36 exp_id S64 64 # Primary Key 37 37 include BOOL f 38 38 END … … 40 40 detProcessedImfile METADATA 41 41 det_id S64 0 # Primary Key 42 exp_ tag STR64 # Primary Key42 exp_id S64 64 # Primary Key 43 43 class_id STR 64 # Primary Key 44 44 uri STR 255 … … 61 61 detProcessedExp METADATA 62 62 det_id S64 0 # Primary Key 63 exp_ tag STR64 # Primary Key63 exp_id S64 64 # Primary Key 64 64 recipe STR 64 65 65 bg F64 0.0 … … 153 153 det_id S64 0 # Primary Key 154 154 iteration S32 0 # Primary Key 155 exp_ tag STR64 # Primary Key155 exp_id S64 64 # Primary Key 156 156 class_id STR 64 # Primary Key 157 157 uri STR 255 … … 176 176 det_id S64 0 # Primary Key 177 177 iteration S32 0 # Primary Key 178 exp_ tag STR64 # Primary Key178 exp_id S64 64 # Primary Key 179 179 recipe STR 64 180 180 bg F64 0.0 -
trunk/dbconfig/guide.md
r12531 r14023 1 1 guidePendingExp METADATA 2 2 guide_id S64 0 # Primary Key AUTO_INCREMENT 3 exp_ tag STR64 # Key3 exp_id S64 64 # Key 4 4 recipe STR 64 5 5 END -
trunk/dbconfig/magic.md
r11813 r14023 1 # $Id: magic.md,v 1. 1 2007-02-15 02:12:42jhoblitt Exp $1 # $Id: magic.md,v 1.2 2007-07-06 01:16:08 jhoblitt Exp $ 2 2 3 3 # … … 10 10 p4MagicMaskImfile METADATA 11 11 p4_id S32 0 # Primary Key 12 exp_ tag STR64 # Primary Key12 exp_id S64 64 # Primary Key 13 13 p3_version S32 0 # Primary Key 14 14 # class is not yet consistently carried through pXtools … … 21 21 # p4MagicMaskImfile METADATA 22 22 # p4_id S32 0 # Primary Key 23 # exp_ tag STR64 # Primary Key23 # exp_id S64 64 # Primary Key 24 24 # p3_version S32 0 # Primary Key 25 25 # # class is not yet consistently carried through pXtools … … 34 34 # skycell_id STR 64 # Primary Key 35 35 # tess_id STR 64 # Primary Key 36 # exp_ tag STR64 # Primary Key36 # exp_id S64 64 # Primary Key 37 37 # p3_version S32 0 # Primary Key 38 38 # # class is not yet consistently carried through pXtools … … 50 50 # skycell_id STR 64 # Primary Key 51 51 # tess_id STR 64 # Primary Key 52 # exp_ tag STR64 # Primary Key52 # exp_id S64 64 # Primary Key 53 53 # p3_version S32 0 # Primary Key 54 54 # # class is not yet consistently carried through pXtools … … 64 64 # skycell_id STR 64 # Primary Key 65 65 # tess_id STR 64 # Primary Key 66 # exp_ tag STR64 # Primary Key66 # exp_id S64 64 # Primary Key 67 67 # p3_version S32 0 # Primary Key 68 68 # # class is not yet consistently carried through pXtools … … 77 77 # p4MagicMaskImfile METADATA 78 78 # p4_id S32 0 # Primary Key 79 # exp_ tag STR64 # Primary Key79 # exp_id S64 64 # Primary Key 80 80 # p3_version S32 0 # Primary Key 81 81 # # class is not yet consistently carried through pXtools -
trunk/dbconfig/skycell.md
r11779 r14023 1 # $Id: skycell.md,v 1. 3 2007-02-13 22:33:30jhoblitt Exp $1 # $Id: skycell.md,v 1.4 2007-07-06 01:16:08 jhoblitt Exp $ 2 2 3 3 skyCell METADATA … … 17 17 skycell_id STR 64 # Primary Key 18 18 tess_id STR 64 # Primary Key 19 exp_ tag STR64 # Primary Key19 exp_id S64 64 # Primary Key 20 20 p3_version S32 0 # Primary Key 21 21 # class is not yet consistently carried through pXtools -
trunk/dbconfig/tasks.md
r14017 r14023 1 # $Id: tasks.md,v 1.13 5 2007-07-05 20:13:45jhoblitt Exp $1 # $Id: tasks.md,v 1.136 2007-07-06 01:16:08 jhoblitt Exp $ 2 2 3 3 # this table records all exposure ID ever seen from the summit 4 # exp_ id== fileset4 # exp_name == fileset 5 5 6 6 # note that dec is a MySQL reserved word … … 8 8 # note that exp is a MySQL reserved word 9 9 10 # for use with this stored procedure to generate exp_ tags under Mysql 5+10 # for use with this stored procedure to generate exp_ids under Mysql 5+ 11 11 # 12 #CREATE FUNCTION genTag (exp_ idvarchar(64)) RETURNS VARCHAR(64)12 #CREATE FUNCTION genTag (exp_name varchar(64)) RETURNS VARCHAR(64) 13 13 #BEGIN 14 14 # UPDATE expTagCounter SET counter = LAST_INSERT_ID(counter + 1); 15 # RETURN CONCAT(exp_ id, '.', LAST_INSERT_ID());15 # RETURN CONCAT(exp_name, '.', LAST_INSERT_ID()); 16 16 #END 17 17 # 18 expTagCounter METADATA19 counter U64 020 END18 #expTagCounter METADATA 19 # counter U64 0 20 #END 21 21 22 22 # list of source exposures -- updated as exposures are seen … … 24 24 # -1 as NULL or 0 might be a valid value (empty fileset) 25 25 summitExp METADATA 26 exp_ idSTR 64 # Primary Key26 exp_name STR 64 # Primary Key 27 27 camera STR 64 # Primary Key 28 28 telescope STR 64 # Primary Key … … 37 37 # list of source images -- updated as exposures/filesets are queried 38 38 summitImfile METADATA 39 exp_ idSTR 64 # Primary Key39 exp_name STR 64 # Primary Key 40 40 camera STR 64 # Primary Key 41 41 telescope STR 64 # Primary Key … … 51 51 # downloaded) 52 52 pzPendingExp METADATA 53 exp_ idSTR 64 # Primary Key53 exp_name STR 64 # Primary Key 54 54 camera STR 64 # Primary Key 55 55 telescope STR 64 # Primary Key … … 57 57 58 58 pzPendingImfile METADATA 59 exp_ idSTR 64 # Primary Key59 exp_name STR 64 # Primary Key 60 60 camera STR 64 # Primary Key 61 61 telescope STR 64 # Primary Key 62 62 class STR 64 # Primary Key 63 63 class_id STR 64 # Primary Key 64 exp_ tag STR64 # Unique Key64 exp_id S64 64 # Unique Key 65 65 END 66 66 67 67 # list of exposures that have had all of their imfiles downloaded 68 68 pzDoneExp METADATA 69 exp_ idSTR 64 # Primary Key69 exp_name STR 64 # Primary Key 70 70 camera STR 64 # Primary Key 71 71 telescope STR 64 # Primary Key … … 73 73 74 74 pzDoneImfile METADATA 75 exp_ idSTR 64 # Primary Key75 exp_name STR 64 # Primary Key 76 76 camera STR 64 # Primary Key 77 77 telescope STR 64 # Primary Key 78 78 class STR 64 # Primary Key 79 79 class_id STR 64 # Primary Key 80 exp_ tag STR64 # Unique Key80 exp_id S64 64 # Unique Key 81 81 uri STR 255 82 82 END 83 83 84 84 newExp METADATA 85 exp_tag STR 64 # Primary Key 86 exp_id STR 64 # Key 85 exp_id S64 0 # Primary Key AUTO_INCREMENT 86 tmp_exp_name STR 64 # Key 87 tmp_camera STR 64 # Key 88 tmp_telescope STR 64 # Key 87 89 state STR 64 # Key 88 camera STR 64 # Key89 telescope STR 64 # Key90 90 imfiles S32 0 91 91 workdir STR 255 # destination for output files … … 96 96 # from there 97 97 newImfile METADATA 98 exp_ tag STR 64 # Primary Key fkey(exp_tag) ref newExp(exp_tag)99 class_id STR64 # Primary Key98 exp_id S64 64 # Primary Key fkey(exp_id) ref newExp(exp_id) 99 tmp_class_id STR 64 # Primary Key 100 100 uri STR 255 101 101 END … … 103 103 # paired with rawImfile 104 104 rawExp METADATA 105 exp_ tag STR 64 # Primary Key fkey(exp_tag) ref newExp(exp_tag)106 exp_ id STR 64 # Key105 exp_id S64 64 # Primary Key fkey(exp_id) ref newExp(exp_id) 106 exp_name STR 64 107 107 camera STR 64 108 108 telescope STR 64 109 109 dateobs UTC 0001-01-01T00:00:00Z 110 exp_tag STR 255 110 111 exp_type STR 64 111 112 imfiles S32 0 … … 136 137 137 138 rawImfile METADATA 138 exp_tag STR 64 # Primary Key fkey(exp_tag, class_id) ref newImfile(exp_tag, class_id) 139 exp_id S64 64 # Primary Key fkey(exp_id, tmp_class_id) ref newImfile(exp_id, tmp_class_id) 140 exp_name STR 64 141 camera STR 64 142 telescope STR 64 143 dateobs UTC 0001-01-01T00:00:00Z 144 tmp_class_id STR 64 # Key 139 145 class_id STR 64 # Primary Key 140 146 uri STR 255 … … 163 169 user_5 F64 0.0 164 170 object STR 64 165 dateobs UTC 0001-01-01T00:00:00Z166 171 fault S16 0 # Key NOT NULL 167 172 END 168 169 #170 # XXX - temporarily (???) stop carrying around class in imfiles after rawImfile171 # -
trunk/dbconfig/warp.md
r13690 r14023 1 # $Id: warp.md,v 1. 3 2007-06-07 01:10:31 priceExp $1 # $Id: warp.md,v 1.4 2007-07-06 01:16:08 jhoblitt Exp $ 2 2 3 3 # … … 23 23 24 24 # the list of imfiles in our skycell keyed against phase 3 25 # only allow one cam_version of an exp_ tagper warpRun25 # only allow one cam_version of an exp_id per warpRun 26 26 warpInputExp METADATA 27 27 warp_id S64 0 # Primary Key fkey(warp_id) ref warpRun(warp_id) 28 28 cam_id S64 0 # Primary Key fkey(cam_id) ref camProcessedExp(cam_id) 29 # if magic is T then look for the exp_ tagin the magic output tables29 # if magic is T then look for the exp_id in the magic output tables 30 30 magiced BOOL f # Key 31 31 END
Note:
See TracChangeset
for help on using the changeset viewer.
