Choose a database in the left panel then select the table you want!
Table: lsst_sim.simdr2_binary
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| a | Current semi-major axis in R_sun | DOUBLE |
| av | Extinction in the Johnson V band, A_v | REAL |
| c1_c_o | Surface abundance ratio by number, n_C/n_O, during the TP-AGB phase of the primary | REAL |
| c1_g_bpmag | Apparent magnitude of the primary in the Gaia G_BP-band photometric system | REAL |
| c1_g_rpmag | Apparent magnitude of the primary in the Gaia G_RP-band photometric system | REAL |
| c1_gaia_gmag | Apparent magnitude of the primary in the Gaia G-band photometric system | REAL |
| c1_gmag | Apparent magnitude of the primary in the LSST g-band photometric system | REAL |
| c1_imag | Apparent magnitude of the primary in the LSST i-band photometric system | REAL |
| c1_kw | Stellar type of the primary | SMALLINT |
| c1_label | Evolutionary phase of the primary, PMS=0, MS=1, SGB=2, RGB=3, CHeB=4,5,6, EAGB=7, TPAGB=8, PAGB+WD=9 | SMALLINT |
| c1_logg | Logarithm of surface gravity g of the primary in cgs units | REAL |
| c1_logl | Logarithm of luminosity of the primary in L_sun | REAL |
| c1_logte | Log effective temperature (K) of the primary | REAL |
| c1_m_ini | Initial mass (M_sun) of the primary | DOUBLE |
| c1_mass | Present mass (M_sun) of the primary | REAL |
| c1_mbolmag | Absolute bolometric magnitude of the primary | REAL |
| c1_mcoretp | Core mass of the primary during the TP-AGB, otherwise null (M_sun) | REAL |
| c1_mloss | Mass loss rate of the primary (Msun/year) | REAL |
| c1_period0 | Period for classical Cepheid and LBV, in days, in the fundamental mode for the primary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c1_period1 | Period for classical Cepheid and LBV, in days, in the first overtone mode for the primary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c1_period2 | Period for classical Cepheid and LBV, in days, in the second overtone mode for the primary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c1_period3 | Period for classical Cepheid and LBV, in days, in the third overtone mode for the primary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c1_period4 | Period for classical Cepheid and LBV, in days, in the fourth overtone mode for the primary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c1_pmode | Radial order of the dominant pulsation mode for the primary, (0 is the fundamental mode, 1 is the first overtone, and so on). It has value 0 or 1 for classical Cepheids, from 0 to 4 for LPVs, and is set to -1 for the other stars | SMALLINT |
| c1_rmag | Apparent magnitude of the primary in the LSST r-band photometric system | REAL |
| c1_umag | Apparent magnitude of the primary in the LSST u-band photometric system | REAL |
| c1_ymag | Apparent magnitude of the primary in the LSST y-band photometric system | REAL |
| c1_zmag | Apparent magnitude of the primary in the LSST z-band photometric system | REAL |
| c2_c_o | Surface abundance ratio by number, n_C/n_O, during the TP-AGB phase of the secondary | REAL |
| c2_g_bpmag | Apparent magnitude of the secondary in the Gaia G_BP-band photometric system | REAL |
| c2_g_rpmag | Apparent magnitude of the secondary in the Gaia G_RP-band photometric system | REAL |
| c2_gaia_gmag | Apparent magnitude of the secondary in the Gaia G-band photometric system | REAL |
| c2_gmag | Apparent magnitude of the secondary in the LSST g-band photometric system | REAL |
| c2_imag | Apparent magnitude of the secondary in the LSST i-band photometric system | REAL |
| c2_kw | Stellar type of the secondary | SMALLINT |
| c2_label | Evolutionary phase of the secondary, PMS=0, MS=1, SGB=2, RGB=3, CHeB=4,5,6, EAGB=7, TPAGB=8, PAGB+WD=9 | SMALLINT |
| c2_logg | Logarithm of surface gravity g of the secondary in cgs units | REAL |
| c2_logl | Logarithm of luminosity of the secondary in L_sun | REAL |
| c2_logte | Log effective temperature (K) of the secondary | REAL |
| c2_m_ini | Initial mass (M_sun) of the secondary | REAL |
| c2_mass | Present mass (M_sun) of the secondary | REAL |
| c2_mbolmag | Absolute bolometric magnitude of the secondary | REAL |
| c2_mcoretp | Core mass of the secondary during the TP-AGB, otherwise null (M_sun) | REAL |
| c2_mloss | Mass loss rate of the secondary (Msun/year) | REAL |
| c2_period0 | Period for classical Cepheid and LBV, in days, in the fundamental mode for the secondary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c2_period1 | Period for classical Cepheid and LBV, in days, in the first overtone mode for the secondary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c2_period2 | Period for classical Cepheid and LBV, in days, in the second overtone mode for the secondary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c2_period3 | Period for classical Cepheid and LBV, in days, in the third overtone mode for the secondary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c2_period4 | Period for classical Cepheid and LBV, in days, in the fourth overtone mode for the secondary. Cepheids contain only period0, period1. Values are set to 0 for the other stars. | REAL |
| c2_pmode | Radial order of the dominant pulsation mode for the secondary, (0 is the fundamental mode, 1 is the first overtone, and so on). It has value 0 or 1 for classical Cepheids, from 0 to 4 for LPVs, and is set to -1 for the other stars | SMALLINT |
| c2_rmag | Apparent magnitude of the secondary in the LSST r-band photometric system | REAL |
| c2_umag | Apparent magnitude of the secondary in the LSST u-band photometric system | REAL |
| c2_ymag | Apparent magnitude of the secondary in the LSST y-band photometric system | REAL |
| c2_zmag | Apparent magnitude of the secondary in the LSST z-band photometric system | REAL |
| c3_g_bpmag | Apparent magnitude of the total binary system in the Gaia G_BP-band photometric system | REAL |
| c3_g_rpmag | Apparent magnitude of the total binary system in the Gaia G_RP-band photometric system | REAL |
| c3_gaia_gmag | Apparent magnitude of the total binary system in the Gaia G-band photometric system | REAL |
| c3_gmag | Apparent magnitude of the total binary system in the LSST g-band photometric system | REAL |
| c3_imag | Apparent magnitude of the total binary system in the LSST i-band photometric system | REAL |
| c3_mbolmag | Absolute bolometric magnitude of the total binary system | REAL |
| c3_rmag | Apparent magnitude of the total binary system in the LSST r-band photometric system | REAL |
| c3_umag | Apparent magnitude of the total binary system in the LSST u-band photometric system | REAL |
| c3_ymag | Apparent magnitude of the total binary system in the LSST y-band photometric system | REAL |
| c3_zmag | Apparent magnitude of the total binary system in the LSST z-band photometric system | REAL |
| dec | Declination J2000 (deg) | DOUBLE |
| delta_r1 | Maximum depth of the primary eclipse, in magnitudes, in the r band | VARCHAR |
| delta_r2 | Maximum depth of the secondary eclipse, in magnitudes, in the r band | VARCHAR |
| e | Current eccentricity | REAL |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| galb | Galactic latitude in degrees | DOUBLE |
| gall | Galactic longitude in degrees | DOUBLE |
| gc | Galactic component the binary belongs to: thin disk=1, thick disk=2, halo=3, bulge=4, Magellanic Clouds=5 | SMALLINT |
| htm9 | HTM index (order-9 -> ~10 arcmin size) | INTEGER |
| i | Inclination of the orbit in degrees | DOUBLE |
| id | Identification number of the binary system | INTEGER |
| k1 | Radial velocity amplitude in R_Sun/year | VARCHAR |
| k2 | Radial velocity amplitude in R_Sun/year | VARCHAR |
| logage | Logarithm of stellar age in years | REAL |
| m_h | Metallicity [M/H] | REAL |
| mu0 | True distance modulus | REAL |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size) | INTEGER |
| p | Current orbital period in years | DOUBLE |
| pmdec | Proper motion in Dec | REAL |
| pmracosd | Proper motion in RA*cos(Dec) | REAL |
| ra | Right Ascension J2000 (deg) | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| ring256 | Ring-scheme HEALPix (Gorski et al. 2005) index with NSIDE=256 (~14 arcmin resolution) | INTEGER |
| velu | U-component velocity | REAL |
| velv | V-component velocity | REAL |
| velw | W-component velocity | REAL |
| vrad | Radial velocity | REAL |
