Changeset 19131 for trunk/ippMonitor/def/stackInputSkyfile.d

Timestamp:

Aug 19, 2008, 6:53:30 PM (18 years ago)

Author:

eugene

Message:

cleanup the stack tables

File:

• trunk/ippMonitor/def/stackInputSkyfile.d (modified) (2 diffs)

trunk/ippMonitor/def/stackInputSkyfile.d

@@ -1 @@
-TABLE stackInputSkyfile, warpInputExp, camProcessedExp, chipRun, rawExp
-TITLE stackInputSkyfile
+TABLE stackInputSkyfile, stackRun, warpRun, fakeRun, camRun, chipRun, rawExp
+TITLE Stack Input Exposures
 FILE  stackInputSkyfile.php
 MENU  ipp.stack.dat
 
-WHERE stackInputSkyfile.warp_id = warpInputExp.warp_id
-WHERE warpInputExp.cam_id = camProcessedExp.cam_id
-WHERE camProcessedExp.chip_id = chipRun.chip_id
+WHERE stackRun.stack_id = stackInputSkyfile.stack_id
+WHERE stackInputSkyfile.warp_id = warpRun.warp_id
+WHERE warpRun.fake_id = fakeRun.fake_id
+WHERE fakeRun.cam_id = camRun.cam_id
+WHERE camRun.chip_id = chipRun.chip_id
 WHERE chipRun.exp_id = rawExp.exp_id
+
+ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id
+ARGS  ARG2  chipRun.chip_id=$chipRun.chip_id
+ARGS  ARG3  camRun.cam_id=$camRun.cam_id
+ARGS  ARG4  fakeRun.fake_id=$fakeRun.fake_id
+ARGS  ARG5  warpRun.warp_id=$warpRun.warp_id
 
 OP   OP1  $rawExp.ra * 57.295783
@@ -13 +21 @@
 
 #        field                          size  format  name           show     link to         extras
-FIELD    chipRun.exp_id,               5,   %s,     Exp ID
-FIELD    rawExp.exp_name,              8,   %s,     Exp Name
-FIELD    chipRun.chip_id,              5,   %s,     Chip ID
-FIELD    camProcessedExp.cam_id,       5,   %s,     Cam ID
-FIELD    warpInputExp.warp_id,         5,   %s,     Warp ID
-FIELD    stackInputSkyfile.stack_id,   5,   %s,     stack ID
-FIELD    warpInputExp.magiced,         5,   %s,     magic?
-FIELD    rawExp.telescope,            10,   %s,     Telescope
-FIELD    rawExp.camera,               10,   %s,     Camera
-FIELD    rawExp.dateobs,              19,   %T,     Date/Time
-FIELD    rawExp.ra,                    8,   %10.6f, RA,           op=OP1      
-FIELD    rawExp.decl,                  8,   %10.6f, DEC,          op=OP2
-FIELD    rawExp.object,                8,   %s,     Object
-FIELD    rawExp.filter,               10,   %s,     Filter
-FIELD    rawExp.exp_time,              5,   %.2f,   exptime    
-FIELD    rawExp.airmass,               5,   %.4f,   airmass
-FIELD    rawExp.bg,                    5,   %.2f,   bg
-FIELD    rawExp.bg_stdev,              5,   %.2f,   bg_stdev
+FIELD rawExp.exp_name,              5, %s,     Exp Name
+FIELD rawExp.exp_id,                5, %d,     Exp ID,       value,  rawImfile.php,           ARG1
+FIELD chipRun.chip_id,              7, %d,     Chip ID,      value,  chipProcessedImfile.php, ARG2
+FIELD camRun.cam_id,                7, %d,     Cam ID,       value,  camProcessedExp.php,     ARG3
+FIELD fakeRun.fake_id,              7, %d,     Fake ID,      value,  fakeProcessedImfile.php, ARG4
+FIELD warpRun.warp_id,              7, %d,     Warp ID,      value,  warpStageExp.php,        ARG5
+FIELD stackInputSkyfile.stack_id,   5, %s,     Stack ID
+FIELD stackRun.skycell_id,          5, %s,     Skycell ID
+FIELD stackRun.state,               7, %s,     State
+FIELD rawExp.telescope,            10, %s,     Telescope
+FIELD rawExp.camera,               10, %s,     Camera
+FIELD rawExp.dateobs,              19, %T,     Date/Time
+FIELD rawExp.ra,                    8, %10.6f, RA,          op=OP1    
+FIELD rawExp.decl,                  8, %10.6f, DEC,         op=OP2
+FIELD rawExp.object,                8, %s,     Object
+FIELD rawExp.filter,               10, %s,     Filter
+FIELD rawExp.exp_time,              5, %.2f,   exp_time    
+FIELD rawExp.airmass,               5, %.4f,   airmass     
+FIELD rawExp.bg,                    5, %.2f,   backgnd
+FIELD rawExp.bg_stdev,              5, %.2f,   stdev    
+FIELD rawExp.comment,              65, %s,     Comment
+