| column_name | description | unit | ucd | utype | datatype | principal | indexed |
|---|---|---|---|---|---|---|---|
| infobits | Info bit flags | meta.code | int | 1 | 0 | ||
| field | ZTF field number | meta.id;obs.field | int | 1 | 1 | ||
| ccdid | CCD number (1..16) | meta.id | short | 1 | 0 | ||
| fid | Filter ID | meta.id;instr.filter | short | 1 | 0 | ||
| filtercode | Filter code (abbreviated name) | meta.code;instr.filter | char | 1 | 0 | ||
| nid | Day/night ID | meta.id | int | 1 | 1 | ||
| expid | Exposure ID | meta.id;obs.exposure | int | 1 | 1 | ||
| itid | Image type ID | meta.id;obs.image | short | 1 | 0 | ||
| imgtype | Image type name | meta.id;obs.image | char | 1 | 0 | ||
| imgtypecode | Single letter image type code | meta.code.class;obs.image | char | 1 | 0 | ||
| filefracday | Integer (YYYYMMDDdddddd) used in product file names | long | 1 | 0 | |||
| obsdate | UT date/time of observation | time.epoch;obs.exposure | char | 1 | 1 | ||
| obsjd | Julian day of observation | d | time.epoch;obs.exposure | double | 1 | 1 | |
| exptime | Exposure time | s | time.duration;obs.exposure | float | 1 | 0 | |
| seeing | Seeing FWHM | arcsec | instr.obsty.seeing;stat.fwhm | float | 1 | 0 | |
| airmass | Telescope airmass | obs.airMass | float | 1 | 0 | ||
| moonillf | Moon illuminated fraction | arith.ratio | float | 1 | 0 | ||
| moonesb | Moon excess in sky brightness | float | 1 | 0 | |||
| telra | Unrefined telescope pointing, FOV center right ascension | deg | pos.eq.ra;instr.tel;instr.fov | double | 1 | 0 | |
| teldec | Unrefined telescope pointing, FOV center declination | deg | pos.eq.dec;instr.tel;instr.fov | double | 1 | 0 | |
| ccdrot | Rotation on sky about FOV center | deg | pos.posAng;instr.tel;instr.fov | float | 1 | 0 | |
| ipac_pub_date | UT date/time of raw product release | time.release | char | 1 | 0 | ||
| ipac_gid | IPAC Group ID | meta.id | int | 1 | 0 | ||
| meta_id | Metadata record ID | meta.record | long | 0 | 1 |