Parallaxes

Table Documentation

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

Parallaxes

The Parallaxes table contains parallax 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	100		meta.id;meta.main
❗️ parallax_mas	Parallax measurement for the source	double		mas	pos.parallax
parallax_error	Uncertainty of the parallax value	double		mas	stat.error;pos.parallax
parallax_error_upper	Upper uncertainty of the parallax value	double		mas	stat.error;pos.parallax
parallax_error_lower	Lower uncertainty of the parallax value	double		mas	stat.error;pos.parallax
adopted	Flag to indicate if this is the adopted measurement	boolean
comments	Free form comments	string	100		meta.note
❗️ reference	Reference; links to Publications table	string	30		meta.ref

Indexes

Name	Columns	Description
PK_Parallaxes	[‘#Parallaxes.source’, ‘#Parallaxes.reference’]	Primary key for Parallaxes table

Foreign Keys

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