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;meta.main;src | |||
| 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 foreign key 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
| Index | Definition | Description |
|---|---|---|
| IDX_DiaSource_ccdVisitId | ccdVisitId | |
| IDX_DiaSource_diaObjectId | diaObjectId | |
| IDX_DiaSource_ssObjectId | ssObjectId |
Constraints
| Constraint | Type | Definition | Description |
|---|---|---|---|
| SSO_DS_10yr | ForeignKey |
Columns: ssObjectId
References: SSObject.ssObjectId
|
Link SSObjects to associated DiaSources |