DiaSource
Table to store 'difference image sources'; - sources detected at SNR >=5 on difference images.
Columns
| name |
datatype |
description |
unit |
nullable |
ivoa:ucd |
votable:arraysize |
length |
| diaSourceId primary key |
long |
Unique id. |
|
true |
meta.id;obs.image |
|
|
| ccdVisitId indexed |
int |
Id of the ccdVisit where this diaSource was measured. Note that we are allowing a diaSource to belong to multiple amplifiers, but it may not span multiple ccds. |
|
true |
meta.id;obs.image |
|
|
| diaObjectId indexed |
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). |
|
true |
meta.id;src |
|
|
| ssObjectId indexed |
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). |
|
true |
meta.id;src |
|
|
| nameTrue |
char |
MPC or simulation designation of the moving object |
|
true |
|
20 |
20 |
| ssObjectReassocTime |
double |
Time (MJD) when this diaSource was reassociated from diaObject to ssObject (if such reassociation happens, otherwise NULL). |
d |
true |
time.processing |
|
|
| midPointMjdTai |
double |
Effective mid-exposure time for this diaSource. |
d |
true |
time.epoch |
|
|
| ra |
double |
RA-coordinate of the center of this diaSource. |
deg |
true |
pos.eq.ra |
|
|
| raErr |
float |
Uncertainty of ra. |
deg |
true |
stat.error;pos.eq.ra |
|
|
| dec |
double |
Dec-coordinate of the center of this diaSource. |
deg |
true |
pos.eq.dec |
|
|
| decErr |
float |
Uncertainty of dec. |
deg |
true |
stat.error;pos.eq.dec |
|
|
| ra_dec_Cov |
float |
Covariance between ra and dec. |
deg**2 |
true |
stat.covariance |
|
|
| snr |
float |
The signal-to-noise ratio at which this source was detected in the difference image. |
|
true |
stat.snr |
|
|
| band |
char |
Name of the band used to take the exposure where this source was measured |
|
true |
|
|
1 |
| mag |
float |
Magnitude. This is a placeholder and should be replaced by flux. |
|
true |
|
|
|
| magErr |
float |
Magnitude error. This is a placeholder and should be replaced by flux error. |
|
true |
|
|
|
| magTrueVband |
float |
True (noiseless) V-band magnitude of the simulated diaSource |
|
true |
|
|
|
| raTrue |
double |
True (noiseless) right ascension of the simulated diaSource |
|
true |
|
|
|
| decTrue |
double |
True (noiseless) declination of the simulated diaSource |
|
true |
|
|
|
Indexes