objID           dimensionless   BIGINT  8         NA    ODM object identifier
uniquePspsP2id  dimensionless   BIGINT  8         NA    unique identifier for psps based on batch_id, OTA, and counter (per detection)
detectID        dimensionless   BIGINT  8         NA    ODM detection identifier
ippObjID        dimensionless   BIGINT  8         NA    detection id generated by IPP
ippDetectID     dimensionless   BIGINT  8         NA    detection id generated by IPP
filterID        dimensionless   TINYINT 1         NA    filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ...
surveyID        dimensionless   TINYINT 1         NA    survey flag identifier
imageID         dimensionless   BIGINT  8         NA    image id hash of frame identifier & OTA/CCD number
randomDetID     dimensionless   FLOAT   8         NA    random detection Id
dvoRegionID     dimensionless   INT     4          0    identifier to dvo spatial region
obsTime         MeanJulianDays  FLOAT   8       -999    Time of mid observation in Mean Julian Days
xPos            raw pixels      REAL    4       -999    measured x on CCD from PSF fit
yPos            raw pixels      REAL    4       -999    measured y on CCD from PSF fit
xPosErr         raw pixels      REAL    4       -999    estimated error in x
yPosErr         raw pixels      REAL    4       -999    estimated error in y
pltScale        arcsec/pix      REAL    4       -999    plate scale at this location (from DVO)
posAngle        degrees         REAL    4       -999    position angle (sky-to-chip) at this location (from DVO)
------------------------------------------------------  Note - next 8 lines came from previous DetCalib table
ra              degrees         FLOAT   8         NA    Right Ascension
dec             degrees         FLOAT   8         NA    Declination
raErr           arcsec          REAL    4         NA    Right Ascension error
decErr          arcsec          REAL    4         NA    Declination error
extNSigma       dimensionless   REAL    4       -999    measure of extendedness
zp              magnitude       REAL    4          0    zeropoint (only thing needed to convert adu/sec to AB mag), note no zpErr
telluricExt     magnitude       REAL    4         NA    estimated extinction due to non-photometric conditions  
expTime         seconds         REAL    4       -999    exposure time (informational)
airMass         dimensionless   REAL    4          0    airmass (informational)
------------------------------------------------------  
psfFlux         Jy              REAL    4       -999    PSF flux in Jy
psfFluxErr      Jy              REAL    4       -999    PSF flux error
psfMajorFWHM    arcsec          REAL    4       -999    model PSF width in major axis
psfMinorFWHM    arcsec          REAL    4       -999    model PSF width in minor axis
psfTheta        degrees         REAL    4       -999    model PSF orientation angle degrees East of North
psfCore         dimensionless   REAL    4       -999    model PSF core parameter [k in (1 + kz + z^1.66)]
psfQf           dimensionless   REAL    4       -999    PSF coverage factor
psfQfPerfect    dimensionless   REAL    4       -999    PSF-weighted fraction of pixels totally unmasked
psfChiSq        dimensionless   REAL    4       -999    reduced-chisq of the psf model fit. (ndof?, npix?)
psfLikelihood   dimensionless   REAL    4       -999    PSF likelihood
momentXX        arcsec^2        REAL    4       -999    moment XX
momentXY        arcsec^2        REAL    4       -999    moment XY
momentYY        arcsec^2        REAL    4       -999    momeny YY
momentR1        arcsec          REAL    4       -999    first radial moment 
momentRH        arcsec          REAL    4       -999    r^1/2 weighted moment
momentM3C       arcsec^2        REAL    4       -999    r^2 cos(3 theta)
momentM3S       arcsec^2        REAL    4       -999    r^2 sin(3 theta)
momentM4C       arcsec^2        REAL    4       -999    r^2 cos(4 theta)
momentM4S       arcsec^2        REAL    4       -999    r^2 sin(4 theta) 
apFlux          Jy              REAL    4       -999    Aperture flux in Jy
apFluxErr       Jy              REAL    4       -999    Aperture flux error
apFillF         dimensionless   REAL    4       -999    Aperture fill factor 
apRadius        arcsec          REAL    4       -999    Aperture radius
kronFlux        Jy              REAL    4       -999    Kron flux in Jy
kronFluxErr     Jy              REAL    4       -999    Kron flux error
kronRad         arcsec      	REAL    4       -999    Kron radius
sky             Jy/arcsec^2     REAL    4       -999    sky surface-brightness at source
skyErr          Jy/arcsec^2     REAL    4       -999    sky surface-brightness error
infoFlag        dimensionless   INT     4       -999    flag indicating provenance information
infoFlag2       dimensionless   INT     4       -999    flag indicating provenance information
infoFlag3       dimensionless   INT     4       -999    flag indicating provenance information
dataRelease     dimensionless   TINYINT 1         NA    Data release when this detection was originally taken. Recalibrations do not affect this value.
--
-- [231 bytes/det]

### do we want apRadius?
### relevant code spots:
### config/tables.P2.vot, detectionbatch.py:315
