| objectId | ZTF object identifier | string |
| decmean | Mean Dec in degrees | double |
| decstd | Standard deviation of Dec in arcseconds | double |
| ramean | Mean RA in degrees | double |
| rastd | Standard deviation of RA in arcseconds | double |
| glatmean | Mean galactic latitude in degrees | double |
| glonmean | Mean galactic longitude in degrees | double |
| jdgmax | Latest Julian Day of g mag candidates | double |
| gmag | Latest g magnitude | float |
| dmdt_g | most recent increase in g magnitude divided by time difference, (brightening = positive) | float |
| dmdt_g_2 | deprecated -- always Null | float |
| mag_g02 | Latest Exponential Moving Average of difference magnitude in g band, with 2-day timescale (see note) | float |
| mag_g08 | Latest Exponential Moving Average of difference magnitude in g band, with 8-day timescale (see note) | float |
| mag_g28 | Latest Exponential Moving Average of difference magnitude in g band, with 28-day timescale (see note) | float |
| maggmax | Maximum g magnitude of light curve (faintest) | float |
| maggmean | Mean g magnitude of light curve | float |
| maggmin | Minimum g magnitude of light curve (brightest) | float |
| jdrmax | Latest Julian Day of r mag candidates | double |
| mag_r02 | Latest Exponential Moving Average of difference magnitude in r band, with 2-day timescale (see note) | float |
| mag_r08 | Latest Exponential Moving Average of difference magnitude in r band, with 8-day timescale (see note) | float |
| mag_r28 | Latest Exponential Moving Average of difference magnitude in r band, with 28-day timescale (see note) | float |
| rmag | latest r magnitude | float |
| dmdt_r | most recent increase in r magnitude divided by time difference, (brightening = positive) | float |
| dmdt_r_2 | deprecated -- always Null | float |
| magrmax | Maximum r magnitude of light curve (faintest) | float |
| magrmean | Mean r magnitude of light curve | float |
| magrmin | Minimum r magnitude of light curve (brightest) | float |
| jdmax | Maximum of jdgmax and jdrmax | double |
| jdmin | Earliest Julian Day of candidates that cite this object | double |
| ncand | Number in light curve | int |
| ncandgp | Number in light curve with good quality and brighter than reference | int |
| distpsnr1 | Distance of closest source from PS1 catalog; if exists within 30 arcsec [arcsec] | float |
| sgscore1 | Star/Galaxy score of closest source from PS1 catalog 0 <= sgscore <= 1 where closer to 1 implies higher likelihood of being a star | float |
| sgmag1 | g-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec | float |
| srmag1 | r-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec | float |
| htm16 | Hierarchical Triangular Mesh level 16 | bigint |
| g_minus_r | Value of g-r on most recent night when both were available and both positive difference magnitudes | float |
| jd_g_minus_r | Julian date of most recent g measure on a night when both ag and r were available and both positive difference magnitudes | double |
| ncandgp_7 | Number in light curve with good quality and brighter than reference in last 7 days | int |
| ncandgp_14 | Number in light curve with good quality and brighter than reference in last 14 days | int |
| ssnamenr | MPC name of Solar System object | string |
| dmdt_g_err | Error estimate for dmdt_g | float |
| dmdt_r_err | Error estimate for dmdt_r | float |
| objectId | ZTF object identifier, also known as transient_object_id | string |
| classification | Top-ranked contextual classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS) | string |
| association_type | Association classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS) | string |
| catalogue_table_name | Name/s of catalogue/s from which the best crossmatch is made | bigstring |
| catalogue_object_id | Identifier in the catalogue/s from which the best crossmatch is made | bigstring |
| catalogue_object_type | Type of catalogue from which the best crossmatch is made | string |
| raDeg | RA in degrees of the transient | double |
| decDeg | Dec in degrees of the transient | double |
| separationArcsec | Transient's angular separation (arcseconds) from the top-ranked catalogue source match | float |
| northSeparationArcsec | Transient's angular separation (arcseconds) from the top-ranked catalogue source match | float |
| eastSeparationArcsec | Transient's angular separation (arcseconds) from the top-ranked catalogue source match | float |
| physical_separation_kpc | Distance in kilo parsec between transient and top-ranked catalogue source match | float |
| direct_distance | Determined from a non-redshift related measurement - e.g. Cepheids/standard candle (Mpc) | float |
| distance | Luminosity distance -- conversion from the spectral redshift (Mpc) | float |
| z | Redshift of the top-ranked catalogue source match | float |
| photoZ | Redshift of the top-ranked catalogue source match | float |
| photoZErr | Redshift of the top-ranked catalogue source match | float |
| Mag | Magnitude | float |
| MagFilter | Magnitude filter | string |
| MagErr | Magnitude error | float |
| classificationReliability | Reliability of classification | int |
| major_axis_arcsec | Size of associated galaxy in arcsec | float |
| annotator | Information about this annotation | bigstring |
| additional_output | Addititonal information about this annotation | bigstring |
| description | Long-form, human-readable summary of the transient's characteristics as infered from Sherlock's classification | text |
| summary | Short-form summary of the transient's context usual for webpage quick-look summaries | bigstring |
| ra | Right ascension in decimal degrees | double |
| decl | Declination in decimal degrees | double |
| tns_name | TNS name, for example 2021iru | string |
| tns_prefix | For example SN or AT | string |
| disc_mag | Discovery magnitude | float |
| disc_mag_filter | string | string |
| type | Astrophysical type of supernova, eg SN Ia | bigstring |
| z | Redshift | float |
| hostz | Redshift of host galaxy | float |
| host_name | Name of host galaxy | bigstring |
| ext_catalogs | External catalogues used | bigstring |
| disc_int_name | Discoverers internal name | bigstring |
| disc_date | Discovery date | date |
| lastmodified_date | Last Modified date | date |
| sender | Discoverers internal name | string |
| reporters | Discoverers internal name | bigstring |
| source_group | Discoverers internal name | string |
| htm16 | Hierarchical Triangular Mesh level 16 | bigint |
| lasairmodified_date | Lasair last Modified date | timestamp |
| annotationID | auto increment counter | int |
| objectId | ObjectId of the object that this annotator applies to | string |
| topic | The topic name of the annotator -- acts as primary key | string |
| version | Version information for the annotator software | string |
| timestamp | Time at which this annotation was added to the database | timestamp |
| classification | Short, non-trivial string expressing the classification of this object by this annotator | string |
| explanation | Natural language explanation of the classification | text |
| classdict | Machine readable informayion about the classification | JSON |
| url | URL for further information about this annotation of this object | text |
