STRUCT       Average
EXTNAME      DVO_AVERAGE
TYPE         BINTABLE
SIZE         112
DESCRIPTION  DVO Average Object Table

# elements of data structure / FITS table

FIELD R,              RA,          double,          RA,                           decimal degrees 
FIELD D,              DEC,         double,          DEC,                          decimal degrees 
FIELD dR,             RA_ERR,      float,           RA error,                     arcsec
FIELD dD,             DEC_ERR,     float,           DEC error,                    arcsec
				   
FIELD uR,             U_RA,        float,           RA*cos(D) proper-motion,      arcsec/year
FIELD uD,             U_DEC,       float,           DEC proper-motion,            arcsec/year
FIELD duR,            V_RA_ERR,    float,           RA*cos(D) p-m error,          arcsec/year
FIELD duD,            V_DEC_ERR,   float,           DEC p-m error,                arcsec/year
FIELD P,              PAR,         float,           parallax,                     arcsec
FIELD dP,             PAR_ERR,     float,           parallax error,               arcsec

FIELD ChiSqAve,       CHISQ_POS,   float,           astrometry analysis chisq
FIELD ChiSqPM,        CHISQ_PM,    float,           astrometry analysis chisq
FIELD ChiSqPar,       CHISQ_PAP,   float,           astrometry analysis chisq
FIELD Tmean,          MEAN_EPOCH,  int,   	    mean epoch (PM,PAR ref),       unix time seconds
FIELD Trange,         TIME_RANGE,  int,   	    mean epoch (PM,PAR ref),       unix time seconds

FIELD Xp,             SIGMA_POS,   float,           position scatter,             1/100 arcsec
FIELD Npos,           NUMBER_POS,  unsigned short,  number of detections used for astrometry

# this limits us to a max of 64k measurements per object
FIELD Nmeasure,       NMEASURE,    unsigned short,  number of psf measurements
FIELD Nmissing,       NMISSING,    unsigned short,  number of missings
FIELD Nextend,        NEXTEND,     unsigned short,  number of extended measurements

FIELD measureOffset,  OFF_MEASURE, int,             offset to first psf measurement
FIELD missingOffset,  OFF_MISSING, int,             offset to first missing obs
FIELD extendOffset,   OFF_EXTEND,  int,             offset to first extended measurement

# 'flags' was called 'code' prior to 2009.02.07
FIELD flags,          FLAGS,       uint32_t,        average object flags (star; ghost; etc)

# objID + catID gives a unique ID for all objects in the database
FIELD objID,          OBJ_ID,      unsigned int,    unique ID for object in table
FIELD catID,          CAT_ID,      unsigned int,    unique ID for table in which object was first realized
FIELD extID,          EXT_ID,      uint64_t,        external ID for object (eg PSPS objID)

# this structure should only be used for internal representations
# the average-FORMAT structures should be used for external representations
# note that the average magnitudes are stored in the 'secfilt' table (change this name??)
# the index for the secfilt table is just Nsecfilt times the index for the average table.

# *** 20090206 : new fields : ChiSq, Npos, flags (was code, uint16_t), extID

# *** 20100331 : new fields needed to assess astrometry analysis quality:

