Changeset 12835 for trunk/ippMonitor/def/camProcessedExp.d

Timestamp:

Apr 16, 2007, 3:21:41 PM (19 years ago)

Author:

eugene

Message:

updating to current db table layout

File:

• trunk/ippMonitor/def/camProcessedExp.d (modified) (1 diff)

trunk/ippMonitor/def/camProcessedExp.d

@@ -1 @@
-TABLE camProcessedExp
-TITLE camProcessedExp
+TABLE camProcessedExp, chipProcessedExp
+TITLE Camera-Level Processed Exposures
 FILE  camProcessedExp.php
 MENU  ipp.science.dat
 
-#     field         size   name       show            link to                extras
-FIELD exp_tag,       15,   Exposure,  value
-FIELD image,          8,   image,     image=$path_base@PPIMAGE.JPEG2, chipProcessedImfile.php, exp_tag=$exp_tag,image=$path_base@PPIMAGE.JPEG1
-FIELD bg,             8,   backgnd,   value
-FIELD bg_mean_stdev,  8,   [stdev],   value
-FIELD bg_stdev,       8,   stdev,     value
-FIELD path_base,     20,   path_base, none
-#FIELD recipe,        15,   Recipe,   value
+WHERE camProcessedExp.chip_id = chipProcessedExp.chip_id
+
+#     field                           size  name       show                            link to                  extras
+FIELD chipProcessedExp.exp_tag,       15,   Exposure,  value
+FIELD *,                              8,    image,     image=$camProcessedExp.path_base@PPIMAGE.JPEG2, chipProcessedImfile.php, exp_tag=$chipProcessedExp.exp_tag,image=$$camProcessedExp.path_base@PPIMAGE.JPEG1
+FIELD camProcessedExp.bg,             8,    backgnd,   value
+FIELD camProcessedExp.bg_mean_stdev,  8,    [stdev],   value
+FIELD camProcessedExp.bg_stdev,       8,    stdev,     value
+FIELD camProcessedExp.path_base,      20,   path_base, value
+FIELD camProcessedExp.uri,            20,   uri,       value