Changeset 35048 for trunk/dbconfig

Timestamp:

Jan 24, 2013, 4:54:58 PM (13 years ago)

Author:

bills

Message:

define relStack table
add ippRelease.priority
Change ippRelease.state to ippRelease.release_state

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (2 diffs)
• release.md (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -2282 +2282 @@
     surveyID    INT(8),
     releaseName VARCHAR(64),
-    state       VARCHAR(16),    -- active, pending archive drop 
+    release_state VARCHAR(16),    -- active, pending archive drop 
     dataRelease INT(8),         -- PSPS dataRelease
     PRIMARY KEY(rel_id),
@@ -2312 +2312 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE relStack (
+    relstack_id BIGINT AUTO_INCREMENT,
+    rel_id      INT(8),
+    skycal_id   BIGINT,         -- id of the sky calibration run that supplied the calibration
+                                -- for this release. We get back to stack from here
+    skycell_id  varchar(64),
+    tess_id     varchar(64),
+    state       VARCHAR(16),    -- released, pending, archive, drop  
+    flags       INT UNSIGNED,
+    stack_type  VARCHAR(16),    -- nightly, deep, reference
+    zpt_obs     FLOAT,          -- calibrated zero point for this release of this skycell
+    zpt_stdev   FLOAT,
+    fwhm_major  FLOAT,          -- seeing as measured by staticsky
+    path_base   VARCHAR(255),   -- path_base of any supporting files,
+    registered  DATETIME,
+    time_stamp  DATETIME,
+    PRIMARY KEY (relstack_id),
+    KEY (tess_id, skycell_id),
+    KEY (rel_id, tess_id, skycell_id),
+    FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id),
+    FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 UPDATE dbversion set schema_version = '1.1.74', updated= CURRENT_TIMESTAMP();

trunk/dbconfig/release.md

@@ -9 +9 @@
     surveyID    S32     0   # fkey(surveyID) ref survey(surveyID)
     releaseName STR     64
-    state       STR     16
+    release_state STR   16
     dataRelease S32     0
+    priority    S32     0
 END
 
@@ -27 +28 @@
     time_stamp  UTC     NULL
 END
+
+relStack METADATA
+    relstack_id S64     0   # Primary Key AUTO_INCREMENT
+    rel_id      S32     0   # fkey(rel_id) ref ippRelease(rel_id)
+    skycal_id   S64     0   # fkey(skycal_id) ref skycalRun(skycal_id)
+    skycell_id  STR     64
+    tess_id     STR     64
+    state       STR     16
+    flags       U32     0
+    stack_type  STR     16
+    zpt_obs     F32     0
+    zpt_stdev   F32     0
+    fwhm_major  F32     0
+    path_base   STR     255
+    registered  TAI     NULL
+    time_stamp  TAI     NULL
+END