| name | type | length | unit | ucd | description |
| SDSSName | varchar | 64 | | | SDSS Object Name, hhmmss.ss+ddmmss.s (J2000; truncated coordinates), see http://www.sdss.org/DR3/coverage/IAU.html |
| RA | float | 8 | deg | | J2000 R.A. |
| dec | float | 8 | deg | | J2000 declination |
| z | real | 4 | | | Redshift |
| psfmag_u | real | 4 | mag | | PSF-fitting magnitude in each band from |
| psfmagerr_u | real | 4 | mag | | "BEST" version of data (latest photometry |
| psfmag_g | real | 4 | mag | | and final target selection version). |
| psfmagerr_g | real | 4 | mag | | asinhmag: Lupton,Gunn & Szalay 1999, AJ, 118, 1406 |
| psfmag_r | real | 4 | mag | | SDSS photometry is close to AB in g,r,i (to 0.01 mag) |
| psfmagerr_r | real | 4 | mag | | u_AB = u_SDSS - 0.04; z_AB = z_SDSS + 0.02 |
| psfmag_i | real | 4 | mag | | (with some uncertainty about the true z shift) |
| psfmagerr_i | real | 4 | mag | | AB: Oke and Gunn 1983, ApJ, 266, 713, |
| psfmag_z | real | 4 | mag | | see Flux Calibration in Algorithms Help page. |
| psfmagerr_z | real | 4 | mag | | |
| A_u | real | 4 | mag | | Galactic absorption in u band, A_g/A_r/A_i/A_z = 0.736/0.534/0.405/0.287 * A_u |
| lgNH | real | 4 | | | |
| FIRSTmag | real | 4 | | | FIRST Peak flux density (AB mag) at 20 cm of FIRST catalog match within 2 arcsec, AB mag = -2.5 log_10(f_nu / 3631 Jy); 0 ==> no detection, -1 ==> not in FIRST survey area |
| FIRST_sn | real | 4 | | | |
| FIRST_sep | real | 4 | | | |
| FIRST_flux_at_opt | smallint | 2 | | | 1 ==> no FIRST source within 2 arcsec, but > 3 sigma FIRST flux detection at optical position |
| FIRST_extmatch | smallint | 2 | | | For source with either FIRSTMAG > 0 or FIRST_flux_at_opt 1 ==> FIRST catalog source within 2 arcsec - 30 arcsec |
| lg_RASS_rate | real | 4 | | | log_10 BSC/FSC full band count rate; 0 ==> no detection ROSAT All Sky Survey Bright and Faint source catalogs |
| RASS_sn | real | 4 | | | |
| RASS_sep | real | 4 | | | |
| TWOMASSmag_J | real | 4 | | | 2MASS All-Sky Point Source Catalog 2003 March 25; Note that 2MASS magnitues are Vega-based, not AB |
| TWOMASSmagerr_J | real | 4 | | | |
| TWOMASSmag_H | real | 4 | | | |
| TWOMASSmagerr_H | real | 4 | | | |
| TWOMASSmag_K | real | 4 | | | |
| TWOMASSmagerr_K | real | 4 | | | |
| TWOMASS_sep | real | 4 | | | |
| M_i | real | 4 | | | Uses Ho=70 Omega_M=0.300 Omega_L= 0.700 alpha_Q=-0.50 |
| morphology | smallint | 2 | | | 0 = point source 1 = extended |
| scienceprimary | smallint | 2 | | | Used by CAS to resolve repeat spectra (if available) of a given object. 0 only in special cases. |
| mode | smallint | 2 | | | 1 for primary object, 2 for secondary, 3 for family |
| bestprimtarget | int | 4 | | | Target selection flags in "BEST" version of data |
| ts_b_qso | smallint | 2 | | | Individual flags expanded from bestprimtarget |
| ts_b_hiz | smallint | 2 | | | |
| ts_b_FIRST | smallint | 2 | | | |
| ts_b_ROSAT | smallint | 2 | | | |
| ts_b_serendip | smallint | 2 | | | |
| ts_b_star | smallint | 2 | | | |
| ts_b_gal | smallint | 2 | | | |
| run_best | smallint | 2 | | | SDSS Imaging run number for "BEST" data |
| mjd_best | int | 4 | | | Modified Julian Date of BEST imaging observation |
| mjd_spec | int | 4 | | | Modified Julian Date of spectroscopic observation |
| plate | smallint | 2 | | | |
| fiberid | smallint | 2 | | | |
| rerun_best | smallint | 2 | | | SDSS Imaging rerun, camcol, field, object number |
| camcol_best | smallint | 2 | | | |
| field_best | smallint | 2 | | | |
| obj_best | smallint | 2 | | | |
| tilingchunk | smallint | 2 | | | Tiling chunk number |
| targprimtarget | int | 4 | | | Target selection flags in "TARGET" version of data |
| t_psfmag_u | real | 4 | | | PSF magnitudes and errors in "TARGET" version of data |
| t_psfmagerr_u | real | 4 | | | |
| t_psfmag_g | real | 4 | | | |
| t_psfmagerr_g | real | 4 | | | |
| t_psfmag_r | real | 4 | | | |
| t_psfmagerr_r | real | 4 | | | |
| t_psfmag_i | real | 4 | | | |
| t_psfmagerr_i | real | 4 | | | |
| t_psfmag_z | real | 4 | | | |
| t_psfmagerr_z | real | 4 | | | |
| object_name | varchar | 64 | | | Object Name if previously published; "SDSS" if previously published SDSS discovery |
| specObjId | bigint | 8 | | | Unique SDSS ID of corresponding object in SpecObjAll table |