Changeset 19620

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

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• det.md (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -469 +469 @@
 update fakeProcessedImfile set data_state ='full';
 
+-- adding ref_det_id and ref_iter to detRun and detResidImfile
+
+ALTER TABLE detResidImfile add column ref_det_id bigint after iteration;
+ALTER TABLE detResidImfile add column ref_iter int after iteration;
+
+ALTER TABLE detResidImfile add column ref_det_id bigint after iteration;
+ALTER TABLE detResidImfile add column ref_iter int after iteration;
+
+ALTER TABLE detRun change column parent ref_det_id bigint;
+ALTER TABLE detRun add column ref_iter int after ref_det_id;
+
+-- XXX need to change the foreign key constraints on detResidImfile:
+-- This
+--    FOREIGN KEY (det_id, iteration)
+--    REFERENCES  detNormalizedExp(det_id, iteration)
+-- Becomes:
+--    FOREIGN KEY (ref_det_id, ref_iter)
+--    REFERENCES  detNormalizedExp(det_id, iteration)
+
+-- XXX Need to population ref_det_id with the contents of det_id for detRun.mode == 'master'

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