### Choose a database in the left panel then select the table you want!

(The bold columns are indexed columns)

Column Name | Description | Datatype |
---|---|---|

allmask_g | Bitwise mask set if the central pixel from all images satisfy each condition in (g) | SMALLINT |

allmask_r | Bitwise mask set if the central pixel from all images satisfy each condition in (r) | SMALLINT |

allmask_z | Bitwise mask set if the central pixel from all images satisfy each condition in (z) | SMALLINT |

anymask_g | Bitwise mask set if the central pixel from any image satisfies each condition in (g) | SMALLINT |

anymask_r | Bitwise mask set if the central pixel from any image satisfies each condition in (r) | SMALLINT |

anymask_z | Bitwise mask set if the central pixel from any image satisfies each condition in (z) | SMALLINT |

apflux_g_1 | Aperture fluxes on the co-added images in aperture of radius 0.5 arcsec | REAL |

apflux_g_2 | Aperture fluxes on the co-added images in aperture of radius 0.75 arcsec | REAL |

apflux_g_3 | Aperture fluxes on the co-added images in aperture of radius 1.0 arcsec | REAL |

apflux_g_4 | Aperture fluxes on the co-added images in aperture of radius 1.5 arcsec | REAL |

apflux_g_5 | Aperture fluxes on the co-added images in aperture of radius 2.0 arcsec | REAL |

apflux_g_6 | Aperture fluxes on the co-added images in aperture of radius 3.5arcsec | REAL |

apflux_g_7 | Aperture fluxes on the co-added images in aperture of radius 5.0 arcsec | REAL |

apflux_g_8 | Aperture fluxes on the co-added images in aperture of radius 7.0 arcsec | REAL |

apflux_ivar_g_1 | Inverse variance of FLUX_G | REAL |

apflux_ivar_g_2 | Inverse variance of FLUX_G | REAL |

apflux_ivar_g_3 | Inverse variance of FLUX_G | REAL |

apflux_ivar_g_4 | Inverse variance of FLUX_G | REAL |

apflux_ivar_g_5 | Inverse variance of FLUX_G | REAL |

apflux_ivar_g_6 | Inverse variance of FLUX_G | REAL |

apflux_ivar_g_7 | Inverse variance of FLUX_G | REAL |

apflux_ivar_g_8 | Inverse variance of FLUX_G | REAL |

apflux_ivar_r_1 | Inverse variance of FLUX_R | REAL |

apflux_ivar_r_2 | Inverse variance of FLUX_R | REAL |

apflux_ivar_r_3 | Inverse variance of FLUX_R | REAL |

apflux_ivar_r_4 | Inverse variance of FLUX_R | REAL |

apflux_ivar_r_5 | Inverse variance of FLUX_R | REAL |

apflux_ivar_r_6 | Inverse variance of FLUX_R | REAL |

apflux_ivar_r_7 | Inverse variance of FLUX_R | REAL |

apflux_ivar_r_8 | Inverse variance of FLUX_R | REAL |

apflux_ivar_z_1 | Inverse variance of FLUX_Z | REAL |

apflux_ivar_z_2 | Inverse variance of FLUX_Z | REAL |

apflux_ivar_z_3 | Inverse variance of FLUX_Z | REAL |

apflux_ivar_z_4 | Inverse variance of FLUX_Z | REAL |

apflux_ivar_z_5 | Inverse variance of FLUX_Z | REAL |

apflux_ivar_z_6 | Inverse variance of FLUX_Z | REAL |

apflux_ivar_z_7 | Inverse variance of FLUX_Z | REAL |

apflux_ivar_z_8 | Inverse variance of FLUX_Z | REAL |

apflux_r_1 | Aperture fluxes on the co-added images in aperture of radius 0.5 arcsec | REAL |

apflux_r_2 | Aperture fluxes on the co-added images in aperture of radius 0.75 arcsec | REAL |

apflux_r_3 | Aperture fluxes on the co-added images in aperture of radius 1.0 arcsec | REAL |

apflux_r_4 | Aperture fluxes on the co-added images in aperture of radius 1.5 arcsec | REAL |

apflux_r_5 | Aperture fluxes on the co-added images in aperture of radius 2.0 arcsec | REAL |

apflux_r_6 | Aperture fluxes on the co-added images in aperture of radius 3.5 arcsec | REAL |

apflux_r_7 | Aperture fluxes on the co-added images in aperture of radius 5.0 arcsec | REAL |

apflux_r_8 | Aperture fluxes on the co-added images in aperture of radius 7.0 arcsec | REAL |

apflux_resid_g_1 | Aperture fluxes on the co-added residual images in G | REAL |

apflux_resid_g_2 | Aperture fluxes on the co-added residual images in G | REAL |

apflux_resid_g_3 | Aperture fluxes on the co-added residual images in G | REAL |

apflux_resid_g_4 | Aperture fluxes on the co-added residual images in G | REAL |

apflux_resid_g_5 | Aperture fluxes on the co-added residual images in G | REAL |

apflux_resid_g_6 | Aperture fluxes on the co-added residual images in G | REAL |

apflux_resid_g_7 | Aperture fluxes on the co-added residual images in G | REAL |

apflux_resid_g_8 | Aperture fluxes on the co-added residual images in G | REAL |

apflux_resid_r_1 | Aperture fluxes on the co-added residual images in R | REAL |

apflux_resid_r_2 | Aperture fluxes on the co-added residual images in R | REAL |

apflux_resid_r_3 | Aperture fluxes on the co-added residual images in R | REAL |

apflux_resid_r_4 | Aperture fluxes on the co-added residual images in R | REAL |

apflux_resid_r_5 | Aperture fluxes on the co-added residual images in R | REAL |

apflux_resid_r_6 | Aperture fluxes on the co-added residual images in R | REAL |

apflux_resid_r_7 | Aperture fluxes on the co-added residual images in R | REAL |

apflux_resid_r_8 | Aperture fluxes on the co-added residual images in R | REAL |

apflux_resid_z_1 | Aperture fluxes on the co-added residual images in Z | REAL |

apflux_resid_z_2 | Aperture fluxes on the co-added residual images in Z | REAL |

apflux_resid_z_3 | Aperture fluxes on the co-added residual images in Z | REAL |

apflux_resid_z_4 | Aperture fluxes on the co-added residual images in Z | REAL |

apflux_resid_z_5 | Aperture fluxes on the co-added residual images in Z | REAL |

apflux_resid_z_6 | Aperture fluxes on the co-added residual images in Z | REAL |

apflux_resid_z_7 | Aperture fluxes on the co-added residual images in Z | REAL |

apflux_resid_z_8 | Aperture fluxes on the co-added residual images in Z | REAL |

apflux_z_1 | Aperture fluxes on the co-added images in aperture of radius 0.5 arcsec | REAL |

apflux_z_2 | Aperture fluxes on the co-added images in aperture of radius 0.75 arcsec | REAL |

apflux_z_3 | Aperture fluxes on the co-added images in aperture of radius 1.0 arcsec | REAL |

apflux_z_4 | Aperture fluxes on the co-added images in aperture of radius 1.5 arcsec | REAL |

apflux_z_5 | Aperture fluxes on the co-added images in aperture of radius 2.0 arcsec | REAL |

apflux_z_6 | Aperture fluxes on the co-added images in aperture of radius 3.5 arcsec | REAL |

apflux_z_7 | Aperture fluxes on the co-added images in aperture of radius 5.0 arcsec | REAL |

apflux_z_8 | Aperture fluxes on the co-added images in aperture of radius 7.0 arcsec | REAL |

brick_primary | True if the object is within the brick boundary | SMALLINT |

brickid | Brick ID [1,662174] | INTEGER |

brickname | Name of brick, encoding the brick sky position, e.g. 1126p222 near RA=112.6, Dec=+22.2 | VARCHAR(n) |

brightblob | True if the object shares a blob with a bright (Tycho-2) star | SMALLINT |

bx | X position (0-indexed) of coordinates in brick image stack | REAL |

by | Y position (0-indexed) of coordinates in brick image stack | REAL |

dchisq_1 | Difference in X^2 between successfully more-complex model fits | REAL |

dchisq_2 | Difference in X^2 between successfully more-complex model fits | REAL |

dchisq_3 | Difference in X^2 between successfully more-complex model fits | REAL |

dchisq_4 | Difference in X^2 between successfully more-complex model fits | REAL |

dchisq_5 | Difference in X^2 between successfully more-complex model fits | REAL |

dec | Declination at epoch J2000 | DOUBLE |

dec_ivar | Inverse variance of DEC, excluding astrometric calibration errors | REAL |

dl_uniqid | BIGINT | |

dl_uniqid_str | INTEGER | |

ebv | Galactic extinction (E(B-V)) reddening from SFD98, used to compute DECAM_MW_TRANSMISSION and WISE_MW_TRANSMISSION | REAL |

elat | Ecliptic Latitude | DOUBLE |

elon | Ecliptic Longitude | DOUBLE |

fiberflux_g | Predicted (g)-band flux within a fiber from this object in 1 arcsec Gaussian seeing | REAL |

fiberflux_r | Predicted (r)-band flux within a fiber from this object in 1 arcsec Gaussian seeing | REAL |

fiberflux_z | Predicted (z)-band flux within a fiber from this object in 1 arcsec Gaussian seeing | REAL |

fiberid | INTEGER | |

fibertotflux_g | Predicted (g)-band flux within a fiber from all sources at this location in 1 arcsec Gaussian seeing | REAL |

fibertotflux_r | Predicted (r)-band flux within a fiber from all sources at this location in 1 arcsec Gaussian seeing | REAL |

fibertotflux_z | Predicted (z)-band flux within a fiber from all sources at this location in 1 arcsec Gaussian seeing | REAL |

flux_g | model flux in (g) | REAL |

flux_ivar_g | Inverse variance of FLUX_G | REAL |

flux_ivar_r | Inverse variance of FLUX_R | REAL |

flux_ivar_w1 | Inverse variance of FLUX_W1 | REAL |

flux_ivar_w2 | Inverse variance of FLUX_W2 | REAL |

flux_ivar_w3 | Inverse variance of FLUX_W3 | REAL |

flux_ivar_w4 | Inverse variance of FLUX_W4 | REAL |

flux_ivar_z | Inverse variance of FLUX_Z | REAL |

flux_r | model flux in (r) | REAL |

flux_w1 | WISE model flux in (W1) | REAL |

flux_w2 | WISE model flux in (W2) | REAL |

flux_w3 | WISE model flux in (W3) | REAL |

flux_w4 | WISE model flux in (W4) | REAL |

flux_z | model flux in (z) | REAL |

fracdev | Fraction of model in deVauc [0,1] | REAL |

fracdev_ivar | Inverse variance of FRACDEV | REAL |

fracflux_g | Profile-weighted fraction of the flux from other sources divided by the total flux in (g) (typically [0,1]) | REAL |

fracflux_r | Profile-weighted fraction of the flux from other sources divided by the total flux in (r) (typically [0,1]) | REAL |

fracflux_w1 | Profile-weighted fraction of the flux from other sources divided by the total flux in (W1) (typically [0,1]) | REAL |

fracflux_w2 | Profile-weighted fraction of the flux from other sources divided by the total flux in (W2) (typically [0,1]) | REAL |

fracflux_w3 | Profile-weighted fraction of the flux from other sources divided by the total flux in (W3) (typically [0,1]) | REAL |

fracflux_w4 | Profile-weighted fraction of the flux from other sources divided by the total flux in (W4) (typically [0,1]) | REAL |

fracflux_z | Profile-weighted fraction of the flux from other sources divided by the total flux in (z) (typically [0,1]) | REAL |

fracin_g | Fraction of source flux within the blob in (g), near unity for real sources | REAL |

fracin_r | Fraction of source flux within the blob in (r), near unity for real sources | REAL |

fracin_z | Fraction of source flux within the blob in (z), near unity for real sources | REAL |

fracmasked_g | Profile-weighted fraction of pixels masked from all observations of this object in (g), strictly between [0,1] | REAL |

fracmasked_r | Profile-weighted fraction of pixels masked from all observations of this object in (r), strictly between [0,1] | REAL |

fracmasked_z | Profile-weighted fraction of pixels masked from all observations of this object in (z), strictly between [0,1] | REAL |

gaia_a_g_val | Gaia line-of-sight extinction in the G band | REAL |

gaia_astrometric_excess_noise | Gaia astrometric excess noise | REAL |

gaia_astrometric_excess_noise_sireal | REAL | |

gaia_astrometric_n_good_obs_al | Gaia number of good astrometric observations along scan direction | SMALLINT |

gaia_astrometric_n_obs_al | Gaia number of astrometric observations along scan direction | SMALLINT |

gaia_astrometric_params_solved | Which astrometric parameters were estimated for a Gaia source | SMALLINT |

gaia_astrometric_sigma5d_max | Gaia longest semi-major axis of the 5-d error ellipsoid | REAL |

gaia_astrometric_weight_al | Gaia astrometric weight along scan direction | REAL |

gaia_duplicated_source | Gaia duplicated source flag | SMALLINT |

gaia_e_bp_min_rp_val | Gaia line-of-sight reddening E(BP-RP) | REAL |

gaia_phot_bp_mean_flux_over_erroreal | Gaia BP signal-to-noise | REAL |

gaia_phot_bp_mean_mag | Gaia BP mag | REAL |

gaia_phot_bp_n_obs | Gaia BP number of observations | SMALLINT |

gaia_phot_bp_rp_excess_factor | Gaia BP/RP excess factor | REAL |

gaia_phot_g_mean_flux_over_errorreal | Gaia G band signal-to-noise | REAL |

gaia_phot_g_mean_mag | Gaia G band mag | REAL |

gaia_phot_g_n_obs | Gaia G band number of observations | SMALLINT |

gaia_phot_rp_mean_flux_over_erroreal | Gaia RP signal-to-noise | REAL |

gaia_phot_rp_mean_mag | Gaia RP mag | REAL |

gaia_phot_rp_n_obs | Gaia RP number of observations | SMALLINT |

gaia_phot_variable_flag | Gaia photometric variable flag | SMALLINT |

gaia_pointsource | This Gaia-DR2 source is believed to be a star, not a galaxy | SMALLINT |

galdepth_g | As for PSFDEPTH_G but for a galaxy (0.45 arcsec exp, round) detection sensitivity | REAL |

galdepth_r | As for PSFDEPTH_R but for a galaxy (0.45 arcsec exp, round) detection sensitivity | REAL |

galdepth_z | As for PSFDEPTH_Z but for a galaxy (0.45 arcsec exp, round) detection sensitivity | REAL |

glat | Galactic Latitude | DOUBLE |

glon | Galactic Longitude | DOUBLE |

htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |

lc_flux_ivar_w1_1 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_10 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_11 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_2 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_3 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_4 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_5 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_6 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_7 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_8 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w1_9 | Inverse variance of LC_FLUX_W1 | REAL |

lc_flux_ivar_w2_1 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_10 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_11 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_2 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_3 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_4 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_5 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_6 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_7 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_8 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_ivar_w2_9 | Inverse variance of LC_FLUX_W2 | REAL |

lc_flux_w1_1 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_10 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_11 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_2 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_3 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_4 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_5 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_6 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_7 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_8 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w1_9 | FLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_1 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_10 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_11 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_2 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_3 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_4 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_5 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_6 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_7 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_8 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_flux_w2_9 | FLUX_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_1 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_10 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_11 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_2 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_3 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_4 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_5 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_6 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_7 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_8 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w1_9 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_1 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_10 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_11 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_2 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_3 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_4 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_5 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_6 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_7 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_8 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_fracflux_w2_9 | FRACFLUX_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_mjd_w1_1 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_10 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_11 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_2 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_3 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_4 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_5 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_6 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_7 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_8 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w1_9 | MJD_W1 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_1 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_10 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_11 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_2 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_3 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_4 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_5 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_6 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_7 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_8 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_mjd_w2_9 | MJD_W2 in each of up to eleven unWISE coadd epochs | DOUBLE |

lc_nobs_w1_1 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_10 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_11 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_2 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_3 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_4 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_5 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_6 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_7 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_8 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w1_9 | NOBS_W1 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_1 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_10 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_11 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_2 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_3 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_4 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_5 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_6 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_7 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_8 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_nobs_w2_9 | NOBS_W2 in each of eleven unWISE coadd epochs | SMALLINT |

lc_rchisq_w1_1 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_10 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_11 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_2 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_3 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_4 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_5 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_6 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_7 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_8 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w1_9 | RCHI2_W1 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_1 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_10 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_11 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_2 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_3 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_4 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_5 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_6 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_7 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_8 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

lc_rchisq_w2_9 | RCHI2_W2 in each of up to eleven unWISE coadd epochs | REAL |

ls_id | Unique LS object ID | BIGINT |

maskbits | Bitwise mask indicating that an object touches a pixel in the coadd/*/*/*maskbits* maps see http://legacysurvey.org/dr8/bitmasks/ | SMALLINT |

mjd | INTEGER | |

mjd_max | Maximum Modified Julian Date of observations used to construct the model of this object | DOUBLE |

mjd_min | Minimum Modified Julian Date of observations used to construct the model of this object | DOUBLE |

mw_transmission_g | Galactic transmission in (g) filter in linear units [0,1] | REAL |

mw_transmission_r | Galactic transmission in (r) filter in linear units [0,1] | REAL |

mw_transmission_w1 | Galactic transmission in (W1) filter in linear units [0,1] | REAL |

mw_transmission_w2 | Galactic transmission in (W2) filter in linear units [0,1] | REAL |

mw_transmission_w3 | Galactic transmission in (W3) filter in linear units [0,1] | REAL |

mw_transmission_w4 | Galactic transmission in (W4) filter in linear units [0,1] | REAL |

mw_transmission_z | Galactic transmission in (z) filter in linear units [0,1] | REAL |

nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size | INTEGER |

nobs_g | Number of images that contribute to the central pixel in (g): filter for this object (not profile-weighted) | SMALLINT |

nobs_r | Number of images that contribute to the central pixel in (r): filter for this object (not profile-weighted) | SMALLINT |

nobs_w1 | Number of images that contribute to the central pixel in (W1): filter for this object (not profile-weighted) | SMALLINT |

nobs_w2 | Number of images that contribute to the central pixel in (W2): filter for this object (not profile-weighted) | SMALLINT |

nobs_w3 | Number of images that contribute to the central pixel in (W3): filter for this object (not profile-weighted) | SMALLINT |

nobs_w4 | Number of images that contribute to the central pixel in (W4): filter for this object (not profile-weighted) | SMALLINT |

nobs_z | Number of images that contribute to the central pixel in (z): filter for this object (not profile-weighted) | SMALLINT |

objid | Catalog object number within this brick; a unique identifier hash is BRICKID,OBJID; OBJID spans [0,N-1] and is contiguously enumerated within each blob | INTEGER |

parallax | Reference catalog parallax | REAL |

parallax_ivar | Reference catalog inverse-variance on parallax | REAL |

plate | INTEGER | |

pmdec | Reference catalog proper motion in the Dec direction | REAL |

pmdec_ivar | Reference catalog inverse-variance on pmdec | REAL |

pmra | Reference catalog proper motion in the RA direction | REAL |

pmra_ivar | Reference catalog inverse-variance on pmra | REAL |

psfdepth_g | For a (5sigma) point source detection limit in (g), (5/sqrt(mathrm{PSFDEPTH_G})) gives flux in nanomaggies and (-2.5[log_{10}(5 / sqrt(mathrm{PSFDEPTH_G})) - 9]) gives corresponding magnitude | REAL |

psfdepth_r | For a (5sigma) point source detection limit in (g), (5/sqrt(mathrm{PSFDEPTH_R})) gives flux in nanomaggies and (-2.5[log_{10}(5 / sqrt(mathrm{PSFDEPTH_R})) - 9]) gives corresponding magnitude | REAL |

psfdepth_w1 | As for psfdepth_g (and also on the AB system) but for WISE W1 | REAL |

psfdepth_w2 | As for psfdepth_g (and also on the AB system) but for WISE W2 | REAL |

psfdepth_w3 | As for psfdepth_g (and also on the AB system) but for WISE W3 | REAL |

psfdepth_w4 | As for psfdepth_g (and also on the AB system) but for WISE W4 | REAL |

psfdepth_z | For a (5sigma) point source detection limit in (g), (5/sqrt(mathrm{PSFDEPTH_Z})) gives flux in nanomaggies and (-2.5[log_{10}(5 / sqrt(mathrm{PSFDEPTH_Z})) - 9]) gives corresponding magnitude | REAL |

psfsize_g | Weighted average PSF FWHM in the (g) band | REAL |

psfsize_r | Weighted average PSF FWHM in the (r) band | REAL |

psfsize_z | Weighted average PSF FWHM in the (z) band | REAL |

ra | Right ascension at epoch J2000 | DOUBLE |

ra_ivar | Inverse variance of RA (no cosine term!), excluding astrometric calibration errors | REAL |

rchisq_g | Profile-weighted chi^2 of model fit normalized by the number of pixels in (g) | REAL |

rchisq_r | Profile-weighted chi^2 of model fit normalized by the number of pixels in (r) | REAL |

rchisq_w1 | Profile-weighted chi^2 of model fit normalized by the number of pixels in (W1) | REAL |

rchisq_w2 | Profile-weighted chi^2 of model fit normalized by the number of pixels in (W2) | REAL |

rchisq_w3 | Profile-weighted chi^2 of model fit normalized by the number of pixels in (W3) | REAL |

rchisq_w4 | Profile-weighted chi^2 of model fit normalized by the number of pixels in (W4) | REAL |

rchisq_z | Profile-weighted chi^2 of model fit normalized by the number of pixels in (z) | REAL |

ref_cat | Reference catalog source for this star: T2 for Tycho-2, G2 for Gaia DR2, empty otherwise | VARCHAR(n) |

ref_epoch | Reference catalog reference epoch (e.g., 2015.5 for Gaia-DR2) | REAL |

ref_id | Reference catalog identifier for this star; (mathrm{Tyc1} imes 1,000,000 + mathrm{Tyc2} imes 10 + mathrm{Tyc3}) for Tycho2; sourceid for Gaia-DR2 | BIGINT |

release | Unique integer denoting the camera and filter set used | SMALLINT |

ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |

shapedev_e1 | Ellipticity component 1 | REAL |

shapedev_e1_ivar | Inverse variance of SHAPEDEV_E1 | REAL |

shapedev_e2 | Ellipticity component 2 | REAL |

shapedev_e2_ivar | Inverse variance of SHAPEDEV_E2 | REAL |

shapedev_r | Half-light radius of deVaucouleurs model (>0) | REAL |

shapedev_r_ivar | Inverse variance of R_DEV | REAL |

shapeexp_e1 | Ellipticity component 1 | REAL |

shapeexp_e1_ivar | Inverse variance of SHAPEEXP_E1 | REAL |

shapeexp_e2 | Ellipticity component 2 | REAL |

shapeexp_e2_ivar | Inverse variance of SHAPEEXP_E2 | REAL |

shapeexp_r | Half-light radius of exponential model (>0) | REAL |

shapeexp_r_ivar | Inverse variance of R_EXP | REAL |

type | Morphological model: PSF=stellar, REX=round exponential galaxy, DEV=deVauc, EXP=exponential, COMP=composite. | VARCHAR(n) |

wise_coadd_id | unWISE coadd file name for the center of each object | VARCHAR(n) |

wisemask_w1 | W1 bright star bitmask, (2^0) ((2^1)) for southward (northward) scans | SMALLINT |

wisemask_w2 | W2 bright star bitmask, (2^0) ((2^1)) for southward (northward) scans | SMALLINT |