Changes between Version 39 and Version 40 of ippToPsps_Detections

Timestamp:

Jun 23, 2011, 10:05:28 AM (15 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Detections

@@ -30 +30 @@
 || surveyID||unknown||TINYINT||0||survey flag identifier|| GPC1 database || SELECT camRun.dist_group FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id. The IPP dist_group is then used to get the surveyID from the PSPS 'Survey' table [browser:trunk/ippToPsps/config/init/tables.vot here]||
 || filterID||unknown||TINYINT||0||filter identifier|| smf primary header || Single character filter (grizy) is then used to get PSPS ID from Filter table [browser:trunk/ippToPsps/config/init/tables.vot here] ||
-|| cameraID||unknown||SMALLINT||0||camera identifier|| || ||
-|| cameraConfigID||unknown||SMALLINT||0||camera configuration identifier|| || ||
-|| telescopeID||unknown||SMALLINT||0||telescope identifier|| || ||
-|| analysisVer||unknown||VARCHAR(MAX)|| ||IPP software analysis release|| || ||
-|| p1Recip||unknown||VARCHAR(MAX)|| ||IPP phase 1 MD5 Checksum|| || ||
-|| p2Recip||unknown||VARCHAR(MAX)|| ||IPP phase 2 MD5 Checksum|| || ||
-|| p3Recip||unknown||VARCHAR(MAX)|| ||IPP phase 3 MD5 Checksum|| || ||
+|| cameraID||unknown||SMALLINT||0||camera identifier|| NA || hardcoded to 1 ||
+|| cameraConfigID||unknown||SMALLINT||0||camera configuration identifier|| NA ||hardcoded to 1 ||
+|| telescopeID||unknown||SMALLINT||0||telescope identifier|| NA || hardcoded to 1 ||
+|| analysisVer||unknown||VARCHAR(MAX)|| ||IPP software analysis release|| NA || empty ||
+|| p1Recip||unknown||VARCHAR(MAX)|| ||IPP phase 1 MD5 Checksum||NA || empty ||
+|| p2Recip||unknown||VARCHAR(MAX)|| ||IPP phase 2 MD5 Checksum|| NA|| empty  ||
+|| p3Recip||unknown||VARCHAR(MAX)|| ||IPP phase 3 MD5 Checksum|| NA || empty ||
 || nOTA||unknown||SMALLINT||-999||number of valid OTA/CCD images in this exposure|| || ||
 || photoScat||mag||REAL||-999|| global photometric scatter|| || ||