| name | type | length | unit | ucd | description |
| fieldID | bigint | 8 | | ID_CATALOG | fieldid |
| run | int | 4 | | OBS_RUN | Run number |
| rerun | int | 4 | | | Rerun number |
| camcol | int | 4 | | INST_ID | Camera column |
| field | int | 4 | | ID_FIELD | Field number |
| inLegacy | int | 4 | | FOOT_FLAG | 1 = In Legacy footprint, otherwise (0,-1) not |
| astromVersion | varchar | 32 | | ID_VERSION | Version of astrom pipeline |
| koCat | varchar | 32 | | ID_VERSION | Name of Known Objects Catalog (UCAC denser than Tycho2) |
| koVersion | varchar | 32 | | ID_VERSION | Version of Known Objects Catalog (v72 latest) |
| sdssbitu | int | 4 | | CODE_QUALIY | PHOTO u band quality 0=good 1= bad, -1 = unknown |
| sdssbitg | int | 4 | | CODE_QUALIY | PHOTO g band quality 0=good 1= bad, -1 = unknown |
| sdssbitr | int | 4 | | CODE_QUALIY | PHOTO r band quality 0=good 1= bad, -1 = unknown |
| sdssbiti | int | 4 | | CODE_QUALIY | PHOTO i band quality 0=good 1= bad, -1 = unknown |
| sdssbitz | int | 4 | | CODE_QUALIY | PHOTO z band quality 0=good 1= bad, -1 = unknown |
| QgriS | real | 4 | mag | PHOT_SDSS_GRI | PHOTO Q= (g-r)-1.852(r-i) Reddening free color |
| QrizS | real | 4 | mag | PHOT_SDSS_RIZ | PHOTO Q = (r-i)-0.987(i-z) Reddening free color abs(Q) > 0.12 indicates bad |
| psbitu | int | 4 | | CODE_QUALIY | PanSTARRS u band quality 0=good 1= bad, -1 = unknown |
| psbitg | int | 4 | | CODE_QUALIY | PanSTARRS g band quality 0=good 1= bad, -1 = unknown |
| psbitr | int | 4 | | CODE_QUALIY | PanSTARRS r band quality 0=good 1= bad, -1 = unknown |
| psbiti | int | 4 | | CODE_QUALIY | PanSTARRS i band quality 0=good 1= bad, -1 = unknown |
| psbitz | int | 4 | | CODE_QUALIY | PanSTARRS z band quality 0=good 1= bad, -1 = unknown |
| QgriP | real | 4 | | PS_SDSS_GRI | PanSTARRS Q = (g-r)-1.852(r-i) Reddening free color |
| QrizP | real | 4 | | PS_SDSS_RIZ | PanSTARRS Q = (r-i)-0.987(i-z) Reddening free color |
| problemChar | varchar | 32 | | TEXT_QUALITY | astrom problem 0=ok, f= focus bad, a = astrom shift, r = rotator, s= shutter, |