| 109 | | || detrend2||alphanumeric - ditto for these||VARCHAR(MAX)|| ||identifier of detrend image 2||smf XYnn.hdr extension || DETREND.DARK|| |
| 110 | | || detrend3||unknown||VARCHAR(MAX)|| ||identifier of detrend image 3||smf XYnn.hdr extension||DETREND.FLAT || |
| 111 | | || detrend4||unknown||VARCHAR(MAX)|| ||identifier of detrend image 4|| NA|| empty CZW: can we add DETREND.FRINGE|| |
| 112 | | || detrend5||unknown||VARCHAR(MAX)|| ||identifier of detrend image 5|| NA||empty CZW: can we add DETREND.LINEARITY|| |
| 113 | | || detrend6||unknown||VARCHAR(MAX)|| ||identifier of detrend image 6|| NA||empty || |
| 114 | | || detrend7||unknown||VARCHAR(MAX)|| ||identifier of detrend image 7|| NA|| empty|| |
| 115 | | || detrend8||unknown||VARCHAR(MAX)|| ||identifier of detrend image 8|| NA||empty || |
| | 109 | || detrend2||alphanumeric ||VARCHAR(MAX)|| ||identifier of detrend image 2||smf XYnn.hdr extension || DETREND.DARK|| |
| | 110 | || detrend3||alphanumeric||VARCHAR(MAX)|| ||identifier of detrend image 3||smf XYnn.hdr extension||DETREND.FLAT || |
| | 111 | || detrend4||alphanumeric||VARCHAR(MAX)|| ||identifier of detrend image 4|| NA|| empty CZW: can we add DETREND.FRINGE|| |
| | 112 | || detrend5||alphanumeric||VARCHAR(MAX)|| ||identifier of detrend image 5|| NA||empty CZW: can we add DETREND.LINEARITY|| |
| | 113 | || detrend6||alphanumeric||VARCHAR(MAX)|| ||identifier of detrend image 6|| NA||empty || |
| | 114 | || detrend7||alphanumeric||VARCHAR(MAX)|| ||identifier of detrend image 7|| NA|| empty|| |
| | 115 | || detrend8||alphanumeric||VARCHAR(MAX)|| ||identifier of detrend image 8|| NA||empty || |
| 125 | | || pc001001||dimensionsless - ditto for rest of pc||FLOAT||-999||elements of rotation/Dcale matrix||smf XYnn.hdr extension ||PC001001 || |
| 126 | | || pc001002||unknown||FLOAT||-999||elements of rotation/Dcale matrix||smf XYnn.hdr extension ||PC001002 || |
| 127 | | || pc002001||unknown||FLOAT||-999||elements of rotation/Dcale matrix||smf XYnn.hdr extension ||PC002001 || |
| 128 | | || pc002002||unknown||FLOAT||-999||elements of rotation/Dcale matrix|| smf XYnn.hdr extension|| PC002002|| |
| | 125 | || pc001001||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix||smf XYnn.hdr extension ||PC001001 || |
| | 126 | || pc001002||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix||smf XYnn.hdr extension ||PC001002 || |
| | 127 | || pc002001||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix||smf XYnn.hdr extension ||PC002001 || |
| | 128 | || pc002002||dimensionsless||FLOAT||-999||elements of rotation/Dcale matrix|| smf XYnn.hdr extension|| PC002002|| |
| 130 | | || pca1x3y0||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X3Y0 || |
| 131 | | || pca1x2y1||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit|| smf XYnn.hdr extension||PCA1X2Y1 || |
| 132 | | || pca1x1y2||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X1Y2 || |
| 133 | | || pca1x0y3||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X0Y3 || |
| 134 | | || pca1x2y0||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X2Y0 || |
| 135 | | || pca1x1y1||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X1Y1 || |
| 136 | | || pca1x0y2||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X0Y2 || |
| 137 | | || pca2x3y0||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension || PCA2X3Y0|| |
| 138 | | || pca2x2y1||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit|| smf XYnn.hdr extension||PCA2X2Y1 || |
| 139 | | || pca2x1y2||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA2X1Y2 || |
| 140 | | || pca2x0y3||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA2X0Y3 || |
| 141 | | || pca2x2y0||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension || PCA2X2Y0|| |
| 142 | | || pca2x1y1||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension || PCA2X1Y1|| |
| 143 | | || pca2x0y2||unknown||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA2X0Y2 || |
| | 130 | || pca1x3y0||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X3Y0 || |
| | 131 | || pca1x2y1||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit|| smf XYnn.hdr extension||PCA1X2Y1 || |
| | 132 | || pca1x1y2||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X1Y2 || |
| | 133 | || pca1x0y3||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X0Y3 || |
| | 134 | || pca1x2y0||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X2Y0 || |
| | 135 | || pca1x1y1||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X1Y1 || |
| | 136 | || pca1x0y2||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA1X0Y2 || |
| | 137 | || pca2x3y0||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension || PCA2X3Y0|| |
| | 138 | || pca2x2y1||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit|| smf XYnn.hdr extension||PCA2X2Y1 || |
| | 139 | || pca2x1y2||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA2X1Y2 || |
| | 140 | || pca2x0y3||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA2X0Y3 || |
| | 141 | || pca2x2y0||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension || PCA2X2Y0|| |
| | 142 | || pca2x1y1||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension || PCA2X1Y1|| |
| | 143 | || pca2x0y2||dimensionsless||FLOAT||-999||polynomial coefficients for the astrometric fit||smf XYnn.hdr extension ||PCA2X0Y2 || |
| 160 | | || ~~~instFlux~~~ '''psfFlux''' ||adu/sec||REAL||-999|| PSF instrumental flux (in analog-to-digital units/sec) or adu/sec|| smf primary header (EXPTIME) and XYnn.psf extension || POW(10.0, (-0.4*PSF_INST_MAG)) / EXPTIME || |
| 161 | | || ~~~instFluxErr~~~ '''psfFluxErr''' ||adu/sec||REAL||-999|| estimated error in flux|| smf primary header (EXPTIME) and XYnn.psf extension || ABS((PSF_INST_MAG_SIG*(POW(10.0, (-0.4*PSF_INST_MAG)) / EXPTIME)) / 1.085736) || |
| | 160 | || psfFlux ||adu/sec||REAL||-999|| PSF instrumental flux (in analog-to-digital units/sec) or adu/sec|| smf primary header (EXPTIME) and XYnn.psf extension || POW(10.0, (-0.4*PSF_INST_MAG)) / EXPTIME || |
| | 161 | || psfFluxErr ||adu/sec||REAL||-999|| estimated error in flux|| smf primary header (EXPTIME) and XYnn.psf extension || ABS((PSF_INST_MAG_SIG*(POW(10.0, (-0.4*PSF_INST_MAG)) / EXPTIME)) / 1.085736) || |
| 171 | | || ~~~apMag~~~ '''apFlux'''||~~~magnitude~~~ '''adu/sec'''||REAL||-999|| Aperture Flux||smf XYnn.psf extension || AP_MAG (converted to flux)|| |
| 172 | | || ~~~apMagErr~~~ '''apFluxErr'''||~~~magnitude~~~ '''adu/sec'''||REAL||-999|| Aperture magnitude error|| NA || empty || |
| 173 | | || kronFlux||~~~magnitude~~~ '''adu/sec''' ||REAL||-999|| Kron flux|| smf XYnn.psf extension || KRON_FLUX / expTime '''convert to adu/s'''|| |
| 174 | | || kronFluxErr||~~~magnitude~~~ '''adu/sec''' ||REAL||-999|| Kron flux error|| smf XYnn.psf extension || KRON_FLUX_ERR / expTime '''convert to adu/s'''|| |
| | 171 | || apFlux || adu/sec||REAL||-999|| Aperture Flux||smf XYnn.psf extension || AP_MAG (converted to flux)|| |
| | 172 | || apFluxErr||adu/sec||REAL||-999|| Aperture magnitude error|| NA || empty || |
| | 173 | || kronFlux||adu/sec||REAL||-999|| Kron flux|| smf XYnn.psf extension || KRON_FLUX / expTime '''convert to adu/s'''|| |
| | 174 | || kronFluxErr||adu/sec||REAL||-999|| Kron flux error|| smf XYnn.psf extension || KRON_FLUX_ERR / expTime '''convert to adu/s'''|| |
| 206 | | ||objID ||dimensionless|| BIGINT 8 || NA || ODM object identifier ||dvo || || |
| 207 | | ||detectID || dimensionless|| BIGINT 8 || NA || ODM detection identifier || dvo || || |
| 208 | | ||ippObjID || dimensionless || BIGINT 8 || NA || IPP object identifier||dvo || || |
| 209 | | ||ippDetectID || dimensionless|| BIGINT 8 || NA || detection ID generated by IPP|| dvo|| || |
| 210 | | ||filterID || dimensionless|| TINYINT 1|| NA || filter identifier|| dvo || || |
| 211 | | ||surveyID ||dimensionless || TINYINT 1|| NA || survey flag identifier|| dvo|| || |
| 212 | | ||ra ||degrees || FLOAT 8 || NA || Right Ascension||dvo || || |
| 213 | | ||dec ||degrees ||FLOAT 8 || NA || No comment||dvo || || |
| 214 | | ||raErr ||arcsec||REAL 4 || 0.0 || Right Ascension error|| dvo|| || |
| 215 | | ||decErr || arcsec ||REAL 4 || NA ||No comment|| dvo|| || |
| 216 | | ||~~~calMag~~~ '''zp''' || '''magnitudes''' || REAL 4 || NA || ~~~Observed, calibrated magnitude~~~ zeropoint|| dvo|| || |
| 217 | | ||~~~calMagErr~~~ '''zperr'''|| '''magnitudes''' || REAL 4 || 0.0 || ~~~Error in the observed, calibrated magnitude~~~ zeropoint err|| dvo|| || |
| 218 | | ||~~~calFlux~~~ '''exptime'''|| '''seconds''' || REAL 4 || NA ||~~~Calculated flux~~~ exptime ||dvo || || |
| 219 | | ||~~~calFluxErr~~~ '''airmass'''||dimensionless || REAL 4 || 0.0 ||~~~Error in the calculated flux~~~ airmass|| dvo|| || |
| 220 | | ||dataRelease || || TINYINT 1 ||dimensionless || Data release when this detection was ~~~taken~~~ '''generated''' || || || |
| | 206 | ||objID ||dimensionless|| BIGINT 8 || NA || ODM object identifier ||dvo || || |
| | 207 | ||detectID || dimensionless|| BIGINT 8 || NA || ODM detection identifier || dvo || || |
| | 208 | ||ippObjID || dimensionless || BIGINT 8 || NA || IPP object identifier||dvo || || |
| | 209 | ||ippDetectID || dimensionless|| BIGINT 8 || NA || detection ID generated by IPP|| dvo|| || |
| | 210 | ||filterID || dimensionless|| TINYINT 1|| NA || filter identifier|| dvo || || |
| | 211 | ||surveyID ||dimensionless || TINYINT 1|| NA || survey flag identifier|| dvo|| || |
| | 212 | ||ra ||degrees || FLOAT 8 || NA || Right Ascension||dvo || || |
| | 213 | ||dec ||degrees ||FLOAT 8 || NA || No comment||dvo || || |
| | 214 | ||raErr ||arcsec||REAL 4 || 0.0 || Right Ascension error|| dvo|| || |
| | 215 | ||decErr || arcsec ||REAL 4 || NA ||No comment|| dvo|| || |
| | 216 | || zp || magnitudes || REAL 4 || NA || zeropoint|| dvo|| || |
| | 217 | ||zperr|| magnitudes || REAL 4 || 0.0 ||zeropoint err|| dvo|| || |
| | 218 | ||exptime|| seconds || REAL 4 || NA ||exptime ||dvo || || |
| | 219 | ||airmass||dimensionless || REAL 4 || 0.0 ||airmass|| dvo|| || |
| | 220 | ||dataRelease || || TINYINT 1 ||dimensionless || Data release when this detection was generated. || || || |