Changes between Version 4 and Version 5 of ZoologyDatabase

Timestamp:

Aug 25, 2011, 11:49:07 AM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

ZoologyDatabase

@@ -90 +90 @@
 
 = View(s) =
+== View {{{FalsePositives}}} ==
+ * Consist of the detections where unmatched is 1
+ * Built from {{{DetectionFeatures}}}
+ * How it was built
+{{{
+CREATE VIEW FalsePositives AS SELECT * from DetectionFeatures WHERE unmatched = 1;
+}}}
+
+== View {{{AnalysisStage010}}} ==
+ * Consist of "flagged as having a problem" detections
+ * Built from {{{FalsePositives}}}
+ * How it was built
+{{{
+CREATE VIEW AnalysisStage010 AS SELECT * from FalsePositives WHERE (!(flags2 & 64) AND !(flags2 & 32) 
+AND !(flags2 & 16) AND !(flags2&8) AND !(flags & 2048) AND !(flags & 4096) AND !(flags&8192) AND !(flags&16384) AND !(flags&268435456)) AND (cal_psf_mag is not null);
+}}}
+= View(s) =