Changeset 35048 for trunk/dbconfig/release.md

Timestamp:

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

Author:

bills

Message:

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

File:

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

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