Field Definitions for table BrightStarCat


If the database maintainer has set up a data dictionary, then this form will show information defining and explaining each field in the table BrightStarCat. When an asterisk appears following the column data type (like int *) this indicates that this column is indexed in the database server for faster searches.
FieldTypeDescription
HRsmallint, no nulls *Harvard Revised (HR) = Bright Star (BS) number
Namechar, no nulls *Name, generally Bayer and/or Flamsteed name
DM_Catchar, no nulls Durchmusterung catalog ID, ''BD'', ''CD'', ''CP''
DMchar, no nulls Durchmusterung catalog number, SZZNNNNN
HDint, no nulls Henry Draper Catalog (HD) number
SAOint, no nulls *SAO Catalog number
FK5smallint, no nulls FK5 star number
IR_Flagchar, no nulls ''I'' if infrared source
IR_Flag_Refchar, no nulls reference for infrared source; Blank if from NASA merged Infrared Catalogue, Schmitz et al. 1978; if Engles et al. 1982). : if uncertain id.
Multiplechar, no nulls or multiple-star code, see comment; W=Worley (1978) update of the IDS; D=Duplicity discovered by occulation; S=Duplicity discovered by speckle interferometry.
ADSchar, no nulls Aitken''s Double Star Catalog (ADS) designation
ADS_Compchar, no nulls number components
Var_IDchar, no nulls Variable star identification
RAH_1900smallint, no nulls RA, equinox B1900, epoch 1900.0; units: h
RAM_1900smallint, no nulls RA, equinox B1900, epoch 1900.0; units: min
RAS_1900real, no nulls RA, equinox B1900, epoch 1900.0; units: s
DecSign_1900char, no nulls Dec, equinox B1900, epoch 1900.0
DecD_1900smallint, no nulls Dec, equinox B1900, epoch 1900.0; units: deg
DecM_1900smallint, no nulls Dec, equinox B1900, epoch 1900.0; units: arcmin
DecS_1900smallint, no nulls Dec, equinox B1900, epoch 1900.0; units: arcsec
RAHsmallint, no nulls *Hours RA, equinox J2000, epoch 2000.0; units: h
RAMsmallint, no nulls Minutes RA, equinox J2000, epoch 2000.0; units: min
RASreal, no nulls Seconds RA, equinox J2000, epoch 2000.0; units: s
DecSignchar, no nulls Sign Dec, equinox J2000, epoch 2000.0
DecDsmallint, no nulls *Degrees Dec, equinox J2000, epoch 2000.0; units: deg
DecMsmallint, no nulls Minutes Dec, equinox J2000, epoch 2000.0; units: arcmin
DecSsmallint, no nulls Seconds Dec, equinox J2000, epoch 2000.0; units: arcsec
GLonreal, no nulls Galactic longitude; units: deg
GLatreal, no nulls Galactic latitude; units: deg
Vreal, no nulls Visual magnitude; units: mag
V_Codechar, no nulls Visual magnitude code; = V on UBV Johnson system; R= HR magnitudes reduced to the UBV system; H= original HR magnitude.
V_Uncchar, no nulls '':''=uncertain V; ''?''=questionable V
B_Vreal, no nulls B-V color in the UBV system; units: mag
B_V_Uncchar, no nulls '':''=uncertain B-V; ''?''=questionable B-V
U_Breal, no nulls U-B color in the UBV system; units: mag
U_B_Uncchar, no nulls '':''=uncertain U-B; ''?''=questionable U-B
R_Ireal, no nulls R-I in system specified by R_I_Code; units: mag
R_I_Codechar, no nulls for R-I system
SpTypechar, no nulls Spectral type
SpType_Codechar, no nulls type code
PM_RAreal, no nulls Annual proper motion in RA J2000, FK5 system; units: arcsec/yr
PM_Decreal, no nulls Annual proper motion in Dec J2000, FK5 system; units: arcsec/yr
Par_Codechar, no nulls if dynamical parallax, otherwise trig. par.
Parallaxreal, no nulls parallax unless Par_Code=''D''; units: arcsec
RadVelsmallint, no nulls Line of sight velocity (helio.); units: km/s
RadVel_Commchar, no nulls velocity comments; V or V?=variable or suspected variable radial velocity; SB, SB1, SB2=spectroscopic binaries, single or double lined spectra; O= orbital data available.
RotVel_Commchar, no nulls vel. descriptive chararacters
RotVelsmallint, no nulls Rotational velocity, v sin i; units: km/s
RotVel_Uncchar, no nulls if rotational velocity uncertain
Mult_MDiffreal, no nulls diff. of double, or brightest mult.; units: mag
Mult_Sepreal, no nulls of components in Mult_MDiff; units: arcsec
Mult_IDchar, no nulls Identifications of components in Mult_MDiff; O if occultation binary.
Mult_Cntsmallint, no nulls of components assigned to a multiple
Note_Flagchar, no nulls if there is a note in table BSC5_Rem

Go back to main index.

webmaster@ucolick.org
A Service of the Computing Support Group
UCO/Lick Observatory
University of California
Santa Cruz, CA 95064
Tel: +1 408 459 2630
Fax: +1 408 454 9863