Changeset 14096 for trunk/ippMonitor/def/camPendingExp.d

Timestamp:

Jul 9, 2007, 5:10:37 PM (19 years ago)

Author:

eugene

Message:

updated to match new schema

File:

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

trunk/ippMonitor/def/camPendingExp.d

@@ -1 @@
-TABLE camPendingExp, chipProcessedExp
+TABLE camRun, chipRun, rawExp
 TITLE Camera Pending
 FILE  camPendingExp.php
 MENU  ipp.science.dat
 
-WHERE camPendingExp.chip_id = chipProcessedExp.chip_id
+WHERE camRun.state != 'stop'
+WHERE camRun.chip_id = chipRun.chip_id
+WHERE chipRun.exp_id = rawExp.exp_id
 
-ARGS  ARG1  chipProcessedExp.exp_id=$chipProcessedExp.exp_id
+ARGS  ARG1  chipRun.exp_id=$chipRun.exp_id
 
 #     field                     size  name          show   link to                  extras
-FIELD chipProcessedExp.exp_id,  20,   exposure ID,  value, chipProcessedImfile.php, ARG1
-FIELD camPendingExp.chip_id,    20,   chip ID,      value, chipProcessedExp.php,    ARG1
-FIELD camPendingExp.cam_id,     20,   cam ID
+FIELD camRun.cam_id,             5,   chip ID,      value, chipProcessedExp.php,    ARG1
+FIELD chipRun.chip_id,           5,   cam ID
+FIELD chipRun.exp_id,            5,   exposure ID,  value, chipProcessedImfile.php, ARG1
+FIELD rawExp.exp_name,           5,   Exp Name,     value, rawImfile.php,  ARG1
+FIELD rawExp.telescope,         10,   Telescope
+FIELD rawExp.camera,            10,   Camera
+FIELD rawExp.dateobs,           20,   Date/Time
+FIELD rawExp.filter,            10,   FILTER
+FIELD rawExp.ra,                 5,   RA    
+FIELD rawExp.decl,               5,   Dec
+FIELD rawExp.exp_time,           5,   exp_time    
+FIELD rawExp.sat_pixel_frac,     5,   f(sat pixels)
+FIELD rawExp.airmass,            5,   airmass     
+FIELD rawExp.bg,                 5,   backgnd
+FIELD rawExp.bg_stdev,           5,   stdev    
+FIELD rawExp.bg_mean_stdev,      5,   <backgnd>