Description of table: plxSource

+--------------+-----------------------+------+-----+---------+-------+
| Field        | Type                  | Null | Key | Default | Extra |
+--------------+-----------------------+------+-----+---------+-------+
| sourceid     | int(10) unsigned      | NO   | PRI | NULL    |       |
| ra           | double(12,9) unsigned | NO   |     | NULL    |       |
| de           | double(11,9)          | NO   |     | NULL    |       |
| mag          | float(5,3)            | NO   |     | NULL    |       |
| emag         | float(5,3) unsigned   | NO   |     | NULL    |       |
| ell          | float(4,3) unsigned   | NO   |     | NULL    |       |
| pm           | double(7,3) unsigned  | NO   |     | NULL    |       |
| epm          | double(7,3) unsigned  | NO   |     | NULL    |       |
| rapm         | double(7,3)           | NO   |     | NULL    |       |
| erapm        | double(7,3) unsigned  | NO   |     | NULL    |       |
| depm         | double(7,3)           | NO   |     | NULL    |       |
| edepm        | double(7,3) unsigned  | NO   |     | NULL    |       |
| plx          | float(5,3) unsigned   | NO   |     | NULL    |       |
| eplx         | float(5,3) unsigned   | NO   |     | NULL    |       |
| epochs       | smallint(5) unsigned  | NO   |     | NULL    |       |
| dets         | tinyint(3) unsigned   | NO   |     | NULL    |       |
| stellardets  | tinyint(3) unsigned   | NO   |     | NULL    |       |
| pawprintdets | tinyint(3) unsigned   | NO   |     | NULL    |       |
| Zmag         | float(5,3)            | YES  |     | NULL    |       |
| eZmag        | float(5,3) unsigned   | YES  |     | NULL    |       |
| Zell         | float(4,3) unsigned   | YES  |     | NULL    |       |
| Zclass       | tinyint(4)            | YES  |     | NULL    |       |
| Ymag         | float(5,3)            | YES  |     | NULL    |       |
| eYmag        | float(5,3) unsigned   | YES  |     | NULL    |       |
| Yell         | float(4,3) unsigned   | YES  |     | NULL    |       |
| Yclass       | tinyint(4)            | YES  |     | NULL    |       |
| Jmag         | float(5,3)            | YES  |     | NULL    |       |
| eJmag        | float(5,3) unsigned   | YES  |     | NULL    |       |
| Jell         | float(4,3) unsigned   | YES  |     | NULL    |       |
| Jclass       | tinyint(4)            | YES  |     | NULL    |       |
| Hmag         | float(5,3)            | YES  |     | NULL    |       |
| eHmag        | float(5,3) unsigned   | YES  |     | NULL    |       |
| Hell         | float(4,3) unsigned   | YES  |     | NULL    |       |
| Hclass       | tinyint(4)            | YES  |     | NULL    |       |
+--------------+-----------------------+------+-----+---------+-------+

Notes:
- The astrometric fit is performed separately for each 'pawprint set' (all epochs
of a coincident pawprint observations). Fields such as RA, Dec, mag, pm, plx,
etc. are averages of their equivalent values across overlapping pawprint sets
(and tiles).

- sourceid - unique source identifier. Maintained between tables in the
database.

- ra, de - Right Ascension and Declination are products of the astrometric fit,
given in decimal degrees at epoch 2012.0. These are averages across measurements
made in overlapping pawprint sets.

- mag, emag - Ks band magnitudes, inverse variance weighted averages across
overlapping pawprint sets. A magnitude and uncertainty from each pawprint set
are the median and median absolute deviation of Ks band aperMag2 measurements
from all epochs in the pawprint set.

- ell - Mean Ks band ellipticity across all observations of this source in every
pawprint set.

- pm, epm, rapm, erapm, depm, edepm - Proper motions (total, in RAcosDec and Dec
respectively, errors are prefixed with 'e'). These are inverse variance weighted
averages across their measured values from all pawprint sets. Values given in
mas/yr.

- plx, eplx - Parallax, error on the parallax, given in mas. These are inverse
variance weighted averages across their measured values in both equatorial
tangent plane dimensions and from all pawprint sets.

- epochs - the total number of epochs across all pawprint sets used by the VIRAC
pipeline.

- dets - the number of separate pawprint sets/epoch groups (see pawprintdets) in
which the source was detected.

- stellardets - the number of pawprint sets in which the source had a stellar
modal morphological classification.

- pawprintdets - the number of separate pawprint sets in which a source was
detected. Technically 'dets' can be greater than this value where e.g. a high
proper motion or faint source is not matched between consecutive observing
seasons.

- [ZYJH]mag - VVV DR4 Z, Y, J, H photometry.

- e[ZYJH]mag - Error on VVV DR4 Z, Y, J, H photometry.

- [ZYJH]ell - Ellipticity of the DR4 Z, Y, J, H detection.

- [ZYJH]class - VVV DR4 Z, Y, J, H morphological classification.
  1 = galaxy
  0 = noise
  -1 = stellar
  -2 = probably stellar
  -3 = probable galaxy
  -7 = bad pixel within 2" aperture
  -9 = saturated

- VVV DR4 parameters are taken from tile stacks. Empty values indicate there was
no coverage of this field in VVV DR4. Where a source is otherwise not detected
in a band obviously false values are given (e.g. Zmag=99.999).

- VVV DR4 parameters are taken from the plxSource match to the pmSource table.