CompanionRelationships#

Notes#

Relationship types are not currently constrained but should be one of the following:

  • parent: The source is higher mass/brighter than the companion

  • sibling: The source is similar to the companion in the system heirarchy

  • child: The source is lower mass/fainter than the companion

  • unresolved parent: The source is the unresolved, combined light source of an unresolved multiple system which includes the companion

See also

CompanionList

Documentation on the Companion List table

Table documentation#

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

CompanionRelationships#

The CompanionRelationships table contains companions to sources listed in the Sources table. The combination of source and companion_name 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 the source; links to Sources table

string

50

meta.id;meta.main

❗️ companion

External identifier for a companion object, links to the CompanionList table

string

50

meta.id

❗️ relationship

Relationship of the source to the companion, e.g., “parent”, “sibling”, “child”

string

30

projected_separation_arcsec

Projected separation between the source and companion

double

arcsec

pos.angDistance

projected_separation_error

Uncertainty of the projected separation

double

arcsec

stat.error;pos.angDistance

projected_separation_error_upper

Upper uncertainty of the projected separation

double

arcsec

stat.error;pos.angDistance

projected_separation_error_lower

Lower uncertainty of the projected separation

double

arcsec

stat.error;pos.angDistance

comments

Free form comments

string

100

meta.note

❗️ reference

Reference; links to Publications table

string

30

meta.ref

other_companion_names

Additional names for the companion object, comma delimited.

string

100

meta.id

Indexes#

Name

Columns

Description

PK_CompanionRelationships

[‘#CompanionRelationships.source’, ‘#CompanionRelationships.companion’]

Primary key for CompanionRelationships table

Foreign Keys#

Description

Columns

Referenced Columns

Link CompanionRelationships source to Sources table

[‘#CompanionRelationships.source’]

[‘#Sources.source’]

Link CompanionRelationships companion to CompanionList table

[‘#CompanionRelationships.companion’]

[‘#CompanionList.companion’]

Link CompanionRelationships reference to Publications table

[‘#CompanionRelationships.reference’]

[‘#Publications.reference’]