White Dwarf-Main Sequence Binaries from the Sloan Digital Sky Survey
Search SQL query
Please enter the SQL query in the text area.
Tables on DB:
| Context | Columns |
| object (short names) | id, short_name |
| object_iau_name (IAU names) | id, iau_name |
| magnitudes (magnitudes) | iau_name, ra, decl, nuv, nuve, fuv, fuve, u, ue, g, ge, r, re, i, ie, z, ze, Y, Ye, J, Je, H, He, K, Ke |
| rv (radial velocities) | iau_name, HJD, rv_na, rv_nae, rv_ha, rv_hae, tel |
| wdms (stellar parameters) | sol, iau_name, type, MJD, PLT, FIB, Teffwd, Teffwde, logg, logge, Mwd, Mwde, Rwd, Rwde, dwd, dwde, Sp, M2, M2e, R2, R2e, Teffsec, Msec, Msece, Rsec, Rsece, Lsec, Lsece, dsec, dsece, age, notes |
| mean_param (average stellar parameters) | iau_name, type, Teffwd, Teffwde, logg, logge, Mwd, Mwde, Rwd, Rwde, dwd, dwde, Sp, M2, M2e, R2, R2e, Teffsec, Msec, Msece, Rsec, Rsece, Lsec, Lsece, dsec, dsece, age, sigma, porb, porbe, phot, spec, re, segue |
Definition of variables:
| id | = object ID |
| short_name | = abbreviated name (e.g. SDSSJHHMM-DDMM) |
| iau_name | = international astronomical union name (e.g. SDSSJHHMMSS.SS+GGMMSS.S) |
| ra | = right ascension (degrees) |
| dec | = declination (degrees) |
| nuv/nuve | = GALEX near-ultraviolet magnitude / error |
| fuv/fuve | = GALEX far-ultraviolet magnitude / error |
| u/ue | = SDSS u magnitude / error |
| g/ge | = SDSS g magnitude / error |
| r/re | = SDSS r magnitude / error |
| i/ie | = SDSS i magnitude / error |
| z/ze | = SDSS z magnitude / error |
| Y/Ye | = UKIDSS Y magnitude / error |
| J/Je | = UKIDSS J magnitude / error |
| H/He | = UKIDSS H magnitude / error |
| K/Ke | = UKIDSS K magnitude / error |
| HJD | = heliocentric Julian date |
| rv_na/rv_nae | = NaI doublet radial velocity (km/s) / error |
| rv_ha/rv_hae | = Halpha radial velocity (km/s) / error |
| tel | = telescope used for the observations |
| sol | = fit solution (1 our adopted solution, 0 the ruled out solution) |
| MJD | = SDSS modified Julian date |
| PLT | = SDSS spectroscopic plate |
| FIB | = SDSS spectroscopic fibre |
| type | = WDMS type (e.g. DA/M, DB/K, DA:/M...) |
| Teff/Teffe | = white dwarf effective temperature (K) / error |
| logg/logge | = white dwarf surface gravity / error |
| Mwd/Mwde | = white dwarf mass (Msun) / error |
| Rwd/Rwde | = white dwarf radius (Rsun)/error |
| dwd/dwde | = white dwarf distance (pc) / error |
| Sp | = secondary star spectral type |
| M2/M2e | = secondary star mass (Msun)/error obtained from the empirical Sp-M-R relation from Rebassa-Mansergas et al. (2007) |
| R2/R2e | = secondary star radius (Rsun)/error obtained from the empirical Sp-M-R relation from Rebassa-Mansergas et al. (2007) |
| dsec/dsece | = secondary star distance (pc) / error |
| Teffsec | = secondary star effective temperature (K) |
| Msec/Msece | = secondary star mass (Msun)/error obtained from evolutionary models of low-mass stars |
| Rsec/Rsece | = secondary star radius (Rsun)/error obtained from evolutionary models of low-mass stars |
| Lsec/LSece | = secondary star luminosity (Lsun)/error |
| age | = age of the system (Gyr) |
| sigma | = wide WDMS binary candidate (sigma=0) or PCEB (sigma=3,4) |
| porb/porbe | = orbital period (h) / error |
| phot | = follow-up photometry by our team available (phot=1), not available (phot=0) |
| spec | = follow-up spectroscopy by our team available (spec=1), not available (spec=0) |
| re | = resolved binary in the SDSS image (1) or not resolved (0), or candidate (-1) |
| segue | = WDMS binaries observed (or firstly observed) in SEGUE |