Changeset 14113 for trunk/ippMonitor/def/chipProcessedImfile.d

Timestamp:

Jul 10, 2007, 3:07:42 PM (19 years ago)

Author:

eugene

Message:

updating to new table schema

File:

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

trunk/ippMonitor/def/chipProcessedImfile.d

@@ -1 @@
-TABLE chipProcessedImfile, chipProcessedExp
-TITLE chipProcessedImfile
+TABLE chipRun, rawExp, chipProcessedImfile
+TITLE chip Processed Imfile
 FILE  chipProcessedImfile.php
-MENU  ipp.imfiles.dat
+MENU  ipp.science.dat
 
-WHERE chipProcessedImfile.chip_id = chipProcessedExp.chip_id
+# limit this table to non-OBJECT types of images
+WHERE chipRun.state = 'stop'
+WHERE chipRun.exp_id = rawExp.exp_id
+WHERE chipProcessedImfile.exp_id = chipRun.exp_id
+WHERE chipProcessedImfile.chip_id = chipRun.chip_id
 
-#     field                               size  name        show  link to     extras
-FIELD chipProcessedExp.exp_id,            15,   Exposure
-FIELD chipProcessedImfile.class_id,       8,    Chip ID
-FIELD chipProcessedImfile.bg,             8,    backgnd
-FIELD chipProcessedImfile.bg_mean_stdev,  8,    [stdev]
-FIELD chipProcessedImfile.bg_stdev,       8,    stdev
+ARGS  ARG1  exp_id=$chipRun.exp_id
 
-TAIL PHP insert_image ('PPIMAGE.JPEG1');
+#     field                   size  name         show    link to                  extras
+FIELD chipRun.chip_id,           7, chip ID
+FIELD chipRun.exp_id,            5, Exp ID,      value,  rawImfile.php,           ARG1
+FIELD rawExp.exp_name,           5, Exp Name,    value,  chipProcessedImfile.php, ARG2
+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 chipProcessedImfile.bg,                    5, backgnd
+FIELD chipProcessedImfile.bg_stdev,              5, stdev    
+FIELD chipProcessedImfile.bg_mean_stdev,         5, <backgnd>
+
+FIELD chipProcessedImfile.n_stars,  5, Nstars
+FIELD chipProcessedImfile.n_astrom, 5, Nastrom
+FIELD chipProcessedImfile.sigma_ra, 5, sigma ra
+FIELD chipProcessedImfile.fwhm,     5, FHWM
+
+# FIELD chipPendingExp.reduction,    20,   reduction
+# FIELD chipPendingExp.guide_id,     20, guide ID