RadialVelocities

Table Documentation

The below table is built directly from the schema and is included here from the astrodb-template-db documentation: source.

RadialVelocities

The RadialVelocities table contains radial velocity measurements for sources listed in the Sources table. The combination of source and reference is expected to be unique.

Columns marked with an exclamation mark (❗️) may not be empty.

Column Name	Description	Datatype	Length	Units	UCD
❗️ source	Unique identifier for a source; links to Sources table	string	50		meta.id;meta.main
❗️ rv_kms	Radial velocity measurement for the source	double		km/s	spect.dopplerVeloc
rv_error	Uncertainty of the radial velocity value	double		km/s	stat.error;spect.dopplerVeloc
rv_error_upper	Upper uncertainty of the radial velocity value	double		km/s	stat.error;spect.dopplerVeloc
rv_error_lower	Lower uncertainty of the radial velocity value	double		km/s	stat.error;spect.dopplerVeloc
adopted	Flag to indicate if this is the adopted entry	boolean
comments	Free form comments	string	100		meta.note
❗️ reference	Reference; links to Publications table	string	30		meta.ref

Indexes

Name	Columns	Description
PK_RadialVelocities	[‘#RadialVelocities.source’, ‘#RadialVelocities.reference’]	Primary key for Radial Velocities table

Foreign Keys

Description	Columns	Referenced Columns
Link RadialVelocities source to Sources table	[‘#RadialVelocities.source’]	[‘#Sources.source’]
Link RadialVelocities reference to Publications table	[‘#RadialVelocities.reference’]	[‘#Publications.reference’]

Checks

Description	Expression
Validate radial velocity error	rv_error >= 0