TABLE machoLMCSource

Contains the parameters provided in the MACHO Lightcurve Statistical Summary Table for each source in the LMC fields.

This table contains brief descriptions of the parameters provided for
each source in the catalogue of the LMC fields from MACHO. The table
contains comprehensive summary statistics that are provided for each
star's complete lightcurve, for each MACHO field in the LMC.

Required constraints:
Primary key is (seqNum)

Name Type Length Unit Description Default Value Unified Content Descriptor

id varchar 24 MACHO star identification (field.tile.seq)

seqNum int 4 Sequential number (unique object ID)

cx float 8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.x

cy float 8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.y

cz float 8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.z

htmID bigint 8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates pos.eq

ra float 8 degrees J2000 right ascension pos.eq.ra;meta.main

dec float 8 degrees J2000 declination pos.eq.dec;meta.main

npoints smallint 2 number of observations on the MACHO tile containing this star

rN smallint 2 red: number of good points on Lightcurve (LC)

rmagave real 4 red: median magnitude of LC in instrumental units

rerrave real 4 red: average error of measurements on LC in units of A, where A is the the measured flux divided by the median flux.

rsig real 4 red: sqrt of variance of A-1 measurements over LC.

rchi2w real 4 red: chi^2 per degree of freedom of fit to "constant flux" hypothesis weighted by flux errors

rqw real 4 red: probability of getting value as large as rchi2w by chance

rNr smallint 2 red: number of points on robustified LC

rerraver real 4 red: average error on robustified LC

rchi2r real 4 red: chi^2 per degree of freedom for robustified LC (variable star search)

rqr real 4 red: probability of getting value as large as rchi2r by chance

rs5 int 4 red: number of points on LC 5-sigma above median

rs5d int 4 red: number of points on LC 5-sigma below median (eclipsing binary search)

rmagaveu real 4 red: median magnitude in instrumental units before removing bad points

rdskyave real 4 red: average of red dsky sodophot measure

rdskysig real 4 red: sqrt of variance of red dsky sodophot measure

rpsfave real 4 red: average over LC of sodophot measure of goodness of psf fit

rpsfsig real 4 red: sqrt of variance of red psf sodophot measure

rcrdave real 4 red: average of crowding sodophot measure

rcosmave real 4 red: average of cosmic ray sodophot measure

rmissave real 4 red: average of missing pixel sodophot measure

bN smallint 2 blue: number of good points on Lightcurve (LC)

bmagave real 4 blue: median magnitude of LC in instrumental units

berrave real 4 blue: average error of measurements on LC in units of A, where A is the the measured flux divided by the median flux.

bsig real 4 blue: sqrt of variance of A-1 measurements over LC.

bchi2w real 4 blue: chi^2 per degree of freedom of fit to "constant flux" hypothesis weighted by flux errors

bqw real 4 blue: probability of getting value as large as rchi2w by chance

bNr int 4 blue: number of points on robustified LC

berraver real 4 blue: average error on robustified LC

bchi2r real 4 blue: chi^2 per degree of freedom for robustified LC (variable star search)

bqr real 4 blue: probability of getting value as large as rchi2r by chance

bs5 int 4 blue: number of points on LC 5-sigma above median

bs5d int 4 blue: number of points on LC 5-sigma below median (eclipsing binary search)

bmagaveu real 4 blue: median magnitude in instrumental units before removing bad points

bdskyave real 4 blue: average of blue dsky sodophot measure

bdskysig real 4 blue: sqrt of variance of blue dsky sodophot measure

bpsfave real 4 blue: average over LC of sodophot measure of goodness of psf fit

bpsfsig real 4 blue: sqrt of variance of blue psf sodophot measure

bcrdave real 4 blue: average of crowding sodophot measure

bcosmave real 4 blue: average of cosmic ray sodophot measure

bmissave real 4 blue: average of missing pixel sodophot measure

bmrN smallint 2 number of points on the B-R LC [aka simultaneous R/B pts]

bmrsig real 4 sqrt of variance of B-R LC

bmrchi2w real 4 chi^2 per degree of freedom for B-R LC

bmrave real 4 average of B-R

bmrprobspear real 4 B-R ?

rbcross real 4 red/blue A-1 robustified measurements over LC cross correlation coefficient [Welch-Stetson; see AJ 105, 1813]

rauto real 4 red: A-1 robustified measurements over LC autocorrelation (lag=0) coefficient

bauto real 4 blue: A-1 robustified measurements over LC autocorrelation (lag=0) coefficient

filterN smallint 2 number of filters applied; always 3

filter1_rfilmax real 4 Filter 1, red: max value of optimum filter for LC

filter1_rfiltime real 4 Filter 1, red: LC time at which maximum occurred

filter1_rNhi smallint 2 Filter 1, red: number points sigmathreshold high within duration of filter at peak (rfiltime)

filter1_bfilmax real 4 Filter 1, blue: max value of optimum filter for LC

filter1_bfiltime real 4 Filter 1, blue: LC time at which maximum occurred

filter1_bNhi smallint 2 Filter 1, blue: number points sigmathreshold high within duration of filter at peak (bfiltime)

filter2_rfilmax real 4 Filter 2, red: max value of optimum filter for LC

filter2_rfiltime real 4 Filter 2, red: LC time at which maximum occurred

filter2_rNhi smallint 2 Filter 2, red: number points sigmathreshold high within duration of filter at peak (rfiltime)

filter2_bfilmax real 4 Filter 2, blue: max value of optimum filter for LC

filter2_bfiltime real 4 Filter 2, blue: LC time at which maximum occurred

filter2_bNhi smallint 2 Filter 2, blue: number points sigmathreshold high within duration of filter at peak (bfiltime)

filter3_rfilmax real 4 Filter 3, red: max value of optimum filter for LC

filter3_rfiltime real 4 Filter 3, red: LC time at which maximum occurred

filter3_rNhi smallint 2 Filter 3, red: number points sigmathreshold high within duration of filter at peak (rfiltime)

filter3_bfilmax real 4 Filter 3, blue: max value of optimum filter for LC

filter3_bfiltime real 4 Filter 3, blue: LC time at which maximum occurred

filter3_bNhi smallint 2 Filter 3, blue: number points sigmathreshold high within duration of filter at peak (bfiltime)

Total length 324

Name	Type	Length	Unit	Description	Unified Content Descriptor
id	varchar	24		MACHO star identification (field.tile.seq)
seqNum	int	4		Sequential number (unique object ID)
cx	float	8		unit vector of spherical co-ordinates	pos.distance;pos.cartesian.x
cy	float	8		unit vector of spherical co-ordinates	pos.distance;pos.cartesian.y
cz	float	8		unit vector of spherical co-ordinates	pos.distance;pos.cartesian.z
htmID	bigint	8		Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates	pos.eq
ra	float	8	degrees	J2000 right ascension	pos.eq.ra;meta.main
dec	float	8	degrees	J2000 declination	pos.eq.dec;meta.main
npoints	smallint	2		number of observations on the MACHO tile containing this star
rN	smallint	2		red: number of good points on Lightcurve (LC)
rmagave	real	4		red: median magnitude of LC in instrumental units
rerrave	real	4		red: average error of measurements on LC in units of A, where A is the the measured flux divided by the median flux.
rsig	real	4		red: sqrt of variance of A-1 measurements over LC.
rchi2w	real	4		red: chi^2 per degree of freedom of fit to "constant flux" hypothesis weighted by flux errors
rqw	real	4		red: probability of getting value as large as rchi2w by chance
rNr	smallint	2		red: number of points on robustified LC
rerraver	real	4		red: average error on robustified LC
rchi2r	real	4		red: chi^2 per degree of freedom for robustified LC (variable star search)
rqr	real	4		red: probability of getting value as large as rchi2r by chance
rs5	int	4		red: number of points on LC 5-sigma above median
rs5d	int	4		red: number of points on LC 5-sigma below median (eclipsing binary search)
rmagaveu	real	4		red: median magnitude in instrumental units before removing bad points
rdskyave	real	4		red: average of red dsky sodophot measure
rdskysig	real	4		red: sqrt of variance of red dsky sodophot measure
rpsfave	real	4		red: average over LC of sodophot measure of goodness of psf fit
rpsfsig	real	4		red: sqrt of variance of red psf sodophot measure
rcrdave	real	4		red: average of crowding sodophot measure
rcosmave	real	4		red: average of cosmic ray sodophot measure
rmissave	real	4		red: average of missing pixel sodophot measure
bN	smallint	2		blue: number of good points on Lightcurve (LC)
bmagave	real	4		blue: median magnitude of LC in instrumental units
berrave	real	4		blue: average error of measurements on LC in units of A, where A is the the measured flux divided by the median flux.
bsig	real	4		blue: sqrt of variance of A-1 measurements over LC.
bchi2w	real	4		blue: chi^2 per degree of freedom of fit to "constant flux" hypothesis weighted by flux errors
bqw	real	4		blue: probability of getting value as large as rchi2w by chance
bNr	int	4		blue: number of points on robustified LC
berraver	real	4		blue: average error on robustified LC
bchi2r	real	4		blue: chi^2 per degree of freedom for robustified LC (variable star search)
bqr	real	4		blue: probability of getting value as large as rchi2r by chance
bs5	int	4		blue: number of points on LC 5-sigma above median
bs5d	int	4		blue: number of points on LC 5-sigma below median (eclipsing binary search)
bmagaveu	real	4		blue: median magnitude in instrumental units before removing bad points
bdskyave	real	4		blue: average of blue dsky sodophot measure
bdskysig	real	4		blue: sqrt of variance of blue dsky sodophot measure
bpsfave	real	4		blue: average over LC of sodophot measure of goodness of psf fit
bpsfsig	real	4		blue: sqrt of variance of blue psf sodophot measure
bcrdave	real	4		blue: average of crowding sodophot measure
bcosmave	real	4		blue: average of cosmic ray sodophot measure
bmissave	real	4		blue: average of missing pixel sodophot measure
bmrN	smallint	2		number of points on the B-R LC [aka simultaneous R/B pts]
bmrsig	real	4		sqrt of variance of B-R LC
bmrchi2w	real	4		chi^2 per degree of freedom for B-R LC
bmrave	real	4		average of B-R
bmrprobspear	real	4		B-R ?
rbcross	real	4		red/blue A-1 robustified measurements over LC cross correlation coefficient [Welch-Stetson; see AJ 105, 1813]
rauto	real	4		red: A-1 robustified measurements over LC autocorrelation (lag=0) coefficient
bauto	real	4		blue: A-1 robustified measurements over LC autocorrelation (lag=0) coefficient
filterN	smallint	2		number of filters applied; always 3
filter1_rfilmax	real	4		Filter 1, red: max value of optimum filter for LC
filter1_rfiltime	real	4		Filter 1, red: LC time at which maximum occurred
filter1_rNhi	smallint	2		Filter 1, red: number points sigmathreshold high within duration of filter at peak (rfiltime)
filter1_bfilmax	real	4		Filter 1, blue: max value of optimum filter for LC
filter1_bfiltime	real	4		Filter 1, blue: LC time at which maximum occurred
filter1_bNhi	smallint	2		Filter 1, blue: number points sigmathreshold high within duration of filter at peak (bfiltime)
filter2_rfilmax	real	4		Filter 2, red: max value of optimum filter for LC
filter2_rfiltime	real	4		Filter 2, red: LC time at which maximum occurred
filter2_rNhi	smallint	2		Filter 2, red: number points sigmathreshold high within duration of filter at peak (rfiltime)
filter2_bfilmax	real	4		Filter 2, blue: max value of optimum filter for LC
filter2_bfiltime	real	4		Filter 2, blue: LC time at which maximum occurred
filter2_bNhi	smallint	2		Filter 2, blue: number points sigmathreshold high within duration of filter at peak (bfiltime)
filter3_rfilmax	real	4		Filter 3, red: max value of optimum filter for LC
filter3_rfiltime	real	4		Filter 3, red: LC time at which maximum occurred
filter3_rNhi	smallint	2		Filter 3, red: number points sigmathreshold high within duration of filter at peak (rfiltime)
filter3_bfilmax	real	4		Filter 3, blue: max value of optimum filter for LC
filter3_bfiltime	real	4		Filter 3, blue: LC time at which maximum occurred
filter3_bNhi	smallint	2		Filter 3, blue: number points sigmathreshold high within duration of filter at peak (bfiltime)
Total length		324