Changeset 19323

Timestamp:

Sep 2, 2008, 9:23:35 AM (18 years ago)

Author:

eugene

Message:

mods to flatcorr tables: adding flatcorrCamLink, dropping flatcorrExp and replacing with flatcorrChipLink; adding reduction to flatcorrRun

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• flatcorr.md (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -394 +394 @@
 
 alter table stackRun add column filter varchar(64) after tess_id;
+
+--
+
+delete from flatcorrExp;
+
+delete from flatcorrRun;
+alter table flatcorrRun add column reduction varchar(255) after stats;
+
+drop table flatcorrExp;
+
+CREATE TABLE flatcorrChipLink (
+        corr_id BIGINT,
+        chip_id BIGINT,
+        PRIMARY KEY(corr_id, chip_id),
+        FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
+        FOREIGN KEY (chip_id)  REFERENCES  chipRun(chip_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE flatcorrCamLink (
+        corr_id BIGINT,
+        chip_id BIGINT,
+        cam_id BIGINT,
+        PRIMARY KEY(corr_id, chip_id, cam_id),
+        FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
+        FOREIGN KEY (chip_id)  REFERENCES  chipRun(chip_id)
+        FOREIGN KEY (cam_id)  REFERENCES  camRun(cam_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- ALTER TABLE flatcorrCamLink ADD COLUMN chip_id BIGINT AFTER corr_id;

trunk/dbconfig/flatcorr.md

@@ -9 +9 @@
     label       STR         64
     stats       STR         255
+    reduction   STR         255
     region      STR         255
 END
 
 # table of Exposure-level data used for each flat-field corrction run
-flatcorrExp METADATA
+flatcorrChipLink METADATA
     corr_id     S64         0       # Primary Key fkey(corr_id) ref flatcorrRun(corr_id)
-    chip_id     S64         64      # Primary Key fkey(chip_id) ref chipRun(chip_id)
+    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipRun(chip_id)
 END
 
+# table of Exposure-level data used for each flat-field corrction run
+flatcorrCamLink METADATA
+    corr_id     S64         0       # Primary Key fkey(corr_id) ref flatcorrRun(corr_id)
+    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipRun(chip_id)
+    cam_id      S64         0       # Primary Key fkey(chip_id) ref chipRun(chip_id)
+END
+