Changeset 35153

Timestamp:

Feb 12, 2013, 4:22:03 PM (13 years ago)

Author:

bills

Message:

remove warpBackgroundRun.alt_cam_label add chipBackgroundRun.cam_id and modify relStack to
include stack_id but not require skycal_id

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (4 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1792 +1792 @@
     chip_bg_id BIGINT AUTO_INCREMENT, -- unique identifier
     chip_id BIGINT NOT NULL,          -- link to chipRun
+    cam_id BIGINT DEFAULT 0,          -- optional link to camRun
     state VARCHAR(64) NOT NULL,       -- state of run (new, full, etc.)
     workdir VARCHAR(255) NOT NULL,    -- working directory
@@ -1845 +1846 @@
     dist_group VARCHAR(64),           -- group for distribution
     reduction VARCHAR(64),            -- reduction class (for altering recipe)
-    alt_cam_label VARCHAR(64),        -- label for alternate version of astrometry (optional)
     note VARCHAR(255),        -- note
     registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
@@ -2198 +2198 @@
     relstack_id BIGINT AUTO_INCREMENT,
     rel_id      INT(8),
+    stack_id    BIGINT,         -- id of the stackRun
     skycal_id   BIGINT,         -- id of the sky calibration run that supplied the calibration
-                                -- for this release. We get back to stack from here
+                                -- for this release of this skycell.
     skycell_id  varchar(64),
     tess_id     varchar(64),
@@ -2215 +2216 @@
     KEY (rel_id, tess_id, skycell_id),
     FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id),
-    FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
+    FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;