Changeset 14231
- Timestamp:
- Jul 16, 2007, 12:34:23 PM (19 years ago)
- File:
-
- 1 edited
-
trunk/dbconfig/det.md (modified) (8 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/det.md
r14168 r14231 32 32 33 33 detInputExp METADATA 34 det_id S64 0 # Primary Key INDEX(det_id, exp_id) fkey(det_id) ref detRun(det_id)35 iteration S32 0 # Primary Key INDEX(det_id, iteration)36 exp_id S64 64 # Primary Key fkey (exp_id) ref rawExp(exp_id)37 include BOOL f 34 det_id S64 0 # Primary Key fkey(det_id) ref detRun(det_id) 35 iteration S32 0 # Primary Key fkey(exp_id) ref rawExp(exp_id) 36 exp_id S64 64 # Primary Key INDEX(det_id, exp_id) 37 include BOOL f # INDEX(det_id, iteration) 38 38 END 39 39 40 40 detProcessedImfile METADATA 41 det_id S64 0 # Primary Key fkey(det_id, exp_id) ref detInputExp(det_id, exp_id)42 exp_id S64 64 # Primary Key fkey(exp_id, class_id) ref rawImfile(exp_id, class_id)43 class_id STR 64 # Primary Key INDEX(det_id, class_id)44 uri STR 255 41 det_id S64 0 # Primary Key fkey(det_id, exp_id) ref detInputExp(det_id, exp_id) 42 exp_id S64 64 # Primary Key fkey(exp_id, class_id) ref rawImfile(exp_id, class_id) 43 class_id STR 64 # Primary Key INDEX(det_id, class_id) 44 uri STR 255 # INDEX(det_id, exp_id) 45 45 recipe STR 64 46 46 bg F64 0.0 … … 61 61 detProcessedExp METADATA 62 62 det_id S64 0 # Primary Key fkey(det_id, exp_id) ref detInputExp(det_id, exp_id) 63 exp_id S64 64 # Primary Key 64 recipe STR 64 65 bg F64 0.0 66 bg_stdev F64 0.0 67 bg_mean_stdev F64 0.0 68 fringe_0 F64 0.0 69 fringe_1 F64 0.0 70 fringe_2 F64 0.0 71 user_1 F64 0.0 72 user_2 F64 0.0 73 user_3 F64 0.0 74 user_4 F64 0.0 75 user_5 F64 0.0 76 path_base STR 255 77 fault S16 0 # Key NOT NULL 78 END 79 63 exp_id S64 64 # Primary Key fkey(det_id, exp_id) ref detProcessedImfile(det_id, exp_id) 64 recipe STR 64 65 bg F64 0.0 66 bg_stdev F64 0.0 67 bg_mean_stdev F64 0.0 68 fringe_0 F64 0.0 69 fringe_1 F64 0.0 70 fringe_2 F64 0.0 71 user_1 F64 0.0 72 user_2 F64 0.0 73 user_3 F64 0.0 74 user_4 F64 0.0 75 user_5 F64 0.0 76 path_base STR 255 77 fault S16 0 # Key NOT NULL 78 END 79 80 # 81 # detStackedImfile does not depend on detProcessedExp. detProcesedExp is purely 82 # FYI values and can be calculated in parellel 83 # 80 84 detStackedImfile METADATA 81 85 det_id S64 0 # Primary Key fkey(det_id, iteration) ref detInputExp(det_id, iteration) 82 iteration S32 0 # Primary Key fkey(det_id, class_id) ref 86 iteration S32 0 # Primary Key fkey(det_id, class_id) ref detProcessedImfile(det_id, class_id) 83 87 class_id STR 64 # Primary Key 84 88 uri STR 255 … … 96 100 97 101 detNormalizedStatImfile METADATA 98 det_id S64 0 # Primary Key fkey(det_id, iteration , class_id) ref detStackedImfile(det_id, iteration, class_id)99 iteration S32 0 # Primary Key 102 det_id S64 0 # Primary Key fkey(det_id, iteration) ref detInputExp(det_id, iteration) 103 iteration S32 0 # Primary Key fkey(det_id, iteration, class_id) ref detStackedImfile(det_id, iteration, class_id) 100 104 class_id STR 64 # Primary Key 101 105 norm F32 0.0 … … 103 107 END 104 108 105 # we can not setup a fkey against detStackedImfile here as it would preference106 # detrend registration nor can we fkey iteration as a registered detrend image107 # will not have any entrires in detInputExp108 109 109 detNormalizedImfile METADATA 110 det_id S64 0 # Primary Key INDEX(det_id, iteration)fkey(det_id) ref detInputExp(det_id)111 iteration S32 0 # Primary Key 112 class_id STR 64 # Primary Key 110 det_id S64 0 # Primary Key fkey(det_id) ref detInputExp(det_id) 111 iteration S32 0 # Primary Key fkey(det_id, iteration, class_id) ref detNormalizedStatImfile(det_id, iteration, class_id) 112 class_id STR 64 # Primary Key INDEX(det_id, iteration) 113 113 uri STR 255 114 114 bg F64 0.0 … … 125 125 126 126 detNormalizedExp METADATA 127 det_id S64 0 # Primary Key fkey(det_id, iteration) ref det NormalizedImfile(det_id, iteration)128 iteration S32 0 # Primary Key 127 det_id S64 0 # Primary Key fkey(det_id, iteration) ref detInputExp(det_id, iteration) 128 iteration S32 0 # Primary Key fkey(det_id, iteration) ref detNormalizedImfile(det_id, iteration) 129 129 recipe STR 64 130 130 bg F64 0.0 … … 155 155 156 156 detResidImfile METADATA 157 det_id S64 0 # Primary Key 158 iteration S32 0 # Primary Key 159 exp_id S64 64 # Primary Key160 class_id STR 64 # Primary Key 157 det_id S64 0 # Primary Key fkey(det_id, iteration, exp_id) ref detInputExp(det_id, iteration, exp_id) 158 iteration S32 0 # Primary Key fkey(det_id, exp_id, class_id) ref detProcessedImfile(det_id, exp_id, class_id) 159 exp_id S64 64 # Primary Key fkey(det_id, iteration) ref detNormalizedExp(det_id, iteration) 160 class_id STR 64 # Primary Key INDEX(det_id, iteration, exp_id) 161 161 uri STR 255 162 162 recipe STR 64 … … 178 178 179 179 detResidExp METADATA 180 det_id S64 0 # Primary Key 181 iteration S32 0 # Primary Key 182 exp_id S64 64 # Primary Key180 det_id S64 0 # Primary Key fkey(det_id, iteration, exp_id) ref detInputExp(det_id, iteration, exp_id) 181 iteration S32 0 # Primary Key fkey(det_id, iteration, exp_id) ref detResidImfile(det_id, iteration, exp_id) 182 exp_id S64 64 # Primary Key INDEX(det_id, iteration) 183 183 recipe STR 64 184 184 bg F64 0.0 … … 201 201 detRunSummary METADATA 202 202 det_id S64 0 # Primary Key fkey(det_id, iteration) ref detInputExp(det_id, iteration) 203 iteration S32 0 # Primary Key 203 iteration S32 0 # Primary Key fkey(det_id, iteration) ref detResidExp(det_id, iteration) 204 204 bg F64 0.0 205 205 bg_stdev F64 0.0
Note:
See TracChangeset
for help on using the changeset viewer.
