Changes between Version 3 and Version 4 of ZoologyDatabase

Timestamp:

Aug 25, 2011, 11:42:56 AM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

ZoologyDatabase

@@ -13 +13 @@
 == Table {{{DetectionFeatures}}} ==
 
- * All detections from footprint have been ingested into the {{{DetectionFeatures}}} table (ask Heather where she got them)
+ * All detections from footprint (sql/footprint-<filter>-all.sql) have been ingested into the {{{DetectionFeatures}}} table
  * All fields from fits files data/footprint-<filter>-all-psphot.fits have been ingested
  * Six columns have been added: 
@@ -21 +21 @@
    * filter is g, r, i, y, or z
    * unmatched is a boolean telling if the detection is a false positive (keys: (stack_id, idex_x, idet_y))
+ * The table unmatched column was updated with sql/<filter>-unmatched.sql
+ * The CREATE TABLE statement was:
+{{{
+CREATE TABLE DetectionFeatures (
+  id            INT NOT NULL PRIMARY KEY AUTO_INCREMENT
+  , stack_id    BIGINT(20) NOT NULL
+  , INDEX(stack_id)
+  , filter      CHAR(10) NOT NULL
+  , INDEX(filter)
+  , skycell_id  CHAR(46) NOT NULL
+  , INDEX(skycell_id)
+  , idet        CHAR(18)
+  , x_psf FLOAT
+  , y_psf FLOAT
+  , x_psf_sig FLOAT
+  , y_psf_sig FLOAT
+  , posangle FLOAT
+  , pltscale FLOAT
+  , psf_inst_mag FLOAT
+  , psf_inst_mag_sig FLOAT
+  , psf_inst_flux FLOAT
+  , psf_inst_flux_sig FLOAT
+  , ap_mag FLOAT
+  , ap_mag_raw FLOAT
+  , ap_mag_radius FLOAT
+  , peak_flux_as_mag FLOAT
+  , cal_psf_mag FLOAT
+  , cal_psf_mag_sig FLOAT
+  , ra_psf DOUBLE
+  , dec_psf DOUBLE
+  , sky FLOAT
+  , sky_sigma FLOAT
+  , psf_chisq FLOAT
+  , cr_nsigma FLOAT
+  , ext_nsigma FLOAT
+  , psf_major FLOAT
+  , psf_minor FLOAT
+  , psf_theta FLOAT
+  , psf_qf FLOAT
+  , psf_qf_perfect FLOAT
+  , psf_ndof INTEGER
+  , psf_npix INTEGER
+  , moments_xx FLOAT
+  , moments_xy FLOAT
+  , moments_yy FLOAT
+  , moments_m3c FLOAT
+  , moments_m3s FLOAT
+  , moments_m4c FLOAT
+  , moments_m4s FLOAT
+  , moments_r1 FLOAT
+  , moments_rh FLOAT
+  , kron_flux FLOAT
+  , kron_flux_err FLOAT
+  , kron_flux_inner FLOAT
+  , kron_flux_outer FLOAT
+  , flags BIGINT(64)
+  , flags2 BIGINT(64)
+  , n_frames INTEGER
+  , padding INTEGER
+  , ps_zp DOUBLE
+  , exptime DOUBLE
+  , idet_x INTEGER
+  , idet_y INTEGER
+  , INDEX(stack_id, idet_x, idet_y)
+  , unmatched TINYINT(1) DEFAULT 0
+);
+}}}
 
 = View(s) =