Changeset 19620 for trunk/dbconfig/det.md

Timestamp:

Sep 19, 2008, 2:10:32 PM (18 years ago)

Author:

eugene

Message:

adding ref_det_id, ref_iter to detRun and detResidImfile, modifying the foreign constraint

File:

• trunk/dbconfig/det.md (modified) (2 diffs)

trunk/dbconfig/det.md

@@ -28 +28 @@
     solang_max  F32         0.0
     label       STR         64      # key
-    parent      S32         0       # Key
+    ref_det_id  S64         0       # reference for 'verify' and 'correction' analysis
+    ref_iter    S32         0       # reference for 'verify' and 'correction' analysis
 END
 
@@ -165 +166 @@
     det_id      S64         0       # Primary Key fkey(det_id, iteration, exp_id) ref detInputExp(det_id, iteration, exp_id)
     iteration   S32         0       # Primary Key fkey(det_id, exp_id, class_id) ref detProcessedImfile(det_id, exp_id, class_id)
-    exp_id     S64         64       # Primary Key fkey(det_id, iteration) ref detNormalizedExp(det_id, iteration)
+    ref_det_id  S64         0       # detrend master actually applied (same as above for 'master', but not for 'verify')
+    ref_iter    S32         0       # detrend master actually applied (same as above for 'master', but not for 'verify')
+    exp_id      S64         64      # Primary Key fkey(det_id, iteration) ref detNormalizedExp(det_id, iteration)
     class_id    STR         64      # Primary Key INDEX(det_id, iteration, exp_id)
     uri         STR         255