Changeset 13649 for trunk/dbconfig/cam.md

Timestamp:

Jun 5, 2007, 11:55:11 AM (19 years ago)

Author:

eugene

Message:

added various chip and camera level metadata fields (bias stdev, ap resid, etc)

File:

• trunk/dbconfig/cam.md (modified) (1 diff)

trunk/dbconfig/cam.md

@@ -13 +13 @@
 camProcessedExp METADATA
 # the camPendingExp row gets deleted so we can not put a fkey on cam_id
-    cam_id      S64         0       # Primary Key
-    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipProcessedExp(chip_id)
-    workdir     STR         255 
-    label       STR         64      # key
-    recipe      STR         64
-    expgroup    STR         64      # key
-    dvodb       STR         255
-    uri         STR         255
-    bg          F64         0.0
-    bg_stdev    F64         0.0
-    bg_mean_stdev   F64     0.0
-    sigma_ra    F32         0.0
-    sigma_dec   F32         0.0
-    nastro      S32         0
-    path_base   STR         255
-    zp_mean     F32         0.0
-    zp_stdev    F32         0.0
-    fault       S16         0       # Key NOT NULL
+    cam_id         S64      0       # Primary Key
+    chip_id        S64      0       # Primary Key fkey(chip_id) ref chipProcessedExp(chip_id)
+    workdir        STR      255 
+    label          STR      64      # key
+    recipe         STR      64
+    expgroup       STR      64      # key
+    dvodb          STR      255
+    uri            STR      255
+    bg             F32      0.0
+    bg_stdev       F32      0.0
+    bg_mean_stdev  F32      0.0
+    sigma_ra       F32      0.0
+    sigma_dec      F32      0.0
+    zp_mean        F32      0.0
+    zp_stdev       F32      0.0
+    fwhm           F32      0.0
+    fwhm_range     F32      0.0
+    n_stars        S32      0
+    n_extended     S32      0
+    n_cr           S32      0
+    n_astrom       S32      0
+    path_base      STR      255
+    fault          S16      0       # Key NOT NULL
 END