TAP Service — MSC Navigator

Database Schema

MSC Catalog Tables (2024 Release)

comp (Components)

wds: Identifier (primary key)
radeg, dedeg: Coords
plx, refpar: Parallax & Ref
pmra, pmde: Prop. Motion
rv: Radial Velocity
comp: Label (A, B, C...)
sep: Separation (")
sp: Spectral Type
hip, hd: Identifiers
bmag, vmag, imag: Mags
jmag, hmag, kmag: IR Mags
ncomp: Multiplicity
gr: Grade (0-5)
id: Other identifiers

sys (Individual subsystems)

wds: Identifier (primary key)
primary_comp, secondary_comp
parent: Hierarchy link
type: Obs. Technique
p, punit: Period & Unit
sep, sunit: Separation
pa: Position Angle
vmag1, vmag2
sp1, sp2: Spectral types
mass1, mass2: Masses
mcode1, mcode2: Mass codes
comment

orb (Orbital elements)

wds: Identifier (primary key)
system: Component pair
period, punit: Period
t: Periastron epoch
e: Eccentricity
a: Semimajor axis
node, nodeflag
longp: Long. Periastron
incl: Inclination
k1, k2: Amplitudes
v0: Center of mass vel.
note: Remark text

notes (Remarks)

wds: Identifier (primary key)
rem: Textual note
bib: Bibcode ref

ADQL / SQL Query

Examples:

Results

Enter a query and click Run to see results.