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

Timestamp:

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

Author:

eugene

Message:

updated to match new schema

File:

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

trunk/ippMonitor/def/chipProcessedExp.d

@@ -1 @@
-TABLE chipProcessedExp
-TITLE chipProcessedExp
-FILE  chipProcessedExp.php
+TABLE chipRun, rawExp, chipProcessedImfile
+TITLE chip Processed Exposures
+FILE  chipPendingExp.php
 MENU  ipp.science.dat
 
-ARGS  ARG1  exp_id=$exp_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 exp_id,        20,   Exp ID,        value,   chipProcessedImfile.php,  ARG1
-FIELD chip_id,       20,   Chip ID
-FIELD guide_id,      20,   guide ID,      value,   guideProcessedExp.php,    ARG1
-FIELD label,         20,   label
-FIELD workdir,       20,   workdir
+ARGS  ARG1  exp_id=$chipRun.exp_id
+
+#     field                   size  name         show    link to         extras
+FIELD chipRun.chip_id,           7, chip ID
+FIELD chipRun.exp_id,            5, Exp ID
+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>
+
+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