Changeset 8282 for trunk/dbconfig/tasks.md
- Timestamp:
- Aug 10, 2006, 3:32:47 PM (20 years ago)
- File:
-
- 1 edited
-
trunk/dbconfig/tasks.md (modified) (12 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/tasks.md
r8227 r8282 1 # $Id: tasks.md,v 1.5 4 2006-08-08 03:06:28jhoblitt Exp $1 # $Id: tasks.md,v 1.55 2006-08-11 01:32:47 jhoblitt Exp $ 2 2 3 3 # this table records all exposure ID ever seen from the summit … … 5 5 6 6 # note that dec is a MySQL reserved word 7 # note that use is a MySQL reserved word 8 # note that exp is a MySQL reserved word 7 9 8 10 summitExp METADATA … … 28 30 # class_id == type set id 29 31 pzPendingImfile METADATA 30 exp_id STR 64 # Key32 exp_id STR 64 # Primary Key 31 33 bytes S32 0 32 34 md5sum STR 32 33 35 class STR 64 34 class_id STR 64 36 class_id STR 64 # Primary Key 35 37 uri STR 255 36 38 END … … 45 47 END 46 48 49 # class needs to be carried here so it can go into rawImfile and be normalized 50 # from there 47 51 newImfile METADATA 48 52 exp_id STR 64 # Primary Key 49 class STR 64 # Primary Key53 class STR 64 50 54 class_id STR 64 # Primary Key 51 55 uri STR 255 … … 59 63 exp_type STR 64 60 64 imfiles S32 0 61 filter STR 25562 airmass F32 0.063 ra F64 0.064 decl F64 0.065 exp_time F32 0.066 background F64 0.067 END68 69 # paired with rawImfile70 rawScienceExp METADATA71 exp_id STR 64 # Primary Key72 camera STR 25573 telescope STR 25574 exp_type STR 6475 imfiles S32 076 filter STR 25577 airmass F32 0.078 ra F64 0.079 decl F64 0.080 exp_time F32 0.081 background F64 0.082 END83 84 rawImfile METADATA85 exp_id STR 64 # Primary Key86 class STR 64 # Primary Key87 class_id STR 64 # Primary Key88 uri STR 25589 65 filter STR 255 90 66 airmass F32 0.0 … … 101 77 END 102 78 103 # 104 # XXX - temporarily (???) stot carrying around class in imfiles after rawImfile 105 # 106 107 p1PendingExp METADATA 108 exp_id STR 64 # Primary Key 79 # paired with rawImfile 80 rawScienceExp METADATA 81 exp_id STR 64 # Primary Key 109 82 camera STR 255 110 83 telescope STR 255 … … 116 89 decl F64 0.0 117 90 exp_time F32 0.0 118 background F64 0.0 119 recipe STR 64 120 p1_version S32 0 121 END 122 123 # do we need nclass? 124 # class is missing 125 126 p2PendingExp METADATA 127 exp_id STR 64 # Primary Key 128 camera STR 255 129 telescope STR 255 130 exp_type STR 64 131 imfiles S32 0 132 filter STR 255 133 airmass F32 0.0 134 ra F32 0.0 135 decl F64 0.0 136 exp_time F64 0.0 137 background F64 0.0 138 recipe STR 64 139 p1_version S32 0 140 p2_version S32 0 141 END 142 143 # uris in & out ? 144 145 p2PendingImfile METADATA 146 exp_id STR 64 # Key 147 # class STR 64 148 class_id STR 64 149 uri STR 255 150 recipe STR 64 151 p1_version S32 0 152 p2_version S32 0 153 END 154 155 # nclass & ndone? 156 # and/or logging imfile done better? 157 158 p2DoneExp METADATA 159 exp_id STR 64 # Primary Key 160 camera STR 255 161 telescope STR 255 162 exp_type STR 64 163 imfiles S32 0 91 bg F64 0.0 92 bg_stdev F64 0.0 93 bg_mean_stdev F64 0.0 94 alt F64 0.0 95 az F64 0.0 96 ccd_temp F32 0.0 97 posang F64 0.0 98 END 99 100 rawImfile METADATA 101 exp_id STR 64 # Primary Key 102 class STR 64 103 class_id STR 64 # Primary Key 104 uri STR 255 164 105 filter STR 255 165 106 airmass F32 0.0 … … 167 108 decl F64 0.0 168 109 exp_time F32 0.0 169 background F64 0.0 110 bg F64 0.0 111 bg_stdev F64 0.0 112 bg_mean_stdev F64 0.0 113 alt F64 0.0 114 az F64 0.0 115 ccd_temp F32 0.0 116 posang F64 0.0 117 END 118 119 # 120 # XXX - temporarily (???) stot carrying around class in imfiles after rawImfile 121 # 122 123 p1PendingExp METADATA 124 exp_id STR 64 # Primary Key 125 recipe STR 64 126 p1_version S32 0 127 END 128 129 # do we need nclass? 130 # class is missing 131 132 p2PendingExp METADATA 133 exp_id STR 64 # Primary Key 134 recipe STR 64 135 p1_version S32 0 136 p2_version S32 0 137 END 138 139 # uris in & out ? 140 141 p2PendingImfile METADATA 142 exp_id STR 64 # Primary Key 143 class_id STR 64 # Primary Key 144 uri STR 255 145 recipe STR 64 146 p1_version S32 0 147 p2_version S32 0 148 END 149 150 # nclass & ndone? 151 # and/or logging imfile done better? 152 153 p2DoneExp METADATA 154 exp_id STR 64 # Primary Key 170 155 recipe STR 64 171 156 p1_version S32 0 … … 177 162 178 163 p2DoneImfile METADATA 179 exp_id STR 64 # Key 180 # class STR 64 181 class_id STR 64 164 exp_id STR 64 # Primary Key 165 class_id STR 64 # Primary Key 182 166 uri STR 255 183 167 recipe STR 64 … … 194 178 p3PendingExp METADATA 195 179 exp_id STR 64 # Primary Key 196 camera STR 255197 exp_type STR 64198 imfiles S32 0199 filter STR 255200 airmass F32 0.0201 ra F64 0.0202 decl F64 0.0203 exp_time F32 0.0204 background F64 0.0205 180 recipe STR 64 206 181 p2_version S32 0 … … 217 192 iteration S32 0 # Primary Key 218 193 exp_id STR 64 # Primary Key 219 camera STR 255 220 telescope STR 255 221 exp_type STR 64 222 imfiles S32 0 223 filter STR 255 224 airmass F32 0.0 225 ra F64 0.0 226 decl F64 0.0 227 exp_time F32 0.0 228 background F64 0.0 194 include BOOL f 195 accept BOOL f 229 196 END 230 197 … … 283 250 exp_id STR 64 # Primary Key 284 251 recipe STR 64 252 keep BOOL f 285 253 accept BOOL f 286 254 END
Note:
See TracChangeset
for help on using the changeset viewer.
