Changes between Version 4 and Version 5 of ippReleaseManagement

Timestamp:

Sep 20, 2012, 3:34:22 PM (14 years ago)

Author:

bills

Comment:

--

ippReleaseManagement

@@ -170 +170 @@
 The two SAS entries refer to PS1_SAS_08 and PS1_SAS_09.
 
-Now we turn our attention to tables that record the actual contents of a release.
-
-
-
-
-
-
-
-
-
+Now we turn our attention to tables that record the actual contents of a release. Single frame results
+are represented by the table relExp (released exposure) and relSkycell (released skycell). (Similar table
+will be defined for difference data products in the future).
+
+== Released Exposure ==
+The relExp table encapsulates the data products that were used to construct the released data
+for a given exposure and the results of the calibration of the exposure. The proposed table definition 
+is as follows
+
+{{{
+mysql> describe relExp;
++------------+------------------+------+-----+---------+----------------+
+| Field      | Type             | Null | Key | Default | Extra          |
++------------+------------------+------+-----+---------+----------------+
+| relexp_id  | bigint(20)       | NO   | PRI | NULL    | auto_increment | Primary key for the table
+| rel_id     | smallint(6)      | YES  | MUL | NULL    |                | The corresponding release
+| exp_id     | bigint(20)       | YES  |     | NULL    |                | The IPP exposure identifier
+| chip_id    | bigint(20)       | YES  |     | NULL    |                | id for chipRun
+| cam_id     | bigint(20)       | YES  |     | NULL    |                | id for camRun
+| warp_id    | bigint(20)       | YES  |     | NULL    |                | id for warpRun
+| add_id     | bigint(20)       | YES  |     | NULL    |                | id for addRun (addstar injest into DVO)
+| state      | varchar(16)      | YES  | MUL | NULL    |                | state for this row see below
+| data_state | varchar(16)      | YES  | MUL | NULL    |                | see below
+| flags      | int(10) unsigned | YES  |     | NULL    |                | 
+| zpt_obs    | float            | YES  |     | NULL    |                | calibrated zero point and error when released
+| zpt_stdev  | float            | YES  |     | NULL    |                | 
+| path_base  | varchar(255)     | YES  |     | NULL    |                | path to any supporting files
+| registered | datetime         | YES  |     | NULL    |                | creation time for row
+| time_stamp | datetime         | YES  |     | NULL    |                | time of last update to row
++------------+------------------+------+-----+---------+----------------+
+}}}
+
+
+
+
+
+
+
+