Alert Production Database

The Alert Production Database (APDB) contains the catalogs resulting from image differencing during nightly Prompt Processing as well as the results of daily Solar System Processing.

metadata

Table containing various metadata key:value pairs for APDB.

Column Name	Data Type	Unit	Description	UCD	Index	Principal
name	text		Name or key for a metadata item.
value	text		Content of the metadata item in string representation.

DiaObject

The DiaObject table contains descriptions of the astronomical objects detected on one or more difference images.

Column Name	Data Type	Unit	Description	UCD
diaObjectId	long		Unique identifier of this DiaObject.	meta.id;src
validityStart	timestamp		Processing time when validity of this diaObject starts.
validityEnd	timestamp		Processing time when validity of this diaObject ends.
ra	double	deg	Right ascension coordinate of the position of the object at time radecMjdTai.	pos.eq.ra
raErr	float	deg	Uncertainty of ra.	stat.error;pos.eq.ra
dec	double	deg	Declination coordinate of the position of the object at time radecMjdTai.	pos.eq.dec
decErr	float	deg	Uncertainty of dec.	stat.error;pos.eq.dec
ra_dec_Cov	float	deg**2	Covariance between ra and dec.
radecMjdTai	double		Time at which the object was at a position ra/dec, expressed as Modified Julian Date, International Atomic Time.	time.epoch
pmRa	float	mas/yr	Proper motion in right ascension.	pos.pm
pmRaErr	float	mas/yr	Uncertainty of pmRa.	stat.error;pos.pm
pmDec	float	mas/yr	Proper motion of declination.	pos.pm
pmDecErr	float	mas/yr	Uncertainty of pmDec.	stat.error;pos.pm
parallax	float	mas	Parallax.	pos.parallax
parallaxErr	float	mas	Uncertainty of parallax.	stat.error;pos.parallax
pmRa_pmDec_Cov	float	mas2/yr2	Covariance of pmRa and pmDec.	stat.covariance;pos.eq
pmRa_parallax_Cov	float	mas**2/yr	Covariance of pmRa and parallax.	stat.covariance
pmDec_parallax_Cov	float	mas**2/yr	Covariance of pmDec and parallax.	stat.covariance
pmParallaxLnL	float		Natural log of the likelihood of the linear proper motion parallax fit.	stat.likelihood
pmParallaxChi2	float		Chi^2 static of the model fit.	stat.fit.chi2
pmParallaxNdata	int		The number of data points used to fit the model.
u_psfFluxMean	float	nJy	Weighted mean point-source model magnitude for u filter.	phot.count
u_psfFluxMeanErr	float	nJy	Standard error of u_psfFluxMean.	stat.error
u_psfFluxSigma	float	nJy	Standard deviation of the distribution of u_psfFlux.	stat.stdev
u_psfFluxChi2	float		Chi^2 statistic for the scatter of u_psfFlux around u_psfFluxMean.	stat.fit.chi2
u_psfFluxNdata	int		The number of data points used to compute u_psfFluxChi2.
u_fpFluxMean	float	nJy	Weighted mean forced photometry flux for u filter.	phot.count
u_fpFluxMeanErr	float	nJy	Standard error of u_fpFluxMean.	stat.error
u_fpFluxSigma	float	nJy	Standard deviation of the distribution of u_fpFlux.	stat.stdev
g_psfFluxMean	float	nJy	Weighted mean point-source model magnitude for g filter.	phot.count
g_psfFluxMeanErr	float	nJy	Standard error of g_psfFluxMean.	stat.error
g_psfFluxSigma	float	nJy	Standard deviation of the distribution of g_psfFlux.	stat.stdev
g_psfFluxChi2	float		Chi^2 statistic for the scatter of g_psfFlux around g_psfFluxMean.	stat.fit.chi2
g_psfFluxNdata	int		The number of data points used to compute g_psfFluxChi2.
g_fpFluxMean	float	nJy	Weighted mean forced photometry flux for g filter.	phot.count
g_fpFluxMeanErr	float	nJy	Standard error of g_fpFluxMean.	stat.error
g_fpFluxSigma	float	nJy	Standard deviation of the distribution of g_fpFlux.	stat.stdev
r_psfFluxMean	float	nJy	Weighted mean point-source model magnitude for r filter.	phot.count
r_psfFluxMeanErr	float	nJy	Standard error of r_psfFluxMean.	stat.error
r_psfFluxSigma	float	nJy	Standard deviation of the distribution of r_psfFlux.	stat.stdev
r_psfFluxChi2	float		Chi^2 statistic for the scatter of r_psfFlux around r_psfFluxMean.	stat.fit.chi2
r_psfFluxNdata	int		The number of data points used to compute r_psfFluxChi2.
r_fpFluxMean	float	nJy	Weighted mean forced photometry flux for r filter.	phot.count
r_fpFluxMeanErr	float	nJy	Standard error of r_fpFluxMean.	stat.error
r_fpFluxSigma	float	nJy	Standard deviation of the distribution of r_fpFlux.	stat.stdev
i_psfFluxMean	float	nJy	Weighted mean point-source model magnitude for i filter.	phot.count
i_psfFluxMeanErr	float	nJy	Standard error of i_psfFluxMean.	stat.error
i_psfFluxSigma	float	nJy	Standard deviation of the distribution of i_psfFlux.	stat.stdev
i_psfFluxChi2	float		Chi^2 statistic for the scatter of i_psfFlux around i_psfFluxMean.	stat.fit.chi2
i_psfFluxNdata	int		The number of data points used to compute i_psfFluxChi2.
i_fpFluxMean	float	nJy	Weighted mean forced photometry flux for i filter.	phot.count
i_fpFluxMeanErr	float	nJy	Standard error of i_fpFluxMean.	stat.error
i_fpFluxSigma	float	nJy	Standard deviation of the distribution of i_fpFlux.	stat.stdev
z_psfFluxMean	float	nJy	Weighted mean point-source model magnitude for z filter.	phot.count
z_psfFluxMeanErr	float	nJy	Standard error of z_psfFluxMean.	stat.error
z_psfFluxSigma	float	nJy	Standard deviation of the distribution of z_psfFlux.	stat.stdev
z_psfFluxChi2	float		Chi^2 statistic for the scatter of z_psfFlux around z_psfFluxMean.	stat.fit.chi2
z_psfFluxNdata	int		The number of data points used to compute z_psfFluxChi2.
z_fpFluxMean	float	nJy	Weighted mean forced photometry flux for z filter.	phot.count
z_fpFluxMeanErr	float	nJy	Standard error of z_fpFluxMean.	stat.error
z_fpFluxSigma	float	nJy	Standard deviation of the distribution of z_fpFlux.	stat.stdev
y_psfFluxMean	float	nJy	Weighted mean point-source model magnitude for y filter.	phot.count
y_psfFluxMeanErr	float	nJy	Standard error of y_psfFluxMean.	stat.error
y_psfFluxSigma	float	nJy	Standard deviation of the distribution of y_psfFlux.	stat.error
y_psfFluxChi2	float		Chi^2 statistic for the scatter of y_psfFlux around y_psfFluxMean.	stat.fit.chi2
y_psfFluxNdata	int		The number of data points used to compute y_psfFluxChi2.
y_fpFluxMean	float	nJy	Weighted mean forced photometry flux for y filter.	phot.count
y_fpFluxMeanErr	float	nJy	Standard error of y_fpFluxMean.	stat.error
y_fpFluxSigma	float	nJy	Standard deviation of the distribution of y_fpFlux.	stat.stdev
nearbyObj1	long		Id of the closest nearby object.	meta.id;src
nearbyObj1Dist	float	arcsec	Distance to nearbyObj1.
nearbyObj1LnP	float		Natural log of the probability that the observed diaObject is the same as the nearbyObj1.
nearbyObj2	long		Id of the second-closest nearby object.	meta.id;src
nearbyObj2Dist	float	arcsec	Distance to nearbyObj2.
nearbyObj2LnP	float		Natural log of the probability that the observed diaObject is the same as the nearbyObj2.
nearbyObj3	long		Id of the third-closest nearby object.	meta.id;src
nearbyObj3Dist	float	arcsec	Distance to nearbyObj3.
nearbyObj3LnP	float		Natural log of the probability that the observed diaObject is the same as the nearbyObj3.
nearbyExtObj1	long		Id of the closest extended DR Object by second moment-based separation.	meta.id;src
nearbyExtObj1Sep	float		Second moment-based separation of nearbyExtObj1 (unitless).
nearbyExtObj2	long		Id of the second closest extended DR Object by second moment-based separation.	meta.id;src
nearbyExtObj2Sep	float		Second moment-based separation of nearbyExtObj2 (unitless).
nearbyExtObj3	long		Id of the third closest extended DR Object by second moment-based separation.	meta.id;src
nearbyExtObj3Sep	float		Second moment-based separation of nearbyExtObj3 (unitless).
nearbyLowzGal	string		External catalog name of the nearest low-z potential host.
nearbyLowzGalSep	float	arcsec	Separation distance of nearbyLowzGal.
u_scienceFluxMean	float	nJy	Weighted mean forced photometry flux for u filter.	phot.count
u_scienceFluxMeanErr	float	nJy	Standard error of u_scienceFluxMean.	stat.error
u_scienceFluxSigma	float	nJy	Standard deviation of the distribution of u_scienceFlux.	stat.stdev
g_scienceFluxMean	float	nJy	Weighted mean forced photometry flux for g filter.	phot.count
g_scienceFluxMeanErr	float	nJy	Standard error of g_scienceFluxMean.	stat.error
g_scienceFluxSigma	float	nJy	Standard deviation of the distribution of g_scienceFlux.	stat.stdev
r_scienceFluxMean	float	nJy	Weighted mean forced photometry flux for r filter.	phot.count
r_scienceFluxMeanErr	float	nJy	Standard error of r_scienceFluxMean.	stat.error
r_scienceFluxSigma	float	nJy	Standard deviation of the distribution of r_scienceFlux.	stat.stdev
i_scienceFluxMean	float	nJy	Weighted mean forced photometry flux for i filter.	phot.count
i_scienceFluxMeanErr	float	nJy	Standard error of i_scienceFluxMean.	stat.error
i_scienceFluxSigma	float	nJy	Standard deviation of the distribution of i_scienceFlux.	stat.stdev
z_scienceFluxMean	float	nJy	Weighted mean forced photometry flux for z filter.	phot.count
z_scienceFluxMeanErr	float	nJy	Standard error of z_scienceFluxMean.	stat.error
z_scienceFluxSigma	float	nJy	Standard deviation of the distribution of z_scienceFlux.	stat.stdev
y_scienceFluxMean	float	nJy	Weighted mean forced photometry flux for y filter.	phot.count
y_scienceFluxMeanErr	float	nJy	Standard error of y_scienceFluxMean.	stat.error
y_scienceFluxSigma	float	nJy	Standard deviation of the distribution of y_scienceFlux.	stat.stdev
u_psfFluxMAD	float	nJy	Median absolute deviation u band fluxes.
u_psfFluxSkew	float		Skewness of the u band fluxes.
u_psfFluxPercentile05	float	nJy	Value at the 5% percentile of the u band fluxes.
u_psfFluxPercentile25	float	nJy	Value at the 25% percentile of the u band fluxes.
u_psfFluxPercentile50	float	nJy	Value at the 50% percentile (median) of the u band fluxes.
u_psfFluxPercentile75	float	nJy	Value at the 75% percentile of the u band fluxes.
u_psfFluxPercentile95	float	nJy	Value at the 95% percentile of the u band fluxes.
u_psfFluxMin	float	nJy	Minimum observed u band fluxes.
u_psfFluxMax	float	nJy	Maximum observed u band fluxes.
u_psfFluxStetsonJ	float		StetsonJ statistic for the u band fluxes.
u_psfFluxLinearSlope	float	nJy/d	Linear best fit slope of the u band fluxes.
u_psfFluxLinearIntercept	float		Linear best fit Intercept of the u band fluxes.
u_psfFluxMaxSlope	float	nJy/d	Maximum slope between u band flux obsevations max(delta_flux/delta_time).
u_psfFluxErrMean	float	nJy	Mean of the u band flux errors.
g_psfFluxMAD	float	nJy	Median absolute deviation g band fluxes.
g_psfFluxSkew	float		Skewness of the g band fluxes.
g_psfFluxPercentile05	float	nJy	Value at the 5% percentile of the g band fluxes.
g_psfFluxPercentile25	float	nJy	Value at the 25% percentile of the g band fluxes.
g_psfFluxPercentile50	float	nJy	Value at the 50% percentile (median) of the g band fluxes.
g_psfFluxPercentile75	float	nJy	Value at the 75% percentile of the g band fluxes.
g_psfFluxPercentile95	float	nJy	Value at the 95% percentile of the g band fluxes.
g_psfFluxMin	float	nJy	Minimum observed g band fluxes.
g_psfFluxMax	float	nJy	Maximum observed g band fluxes.
g_psfFluxStetsonJ	float		StetsonJ statistic for the g band fluxes.
g_psfFluxLinearSlope	float	nJy/d	Linear best fit slope of the g band fluxes.
g_psfFluxLinearIntercept	float	nJy	Linear best fit Intercept of the g band fluxes.
g_psfFluxMaxSlope	float	nJy/d	Maximum slope between g band flux obsevations max(delta_flux/delta_time).
g_psfFluxErrMean	float	nJy	Mean of the g band flux errors.
r_psfFluxMAD	float	nJy	Median absolute deviation r band fluxes.
r_psfFluxSkew	float		Skewness of the r band fluxes.
r_psfFluxPercentile05	float	nJy	Value at the 5% percentile of the r band fluxes.
r_psfFluxPercentile25	float	nJy	Value at the 25% percentile of the r band fluxes.
r_psfFluxPercentile50	float	nJy	Value at the 50% percentile (median) of the r band fluxes.
r_psfFluxPercentile75	float	nJy	Value at the 75% percentile of the r band fluxes.
r_psfFluxPercentile95	float	nJy	Value at the 95% percentile of the r band fluxes.
r_psfFluxMin	float	nJy	Minimum observed r band fluxes.
r_psfFluxMax	float	nJy	Maximum observed r band fluxes.
r_psfFluxStetsonJ	float		StetsonJ statistic for the r band fluxes.
r_psfFluxLinearSlope	float	nJy/d	Linear best fit slope of the r band fluxes.
r_psfFluxLinearIntercept	float	nJy	Linear best fit Intercept of the r band fluxes.
r_psfFluxMaxSlope	float	nJy/d	Maximum slope between r band flux obsevations max(delta_flux/delta_time).
r_psfFluxErrMean	float	nJy	Mean of the r band flux errors.
i_psfFluxMAD	float	nJy	Median absolute deviation i band fluxes.
i_psfFluxSkew	float		Skewness of the i band fluxes.
i_psfFluxPercentile05	float	nJy	Value at the 5% percentile of the i band fluxes.
i_psfFluxPercentile25	float	nJy	Value at the 25% percentile of the i band fluxes.
i_psfFluxPercentile50	float	nJy	Value at the 50% percentile (median) of the i band fluxes.
i_psfFluxPercentile75	float	nJy	Value at the 75% percentile of the i band fluxes.
i_psfFluxPercentile95	float	nJy	Value at the 95% percentile of the i band fluxes.
i_psfFluxMin	float	nJy	Minimum observed i band fluxes.
i_psfFluxMax	float	nJy	Maximum observed i band fluxes.
i_psfFluxStetsonJ	float		StetsonJ statistic for the i band fluxes.
i_psfFluxLinearSlope	float	nJy/d	Linear best fit slope of the i band fluxes.
i_psfFluxLinearIntercept	float	nJy	Linear best fit Intercept of the i band fluxes.
i_psfFluxMaxSlope	float	nJy/d	Maximum slope between i band flux obsevations max(delta_flux/delta_time).
i_psfFluxErrMean	float	nJy	Mean of the i band flux errors.
z_psfFluxMAD	float	nJy	Median absolute deviation z band fluxes.
z_psfFluxSkew	float		Skewness of the z band fluxes.
z_psfFluxPercentile05	float	nJy	Value at the 5% percentile of the z band fluxes.
z_psfFluxPercentile25	float	nJy	Value at the 25% percentile of the z band fluxes.
z_psfFluxPercentile50	float	nJy	Value at the 50% percentile (median) of the z band fluxes.
z_psfFluxPercentile75	float	nJy	Value at the 75% percentile of the z band fluxes.
z_psfFluxPercentile95	float	nJy	Value at the 95% percentile of the z band fluxes.
z_psfFluxMin	float	nJy	Minimum observed z band fluxes.
z_psfFluxMax	float	nJy	Maximum observed z band fluxes.
z_psfFluxStetsonJ	float		StetsonJ statistic for the z band fluxes.
z_psfFluxLinearSlope	float	nJy/d	Linear best fit slope of the z band fluxes.
z_psfFluxLinearIntercept	float	nJy	Linear best fit Intercept of the z band fluxes.
z_psfFluxMaxSlope	float	nJy/d	Maximum slope between z band flux obsevations max(delta_flux/delta_time).
z_psfFluxErrMean	float	nJy	Mean of the z band flux errors.
y_psfFluxMAD	float	nJy	Median absolute deviation y band fluxes.
y_psfFluxSkew	float		Skewness of the y band fluxes.
y_psfFluxPercentile05	float	nJy	Value at the 5% percentile of the y band fluxes.
y_psfFluxPercentile25	float	nJy	Value at the 25% percentile of the y band fluxes.
y_psfFluxPercentile50	float	nJy	Value at the 50% percentile (median) of the y band fluxes.
y_psfFluxPercentile75	float	nJy	Value at the 75% percentile of the y band fluxes.
y_psfFluxPercentile95	float	nJy	Value at the 95% percentile of the y band fluxes.
y_psfFluxMin	float	nJy	Minimum observed y band fluxes.
y_psfFluxMax	float	nJy	Maximum observed y band fluxes.
y_psfFluxStetsonJ	float		StetsonJ statistic for the y band fluxes.
y_psfFluxLinearSlope	float	nJy/d	Linear best fit slope of the y band fluxes.
y_psfFluxLinearIntercept	float	nJy	Linear best fit Intercept of the y band fluxes.
y_psfFluxMaxSlope	float	nJy/d	Maximum slope between y band flux obsevations max(delta_flux/delta_time)
y_psfFluxErrMean	float	nJy	Mean of the y band flux errors.
lastNonForcedSource	timestamp		Last time when non-forced DIASource was seen for this object.
nDiaSources	int		Total number of DiaSources associated with this DiaObject.

SSObject

LSST-computed per-object quantities. 1:1 relationship with MPCORB. Recomputed daily, upon MPCORB ingestion.

Column Name	Data Type	Unit	Description	UCD
ssObjectId	long		Unique identifier.	meta.id;src
discoverySubmissionDate	double	d	The date the LSST first linked and submitted the discovery observations to the MPC. May be NULL if not an LSST discovery. The date format will follow general LSST conventions (MJD TAI, at the moment).
firstObservationDate	double	d	The time of the first LSST observation of this object (could be precovered) as Modified Julian Date, International Atomic Time.
arc	float	d	Arc of LSST observations.
numObs	int		Number of LSST observations of this object.
lcPeriodic	binary		Periodic light curve features computed on phase/distance-corrected magnitudes (H), 6x32 floats.
MOID	float	AU	Minimum orbit intersection distance to Earth.
MOIDTrueAnomaly	float	deg	True anomaly of the MOID point.
MOIDEclipticLongitude	float	deg	Ecliptic longitude of the MOID point.
MOIDDeltaV	float	km/s	DeltaV at the MOID point.
u_H	float	mag	Best fit absolute magnitude (u band).
u_G12	float	mag	Best fit G12 slope parameter (u band).
u_HErr	float	mag	Uncertainty of H (u band).	stat.error
u_G12Err	float	mag	Uncertainty of G12 (u band).	stat.error
u_H_u_G12_Cov	float	mag**2	H-G12 covariance (u band).	stat.covariance
u_Chi2	float		Chi^2 statistic of the phase curve fit (u band).	stat.fit.chi2
u_Ndata	int		The number of data points used to fit the phase curve (u band).
g_H	float	mag	Best fit absolute magnitude (g band).
g_G12	float	mag	Best fit G12 slope parameter (g band).
g_HErr	float	mag	Uncertainty of H (g band).	stat.error
g_G12Err	float	mag	Uncertainty of G12 (g band).	stat.error
g_H_g_G12_Cov	float	mag**2	H-G12 covariance (g band).	stat.covariance
g_Chi2	float		Chi^2 statistic of the phase curve fit (g band).	stat.fit.chi2
g_Ndata	int		The number of data points used to fit the phase curve (g band).
r_H	float	mag	Best fit absolute magnitude (r band).
r_G12	float	mag	Best fit G12 slope parameter (r band).
r_HErr	float	mag	Uncertainty of H (r band).	stat.error
r_G12Err	float	mag	Uncertainty of G12 (r band).	stat.error
r_H_r_G12_Cov	float	mag**2	H-G12 covariance (r band).	stat.covariance
r_Chi2	float		Chi^2 statistic of the phase curve fit (r band).	stat.fit.chi2
r_Ndata	int		The number of data points used to fit the phase curve (r band).
i_H	float	mag	Best fit absolute magnitude (i band).
i_G12	float	mag	Best fit G12 slope parameter (i band).
i_HErr	float	mag	Uncertainty of H (i band).	stat.error
i_G12Err	float	mag	Uncertainty of G12 (i band).	stat.error
i_H_i_G12_Cov	float	mag**2	H-G12 covariance (i band).	stat.covariance
i_Chi2	float		Chi^2 statistic of the phase curve fit (i band).	stat.fit.chi2
i_Ndata	int		The number of data points used to fit the phase curve (i band).
z_H	float	mag	Best fit absolute magnitude (z band).
z_G12	float	mag	Best fit G12 slope parameter (z band).
z_HErr	float	mag	Uncertainty of H (z band).	stat.error
z_G12Err	float	mag	Uncertainty of G12 (z band).	stat.error
z_H_z_G12_Cov	float	mag**2	H-G12 covariance (z band).	stat.covariance
z_Chi2	float		Chi^2 statistic of the phase curve fit (z band).	stat.fit.chi2
z_Ndata	int		The number of data points used to fit the phase curve (z band).
y_H	float	mag	Best fit absolute magnitude (y band).
y_G12	float	mag	Best fit G12 slope parameter (y band).
y_HErr	float	mag	Uncertainty of H (y band).	stat.error
y_G12Err	float	mag	Uncertainty of G12 (y band).	stat.error
y_H_y_G12_Cov	float	mag**2	H-G12 covariance (y band).	stat.covariance
y_Chi2	float		Chi^2 statistic of the phase curve fit (y band).	stat.fit.chi2
y_Ndata	int		The number of data points used to fit the phase curve (y band).
maxExtendedness	float		maximum `extendedness` value from the DIASource.
minExtendedness	float		minimum `extendedness` value from the DIASource.
medianExtendedness	float		median `extendedness` value from the DIASource.

DiaSource

Table to store 'difference image sources'; - sources detected at SNR >=5 on difference images.

Column Name	Data Type	Unit	Description	UCD
diaSourceId	long		Unique identifier of this DiaSource.	meta.id;obs.image
visit	long		Id of the visit where this diaSource was measured.	meta.id;obs.image
detector	short		Id of the detector where this diaSource was measured. Datatype short instead of byte because of DB concerns about unsigned bytes.	meta.id;obs.image
diaObjectId	long		Id of the diaObject this source was associated with, if any. If not, it is set to NULL (each diaSource will be associated with either a diaObject or ssObject).	meta.id;src
ssObjectId	long		Id of the ssObject this source was associated with, if any. If not, it is set to NULL (each diaSource will be associated with either a diaObject or ssObject).	meta.id;src
parentDiaSourceId	long		Id of the parent diaSource this diaSource has been deblended from, if any.	meta.id;src
ssObjectReassocTime	timestamp		Time when this diaSource was reassociated from diaObject to ssObject (if such reassociation happens, otherwise NULL).
midpointMjdTai	double	d	Effective mid-visit time for this diaSource, expressed as Modified Julian Date, International Atomic Time.	time.epoch
ra	double	deg	Right ascension coordinate of the center of this diaSource.	pos.eq.ra
raErr	float	deg	Uncertainty of ra.	stat.error;pos.eq.ra
dec	double	deg	Declination coordinate of the center of this diaSource.	pos.eq.dec
decErr	float	deg	Uncertainty of dec.	stat.error;pos.eq.dec
ra_dec_Cov	float	deg**2	Covariance between ra and dec.	stat.covariance
x	float	pixel	x position computed by a centroiding algorithm.	pos.cartesian.x
xErr	float	pixel	Uncertainty of x.	stat.error;pos.cartesian.x
y	float	pixel	y position computed by a centroiding algorithm.	pos.cartesian.y
yErr	float	pixel	Uncertainty of y.	stat.error;pos.cartesian.y
x_y_Cov	float	pixel**2	Covariance between x and y.	stat.covariance
centroid_flag	boolean		General centroid algorithm failure flag; set if anything went wrong when fitting the centroid. Another centroid flag field should also be set to provide more information.
apFlux	float	nJy	Flux in a 12 pixel radius aperture on the difference image.	phot.count
apFluxErr	float	nJy	Estimated uncertainty of apFlux.	stat.error;phot.count
apFlux_flag	boolean		General aperture flux algorithm failure flag; set if anything went wrong when measuring aperture fluxes. Another apFlux flag field should also be set to provide more information.
apFlux_flag_apertureTruncated	boolean		Aperture did not fit within measurement image.
snr	float		The signal-to-noise ratio at which this source was detected in the difference image.	stat.snr
psfFlux	float	nJy	Flux for Point Source model. Note this actually measures the flux difference between the template and the visit image.	phot.count
psfFluxErr	float	nJy	Uncertainty of psfFlux.
psfRa	double	deg	Right ascension coordinate of centroid for point source model.	pos.eq.ra
psfRaErr	float	deg	Uncertainty of psfRa.	stat.error;pos.eq.ra
psfDec	double	deg	Declination coordinate of centroid for point source model.	pos.eq.dec
psfDecErr	float	deg	Uncertainty of psfDec.	stat.error;pos.eq.dec
psfFlux_psfRa_Cov	float	nJy.deg	Covariance between psfFlux and psfRa.	stat.covariance
psfFlux_psfDec_Cov	float	nJy.deg	Covariance between psfFlux and psfDec.	stat.covariance
psfRa_psfDec_Cov	float	deg**2	Covariance between psfRa and psfDec.	stat.covariance
psfLnL	float		Natural log likelihood of the observed data given the point source model.	stat.likelihood
psfChi2	float		Chi^2 statistic of the point source model fit.	stat.fit.chi2
psfNdata	int		The number of data points (pixels) used to fit the point source model.
psfFlux_flag	boolean		Failure to derive linear least-squares fit of psf model. Another psfFlux flag field should also be set to provide more information.
psfFlux_flag_edge	boolean		Object was too close to the edge of the image to use the full PSF model.
psfFlux_flag_noGoodPixels	boolean		Not enough non-rejected pixels in data to attempt the fit.
trailFlux	float	nJy	Flux for a trailed source model. Note this actually measures the flux difference between the template and the visit image.
trailFluxErr	float	nJy	Uncertainty of trailFlux.
trailRa	double	deg	Right ascension coordinate of centroid for trailed source model.	pos.eq.ra
trailRaErr	float	deg	Uncertainty of trailRa.	stat.error;pos.eq.ra
trailDec	double	deg	Declination coordinate of centroid for trailed source model.	pos.eq.dec
trailDecErr	float	deg	Uncertainty of trailDec.	stat.error;pos.eq.dec
trailLength	float	arcsec	Maximum likelihood fit of trail length.
trailLengthErr	float	nJy	Uncertainty of trailLength.
trailAngle	float	deg	Maximum likelihood fit of the angle between the meridian through the centroid and the trail direction (bearing).
trailAngleErr	float	nJy	Uncertainty of trailAngle.
trailFlux_trailRa_Cov	float		Covariance of trailFlux and trailRa.	stat.covariance
trailFlux_trailDec_Cov	float		Covariance of trailFlux and trailDec.	stat.covariance
trailFlux_trailLength_Cov	float		Covariance of trailFlux and trailLength	stat.covariance
trailFlux_trailAngle_Cov	float		Covariance of trailFlux and trailAngle	stat.covariance
trailRa_trailDec_Cov	float		Covariance of trailRa and trailDec.	stat.covariance
trailRa_trailLength_Cov	float		Covariance of trailRa and trailLength.	stat.covariance
trailRa_trailAngle_Cov	float		Covariance of trailRa and trailAngle.	stat.covariance
trailDec_trailLength_Cov	float		Covariance of trailDec and trailLength.	stat.covariance
trailDec_trailAngle_Cov	float		Covariance of trailDec and trailAngle.	stat.covariance
trailLength_trailAngle_Cov	float		Covariance of trailLength and trailAngle	stat.covariance
trailLnL	float		Natural log likelihood of the observed data given the trailed source model.	stat.likelihood
trailChi2	float		Chi^2 statistic of the trailed source model fit.	stat.fit.chi2
trailNdata	int		The number of data points (pixels) used to fit the trailed source model.
trail_flag_edge	boolean		This flag is set if a trailed source extends onto or past edge pixels.
dipoleMeanFlux	float	nJy	Maximum likelihood value for the mean absolute flux of the two lobes for a dipole model.
dipoleMeanFluxErr	float	nJy	Uncertainty of dipoleMeanFlux.	stat.error
dipoleFluxDiff	float	nJy	Maximum likelihood value for the difference of absolute fluxes of the two lobes for a dipole model.
dipoleFluxDiffErr	float	nJy	Uncertainty of dipoleFluxDiff.	stat.error
dipoleRa	double	deg	Right ascension coordinate of centroid for dipole model.	pos.eq.ra
dipoleRaErr	float	deg	Uncertainty of dipoleRa.	stat.error;pos.eq.ra
dipoleDec	double	deg	Declination coordinate of centroid for dipole model.	pos.eq.dec
dipoleDecErr	float	deg	Uncertainty of dipoleDec.	stat.error;pos.eq.dec
dipoleLength	float	arcsec	Maximum likelihood value for the lobe separation in dipole model.	pos.angDistance
dipoleLengthErr	float	arcsec	Uncertainty of dipoleLength.	stat.error;pos.angDistance
dipoleAngle	float	deg	Maximum likelihood fit of the angle between the meridian through the centroid and the dipole direction (bearing, from negative to positive lobe).	pos.posAng
dipoleAngleErr	float	deg	Uncertainty of dipoleAngle.	stat.error;pos.posAng
dipoleMeanFlux_dipoleFluxDiff_Cov	float		Covariance of dipoleMeanFlux and dipoleFluxDiff.	stat.covariance
dipoleMeanFlux_dipoleRa_Cov	float		Covariance of dipoleMeanFlux and dipoleRa.	stat.covariance
dipoleMeanFlux_dipoleDec_Cov	float		Covariance of dipoleMeanFlux and dipoleDec.	stat.covariance
dipoleMeanFlux_dipoleLength_Cov	float		Covariance of dipoleMeanFlux and dipoleLength.	stat.covariance
dipoleMeanFlux_dipoleAngle_Cov	float		Covariance of dipoleMeanFlux and dipoleAngle.	stat.covariance
dipoleFluxDiff_dipoleRa_Cov	float		Covariance of dipoleFluxDiff and dipoleRa.	stat.covariance
dipoleFluxDiff_dipoleDec_Cov	float		Covariance of dipoleFluxDiff and dipoleDec.	stat.covariance
dipoleFluxDiff_dipoleLength_Cov	float		Covariance of dipoleFluxDiff and dipoleLength.	stat.covariance
dipoleFluxDiff_dipoleAngle_Cov	float		Covariance of dipoleFluxDiff and dipoleAngle.	stat.covariance
dipoleRa_dipoleDec_Cov	float		Covariance of dipoleRa and dipoleDec.	stat.covariance
dipoleRa_dipoleLength_Cov	float		Covariance of dipoleRa and dipoleLength.	stat.covariance
dipoleRa_dipoleAngle_Cov	float		Covariance of dipoleRa and dipoleAngle.	stat.covariance
dipoleDec_dipoleLength_Cov	float		Covariance of dipoleDec and dipoleLength.	stat.covariance
dipoleDec_dipoleAngle_Cov	float		Covariance of dipoleDec and dipoleAngle.	stat.covariance
dipoleLength_dipoleAngle_Cov	float		Covariance of dipoleLength and dipoleAngle.	stat.covariance
dipoleLnL	float		Natural log likelihood of the observed data given the dipole source model.	stat.likelihood
dipoleChi2	float		Chi^2 statistic of the model fit.	stat.fit.chi2
dipoleNdata	int		The number of data points (pixels) used to fit the model.
scienceFlux	float	nJy	Forced photometry flux for a point source model measured on the visit image centered at DiaSource position.	phot.count
scienceFluxErr	float	nJy	Estimated uncertainty of scienceFlux.	stat.error;phot.count
forced_PsfFlux_flag	boolean		Forced PSF photometry on science image failed. Another forced_PsfFlux flag field should also be set to provide more information.
forced_PsfFlux_flag_edge	boolean		Forced PSF flux on science image was too close to the edge of the image to use the full PSF model.
forced_PsfFlux_flag_noGoodPixels	boolean		Forced PSF flux not enough non-rejected pixels in data to attempt the fit.
snapDiffFlux	float	nJy	Calibrated flux for Point Source model centered on radec but measured on the difference of snaps comprising this visit.
snapDiffFluxErr	float	nJy	Estimated uncertainty of snapDiffFlux.	stat.error;phot.count
fpBkgd	float	nJy/arcsec**2	Estimated sky background at the position (centroid) of the object.
fpBkgdErr	float	nJy/arcsec**2	Estimated uncertainty of fpBkgd.
ixx	float	nJy.arcsec**2	Adaptive second moment of the source intensity.
ixxErr	float	nJy.arcsec**2	Uncertainty of ixx.	stat.error
iyy	float	nJy.arcsec**2	Adaptive second moment of the source intensity.
iyyErr	float	nJy.arcsec**2	Uncertainty of iyy.	stat.error
ixy	float	nJy.arcsec**2	Adaptive second moment of the source intensity.
ixyErr	float	nJy.arcsec**2	Uncertainty of ixy.	stat.error
ixx_iyy_Cov	float	nJy2.arcsec4	Covariance of ixx and iyy.
ixx_ixy_Cov	float	nJy2.arcsec4	Covariance of ixx and ixy.
iyy_ixy_Cov	float	nJy2.arcsec4	Covariance of iyy and ixy.
ixxPSF	float	nJy.arcsec**2	Adaptive second moment for the PSF.
iyyPSF	float	nJy.arcsec**2	Adaptive second moment for the PSF.
ixyPSF	float	nJy.arcsec**2	Adaptive second moment for the PSF.
shape_flag	boolean		General source shape algorithm failure flag; set if anything went wrong when measuring the shape. Another shape flag field should also be set to provide more information.
shape_flag_no_pixels	boolean		No pixels to measure shape.
shape_flag_not_contained	boolean		Center not contained in footprint bounding box.
shape_flag_parent_source	boolean		This source is a parent source; we should only be measuring on deblended children in difference imaging.
extendedness	float		A measure of extendedness, computed by comparing an object's moment-based traced radius to the PSF moments. extendedness = 1 implies a high degree of confidence that the source is extended. extendedness = 0 implies a high degree of confidence that the source is point-like.
reliability	float		A measure of reliability, computed using information from the source and image characterization, as well as the information on the Telescope and Camera system (e.g., ghost maps, defect maps, etc.).
band	char		Filter band this source was observed with.
isDipole	boolean		Object determined to be a dipole.
time_processed	timestamp		Time when the image was processed and this DiaSource record was generated.
time_withdrawn	timestamp		Time when this record was marked invalid.
bboxSize	long
pixelFlags	boolean		General pixel flags failure; set if anything went wrong when setting pixels flags from this footprint's mask. This implies that some pixelFlags for this source may be incorrectly set to False.
pixelFlags_bad	boolean		Bad pixel in the DiaSource footprint.
pixelFlags_cr	boolean		Cosmic ray in the DiaSource footprint.
pixelFlags_crCenter	boolean		Cosmic ray in the 3x3 region around the centroid.
pixelFlags_edge	boolean		Some of the source footprint is outside usable exposure region (masked EDGE or NO_DATA, or centroid off image).
pixelFlags_interpolated	boolean		Interpolated pixel in the DiaSource footprint.
pixelFlags_interpolatedCenter	boolean		Interpolated pixel in the 3x3 region around the centroid.
pixelFlags_offimage	boolean		DiaSource center is off image.
pixelFlags_saturated	boolean		Saturated pixel in the DiaSource footprint.
pixelFlags_saturatedCenter	boolean		Saturated pixel in the 3x3 region around the centroid.
pixelFlags_suspect	boolean		DiaSource's footprint includes suspect pixels.
pixelFlags_suspectCenter	boolean		Suspect pixel in the 3x3 region around the centroid.
pixelFlags_streak	boolean		Streak in the DiaSource footprint.
pixelFlags_streakCenter	boolean		Streak in the 3x3 region around the centroid.
pixelFlags_injected	boolean		Injection in the DiaSource footprint.
pixelFlags_injectedCenter	boolean		Injection in the 3x3 region around the centroid.
pixelFlags_injected_template	boolean		Template injection in the DiaSource footprint.
pixelFlags_injected_templateCenter	boolean		Template injection in the 3x3 region around the centroid.

DiaForcedSource

Forced-photometry source measurement on an individual difference Exposure for all objects in the DiaObject table.

Column Name	Data Type	Unit	Description	UCD
diaForcedSourceId	long		Unique id.
diaObjectId	long		Id of the DiaObject that this DiaForcedSource was associated with.	meta.id;src
ra	double	deg	Right ascension coordinate of the position of the DiaObject at time radecMjdTai.	pos.eq.ra
dec	double	deg	Declination coordinate of the position of the DiaObject at time radecMjdTai.	pos.eq.dec
visit	long		Id of the visit where this forcedSource was measured.	meta.id;obs.image
detector	short		Id of the detector where this forcedSource was measured. Datatype short instead of byte because of DB concerns about unsigned bytes.	meta.id;obs.image
psfFlux	float	nJy	Point Source model flux.	phot.count
psfFluxErr	float	nJy	Uncertainty of psfFlux.	stat.error;phot.count
midpointMjdTai	double	d	Effective mid-visit time for this diaForcedSource, expressed as Modified Julian Date, International Atomic Time.	time.epoch
scienceFlux	float	nJy	Forced photometry flux for a point source model measured on the visit image centered at the DiaObject position.	phot.count
scienceFluxErr	float	nJy	Uncertainty of scienceFlux.	stat.error;phot.count
band	char		Filter band this source was observed with.	meta.id;instr.filter
time_processed	timestamp		Time when this record was generated.
time_withdrawn	timestamp		Time when this record was marked invalid.

DiaObject_To_Object_Match

The table stores mapping of diaObjects to the nearby objects.

Column Name	Data Type	Unit	Description	UCD
diaObjectId	long		Id of diaObject.	meta.id;src
objectId	long		Id of a nearby object.	meta.id;src
dist	float	arcsec	The distance between the diaObject and the object.
lnP	float		Natural log of the probability that the observed diaObject is the same as the nearby object.

DiaObjectLast

Table with a subset of DiaObject columns used to store only the latest version of each object.

Column Name	Data Type	Unit	Description	UCD
diaObjectId	long		Unique id.	meta.id;src
lastNonForcedSource	timestamp		Last time when non-forced DIASource was seen for this object.
ra	double	deg	Right ascension coordinate of the position of the object at time radecMjdTai.	pos.eq.ra
raErr	float	deg	Uncertainty of ra.	stat.error;pos.eq.ra
dec	double	deg	Declination coordinate of the position of the object at time radecMjdTai.	pos.eq.dec
decErr	float	deg	Uncertainty of dec.	stat.error;pos.eq.dec
ra_dec_Cov	float	deg**2	Covariance between ra and dec.
radecMjdTai	double		Time at which the object was at a position ra/dec, expressed as Modified Julian Date, International Atomic Time.	time.epoch
pmRa	float	mas/yr	Proper motion (RA).	pos.pm
pmRaErr	float	mas/yr	Uncertainty of pmRa.	stat.error;pos.pm
pmDec	float	mas/yr	Proper motion (Dec).	pos.pm
pmDecErr	float	mas/yr	Uncertainty of pmDec.	stat.error;pos.pm
parallax	float	mas	Parallax.	pos.parallax
parallaxErr	float	mas	Uncertainty of parallax.	stat.error;pos.parallax
pmRa_pmDec_Cov	float	mas2/yr2	Covariance of pmRa and pmDec.	stat.covariance;pos.eq
pmRa_parallax_Cov	float	mas**2/yr	Covariance of pmRa and parallax.	stat.covariance
pmDec_parallax_Cov	float	mas**2/yr	Covariance of pmDec and parallax.	stat.covariance

MPCORB

The orbit catalog produced by the Minor Planet Center. Ingested daily. O(10M) rows by survey end. The columns are described at https://minorplanetcenter.net//iau/info/MPOrbitFormat.html

Column Name	Data Type	Unit	Description	UCD
mpcDesignation	char		Number or provisional designation (in packed form).	meta.id;src
mpcNumber	int		MPC number (if the asteroid has been numbered; NULL otherwise). Provided for convenience.
ssObjectId	long		LSST unique identifier (if observed by LSST).	meta.id;src
mpcH	float	mag	Absolute magnitude, H.
mpcG	float		Slope parameter, G.
epoch	double	d	Epoch (in MJD, .0 TT).
M	double	deg	Mean anomaly at the epoch, in degrees.
peri	double	deg	Argument of perihelion, J2000.0 (degrees).
node	double	deg	Longitude of the ascending node, J2000.0 (degrees).
incl	double	deg	Inclination to the ecliptic, J2000.0 (degrees).
e	double		Orbital eccentricity.
n	double	deg/d	Mean daily motion (degrees per day).
a	double	AU	Semimajor axis (AU).
uncertaintyParameter	char		Uncertainty parameter, U.
reference	char		Reference.
nobs	int		Number of observations.
nopp	int		Number of oppositions.
arc	float	d	Arc (days), for single-opposition objects.
arcStart	timestamp		Year of first observation (for multi-opposition objects).
arcEnd	timestamp		Year of last observation (for multi-opposition objects).
rms	float	arcsec	r.m.s residual (arcsec).
pertsShort	char		Coarse indicator of perturbers (blank if unperturbed one-opposition. object)'
pertsLong	char		Precise indicator of perturbers (blank if unperturbed one-opposition. object)'
computer	char		Computer name.
flags	int		4-hexdigit flags. See https://minorplanetcenter.net//iau/info/MPOrbitFormat.html. for details'
fullDesignation	char		Readable designation.
lastIncludedObservation	float	d	Date of last observation included in orbit solution.

MPCORBDESIGMAP

The mapping between old and new provisional MPC designation, produced by the Minor Planet Center. Ingested daily. O(few x 10M) rows by survey end.

Column Name	Data Type	Description	UCD
mpcDesignation	char	Either the MPC provisional or permanent designation.	meta.id;src
mpcNumber	int	MPC number (if the asteroid has been numbered).
otherDesignation	char	Other designation by which this object is known.
ssObjectId	long	LSST unique identifier (if observed by LSST).	meta.id;src

SSSource

LSST-computed per-source quantities. 1:1 relationship with DIASource. Recomputed daily, upon MPCORB ingestion.

Column Name	Data Type	Unit	Description	UCD
ssObjectId	long		Unique identifier of the object.	meta.id;src
diaSourceId	long		Unique identifier of the observation.	meta.id;src
mpcUniqueId	long		MPC unique identifier of the observation.
nearbyObj1	long		Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj2	long		Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj3	long		Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj4	long		Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj5	long		Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObj6	long		Closest Objects (3 stars and 3 galaxies) in Level 2 database.
nearbyObjDist1	float		Distances to nearbyObj.
nearbyObjDist2	float		Distances to nearbyObj.
nearbyObjDist3	float		Distances to nearbyObj.
nearbyObjDist4	float		Distances to nearbyObj.
nearbyObjDist5	float		Distances to nearbyObj.
nearbyObjDist6	float		Distances to nearbyObj.
nearbyObjLnP1	float		Natural log of the probability that the observed DIAObject is the same as the nearby Object.
nearbyObjLnP2	float		Natural log of the probability that the observed DIAObject is the same as the nearby Object.
nearbyObjLnP3	float		Natural log of the probability that the observed DIAObject is the same as the nearby Object.
nearbyObjLnP4	float		Natural log of the probability that the observed DIAObject is the same as the nearby Object.
nearbyObjLnP5	float		Natural log of the probability that the observed DIAObject is the same as the nearby Object.
nearbyObjLnP6	float		Natural log of the probability that the observed DIAObject is the same as the nearby Object.
eclipticLambda	double	deg	Ecliptic longitude.
eclipticBeta	double	deg	Ecliptic latitude.
galacticL	double	deg	Galactic longitude.
galacticB	double	deg	Galactic latitute.
phaseAngle	float	deg	Phase angle.
heliocentricDist	float	AU	Heliocentric distance.
topocentricDist	float	AU	Topocentric distace.
predictedMagnitude	float	mag	Predicted magnitude.
predictedMagnitudeSigma	float	mag	Prediction uncertainty (1-sigma).
residualRa	double	deg	Residual R.A. vs. ephemeris.
residualDec	double	deg	Residual Dec vs. ephemeris.
predictedRaSigma	float	deg	Predicted R.A. uncertainty.
predictedDecSigma	float	deg	Predicted Dec uncertainty.
predictedRaDecCov	float	deg**2	Predicted R.A./Dec covariance.
heliocentricX	float	AU	Cartesian heliocentric X coordinate (at the emit time).
heliocentricY	float	AU	Cartesian heliocentric Y coordinate (at the emit time).
heliocentricZ	float	AU	Cartesian heliocentric Z coordinate (at the emit time).
heliocentricVX	float	AU	Cartesian heliocentric X velocity (at the emit time).
heliocentricVY	float	AU	Cartesian heliocentric Y velocity (at the emit time).
heliocentricVZ	float	AU	Cartesian heliocentric Z velocity (at the emit time).
topocentricX	float	AU	Cartesian topocentric X coordinate (at the emit time).
topocentricY	float	AU	Cartesian topocentric Y coordinate (at the emit time).
topocentricZ	float	AU	Cartesian topocentric Z coordinate (at the emit time).
topocentricVX	float	AU	Cartesian topocentric X velocity (at the emit time).
topocentricVY	float	AU	Cartesian topocentric Y velocity (at the emit time).
topocentricVZ	float	AU	Cartesian topocentric Z velocity (at the emit time).

DetectorVisitProcessingSummary

Properties of an image from one processing of a single detector in a visit.

Column Name	Data Type	Unit	Description	UCD
visit	long		Id of the visit this visit was a part of.	meta.id;obs.image
detector	short		Id of the detector on the instrument that took this visit. Datatype short instead of byte because of DB concerns about unsigned bytes.	meta.id;obs.image
ra	double	deg	Right Ascension of detector center.
dec	double	deg	Declination of detector center.
pixelScale	float	arcsec/pixel	Measured detector pixel scale.
zeroPoint	float	mag	Zero-point for the detector, estimated at detector center.
psfSigma	float	pixel	PSF model second-moments determinant radius (center of detector).
skyBg	float	adu	Average sky background.
skyNoise	float	adu	RMS noise of the sky background.
seeing	double	arcsec	Mean measured FWHM of the PSF.
xSize	long	pixel	Number of columns in the image.
ySize	long	pixel	Number of rows in the image.
llcra	double	deg	RA of lower left corner.
llcdec	double	deg	Declination of lower left corner.
ulcra	double	deg	RA of upper left corner.
ulcdec	double	deg	Declination of upper left corner.
urcra	double	deg	RA of upper right corner.
urcdec	double	deg	Declination of upper right corner.
lrcra	double	deg	RA of lower right corner.
lrcdec	double	deg	Declination of lower right corner.
astromOffsetMean	double	arcsec	Mean offset of astrometric calibration matches (arcsec).
astromOffsetStd	double	arcsec	Standard deviation of offsets of astrometric calibration matches (arcsec).
nPsfStar	int		Number of stars used for PSF model.
psfStarDeltaE1Median	double		Median E1 residual (starE1 - psfE1) for psf stars.
psfStarDeltaE2Median	double		Median E2 residual (starE2 - psfE2) for psf stars.
psfStarDeltaE1Scatter	double		Scatter (via MAD) of E1 residual (starE1 - psfE1) for psf stars.
psfStarDeltaE2Scatter	double		Scatter (via MAD) of E2 residual (starE2 - psfE2) for psf stars.
psfStarDeltaSizeMedian	double	pixel	Median size residual (starSize - psfSize) for psf stars (pixel).
psfStarDeltaSizeScatter	double	pixel	Scatter (via MAD) of size residual (starSize - psfSize) for stars (pixel).
psfStarScaledDeltaSizeScatter	double		Scatter (via MAD) of size residual scaled by median size squared.
psfTraceRadiusDelta	double	pixel	Delta (max - min) of model psf trace radius values evaluated on a grid of unmasked pixels (pixel).
psfApFluxDelta	double		Delta (max - min) of model psf aperture flux (with aperture radius of max(2, 3*psfSigma)) values evaluated on a grid of unmasked pixels
psfApCorrSigmaScaledDelta	double		Delta (max - min) of psf flux aperture correction factors scaled (divided) by the psfSigma evaluated on a grid of unmasked pixels
maxDistToNearestPsf	double	pixel	Maximum distance of an unmasked pixel to its nearest model psf star (pixel).

SDM Schemas is maintained by Rubin Observatory.