DiaObject

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

Columns

name datatype description unit nullable ivoa:ucd
diaObjectId primary key long Unique identifier of this DiaObject. false meta.id;src
validityStartMjdTai primary key indexed double Processing time when validity of this diaObject starts, expressed as Modified Julian Date, International Atomic Time. false time.epoch
validityEndMjdTai double Processing time when validity of this diaObject ends, expressed as Modified Julian Date, International Atomic Time. true time.epoch
ra double Right ascension coordinate of the position of the object. deg false pos.eq.ra
raErr float Angular error of Right Ascension (dRA*cos(Dec)). deg true stat.error;pos.eq.ra
dec double Declination coordinate of the position of the object. deg false pos.eq.dec
decErr float Angular error of dec. deg true stat.error;pos.eq.dec
ra_dec_Cov float Covariance between Right Ascension (RA*cos(Dec)) and dec. deg**2 true
u_psfFluxMean float Weighted mean point-source model magnitude for u filter. nJy true phot.count
u_psfFluxMeanErr float Standard error of u_psfFluxMean. nJy true stat.error
u_psfFluxSigma float Standard deviation of the distribution of u_psfFlux. nJy true stat.stdev
u_psfFluxNdata int The number of u-band data points. false
u_fpFluxMean float Weighted mean forced photometry flux for u filter. nJy true phot.count
u_fpFluxMeanErr float Standard error of u_fpFluxMean. nJy true stat.error
g_psfFluxMean float Weighted mean point-source model magnitude for g filter. nJy true phot.count
g_psfFluxMeanErr float Standard error of g_psfFluxMean. nJy true stat.error
g_psfFluxSigma float Standard deviation of the distribution of g_psfFlux. nJy true stat.stdev
g_psfFluxNdata int The number of g-band data points. false
g_fpFluxMean float Weighted mean forced photometry flux for g filter. nJy true phot.count
g_fpFluxMeanErr float Standard error of g_fpFluxMean. nJy true stat.error
r_psfFluxMean float Weighted mean point-source model magnitude for r filter. nJy true phot.count
r_psfFluxMeanErr float Standard error of r_psfFluxMean. nJy true stat.error
r_psfFluxSigma float Standard deviation of the distribution of r_psfFlux. nJy true stat.stdev
r_psfFluxNdata int The number of r-band data points. false
r_fpFluxMean float Weighted mean forced photometry flux for r filter. nJy true phot.count
r_fpFluxMeanErr float Standard error of r_fpFluxMean. nJy true stat.error
i_psfFluxMean float Weighted mean point-source model magnitude for i filter. nJy true phot.count
i_psfFluxMeanErr float Standard error of i_psfFluxMean. nJy true stat.error
i_psfFluxSigma float Standard deviation of the distribution of i_psfFlux. nJy true stat.stdev
i_psfFluxNdata int The number of i-band data points. false
i_fpFluxMean float Weighted mean forced photometry flux for i filter. nJy true phot.count
i_fpFluxMeanErr float Standard error of i_fpFluxMean. nJy true stat.error
z_psfFluxMean float Weighted mean point-source model magnitude for z filter. nJy true phot.count
z_psfFluxMeanErr float Standard error of z_psfFluxMean. nJy true stat.error
z_psfFluxSigma float Standard deviation of the distribution of z_psfFlux. nJy true stat.stdev
z_psfFluxNdata int The number of z-band data points. false
z_fpFluxMean float Weighted mean forced photometry flux for z filter. nJy true phot.count
z_fpFluxMeanErr float Standard error of z_fpFluxMean. nJy true stat.error
y_psfFluxMean float Weighted mean point-source model magnitude for y filter. nJy true phot.count
y_psfFluxMeanErr float Standard error of y_psfFluxMean. nJy true stat.error
y_psfFluxSigma float Standard deviation of the distribution of y_psfFlux. nJy true stat.stdev
y_psfFluxNdata int The number of y-band data points. false
y_fpFluxMean float Weighted mean forced photometry flux for y filter. nJy true phot.count
y_fpFluxMeanErr float Standard error of y_fpFluxMean. nJy true stat.error
u_scienceFluxMean float Weighted mean forced photometry flux for u filter. nJy true phot.count
u_scienceFluxMeanErr float Standard error of u_scienceFluxMean. nJy true stat.error
g_scienceFluxMean float Weighted mean forced photometry flux for g filter. nJy true phot.count
g_scienceFluxMeanErr float Standard error of g_scienceFluxMean. nJy true stat.error
r_scienceFluxMean float Weighted mean forced photometry flux for r filter. nJy true phot.count
r_scienceFluxMeanErr float Standard error of r_scienceFluxMean. nJy true stat.error
i_scienceFluxMean float Weighted mean forced photometry flux for i filter. nJy true phot.count
i_scienceFluxMeanErr float Standard error of i_scienceFluxMean. nJy true stat.error
z_scienceFluxMean float Weighted mean forced photometry flux for z filter. nJy true phot.count
z_scienceFluxMeanErr float Standard error of z_scienceFluxMean. nJy true stat.error
y_scienceFluxMean float Weighted mean forced photometry flux for y filter. nJy true phot.count
y_scienceFluxMeanErr float Standard error of y_scienceFluxMean. nJy true stat.error
u_psfFluxMin float Minimum observed u band fluxes. nJy true
u_psfFluxMax float Maximum observed u band fluxes. nJy true
u_psfFluxMaxSlope float Maximum slope between u band flux obsevations max(delta_flux/delta_time). nJy/d true
u_psfFluxErrMean float Mean of the u band flux errors. nJy true
g_psfFluxMin float Minimum observed g band fluxes. nJy true
g_psfFluxMax float Maximum observed g band fluxes. nJy true
g_psfFluxMaxSlope float Maximum slope between g band flux obsevations max(delta_flux/delta_time). nJy/d true
g_psfFluxErrMean float Mean of the g band flux errors. nJy true
r_psfFluxMin float Minimum observed r band fluxes. nJy true
r_psfFluxMax float Maximum observed r band fluxes. nJy true
r_psfFluxMaxSlope float Maximum slope between r band flux obsevations max(delta_flux/delta_time). nJy/d true
r_psfFluxErrMean float Mean of the r band flux errors. nJy true
i_psfFluxMin float Minimum observed i band fluxes. nJy true
i_psfFluxMax float Maximum observed i band fluxes. nJy true
i_psfFluxMaxSlope float Maximum slope between i band flux obsevations max(delta_flux/delta_time). nJy/d true
i_psfFluxErrMean float Mean of the i band flux errors. nJy true
z_psfFluxMin float Minimum observed z band fluxes. nJy true
z_psfFluxMax float Maximum observed z band fluxes. nJy true
z_psfFluxMaxSlope float Maximum slope between z band flux obsevations max(delta_flux/delta_time). nJy/d true
z_psfFluxErrMean float Mean of the z band flux errors. nJy true
y_psfFluxMin float Minimum observed y band fluxes. nJy true
y_psfFluxMax float Maximum observed y band fluxes. nJy true
y_psfFluxMaxSlope float Maximum slope between y band flux obsevations max(delta_flux/delta_time). nJy/d true
y_psfFluxErrMean float Mean of the y band flux errors. nJy true
firstDiaSourceMjdTai double Time of the first diaSource, expressed as Modified Julian Date, International Atomic Time. true time.epoch
lastDiaSourceMjdTai double Time of the most recent non-forced DIASource for this object, expressed as Modified Julian Date, International Atomic Time. true time.epoch
nDiaSources int Total number of DiaSources associated with this DiaObject. false

Indexes

Index Definition Description
IDX_DiaObject_validityStart validityStartMjdTai