Changes between Version 5 and Version 6 of ippReleaseManagement

Timestamp:

Sep 20, 2012, 3:43:02 PM (14 years ago)

Author:

bills

Comment:

--

ippReleaseManagement

@@ -202 +202 @@
 }}}
 
-
-
-
-
-
-
-
+This table will allow us to easily identify for a given exposure and release the derived data products that were used
+to construct the results for the exposure. Here are a couple of examples
+
+
+{{{
+mysql> mysql> select ippRelease.releaseName, relExp.* from ippRelease join relExp using(rel_id) where exp_id = 356773;
++-------------+-----------+--------+--------+---------+--------+---------+--------+----------+------------+-------+---------+-----------+-----------+---------------------+---------------------+
+| releaseName | relexp_id | rel_id | exp_id | chip_id | cam_id | warp_id | add_id | state    | data_state | flags | zpt_obs | zpt_stdev | path_base | registered          | time_stamp          |
++-------------+-----------+--------+--------+---------+--------+---------+--------+----------+------------+-------+---------+-----------+-----------+---------------------+---------------------+
+| SAS.V8      |         1 |      4 | 356773 |  496671 | 473031 |  453844 | 883989 | archive  | inpsps     |     0 | 24.4298 |  0.042454 | NULL      | 2012-09-19 15:16:36 | 2012-09-19 15:16:36 | 
+| SAS.V9      |       621 |      5 | 356773 |  496671 | 473031 |  453844 | 888750 | released | inpsps     |     0 | 24.4298 |  0.042454 | NULL      | 2012-09-19 15:18:51 | 2012-09-19 15:18:51 | 
++-------------+-----------+--------+--------+---------+--------+---------+--------+----------+------------+-------+---------+-----------+-----------+---------------------+---------------------+
+2 rows in set (0.00 sec)
+
+}}}
+
+
+
+
+
+
+