Basic information. ID, position, proper motion.

table.column	Description
objects.diaObjectId	ID for this object
objects.ra	Mean RA of this object
objects.decl	Mean Dec of this object
objects.pmRa	Proper motion in right ascension (mas/yr)
objects.pmDec	Proper motion in declination (mas/yr)

Lightcurve interval. MJD of the first and last diaSource of this diaObject.

table.column	Description
objects.lastDiaSourceMJD	Latest MJD of a diaSource
objects.firstDiaSourceMJD	Earliest MJD of a diaSource

Latest Flux. Most recent fluxes with errors.

table.column	Description
objects.u_psfFlux	Latest u flux (nJy)
objects.u_latestMJD	MJD of Latest u flux
objects.u_psfFluxMean	Weighted mean point-source model magnitude for u filter. (nJy)
objects.u_psfFluxMeanErr	Standard error of u_psfFluxMean. (nJy)
objects.g_psfFlux	Latest g flux (nJy)
objects.g_latestMJD	MJD of Latest g flux
objects.g_psfFluxMean	Weighted mean point-source model magnitude for g filter. (nJy)
objects.g_psfFluxMeanErr	Standard error of g_psfFluxMean. (nJy)
objects.r_psfFlux	Latest r flux (nJy)
objects.r_latestMJD	MJD of Latest r flux
objects.r_psfFluxMean	Weighted mean point-source model magnitude for r filter. (nJy)
objects.r_psfFluxMeanErr	Standard error of r_psfFluxMean. (nJy)
objects.i_psfFlux	Latest i flux (nJy)
objects.i_latestMJD	MJD of Latest i flux
objects.i_psfFluxMean	Weighted mean point-source model magnitude for i filter. (nJy)
objects.i_psfFluxMeanErr	Standard error of i_psfFluxMean. (nJy)
objects.z_psfFlux	Latest z flux (nJy)
objects.z_latestMJD	MJD of Latest z flux
objects.z_psfFluxMean	Weighted mean point-source model magnitude for z filter. (nJy)
objects.z_psfFluxMeanErr	Standard error of z_psfFluxMean. (nJy)
objects.y_psfFlux	Latest y flux (nJy)
objects.y_latestMJD	MJD of Latest y flux
objects.y_psfFluxMean	Weighted mean point-source model magnitude for y filter. (nJy)
objects.y_psfFluxMeanErr	Standard error of y_psfFluxMean. (nJy)

Counting. Counts of diaSources of different bands.

table.column	Description
objects.nSources	Number of diaSources associated with this diaObject
objects.nuSources	Number of u sources
objects.ngSources	Number of g sources
objects.nrSources	Number of r sources
objects.niSources	Number of i sources
objects.nzSources	Number of z sources
objects.nySources	Number of y sources

Other/Nearest objects. Other/Nearest objects from LSST and other catalogs.

table.column	Description
objects.tns_name	TNS name of this object if it exists
objects.nearbyObj1	Id of the closest nearby object.
objects.nearbyObj1Dist	Distance to nearbyObj1 (arcsec)
objects.nearbyObj1LnP	Natural log of the probability that the observed diaObject is the same as the nearbyObj1.

Absolute magnitude. Brightness at 1 parsec.

table.column	Description
objects.absMag	Peak absolute magnitude (extinction corrected) if host galaxy with distance available
objects.absMagMJD	Peak absolute magnitude time if host galaxy with distance available

BazinBlackBody (BBB). Lightcurve fit as Bazin or Exp in time, Blackbody in wavelength.

table.column	Description
objects.BBBRiseRate	Fitted Bazin or Exp rise rate
objects.BBBFallRate	Fitted Bazin fall rate or NULL if Exp
objects.BBBTemp	Fitted Bazin temperature, (kiloKelvins)
objects.BBBPeakFlux	If Bazin fit, the peak flux (nJy)
objects.BBBPeakMJD	If Bazin fit, the time of the peak brightness
objects.BBBPeakAbsMag	If Bazin fit and Sherlock host with distance, the peak absolute magnitude

Milky Way. Galactic latitude and extinction.

table.column	Description
objects.glat	Galactic latitude
objects.ebv	Extinction E(B-V) Schlegel, Finkbeiner & Davis (1998)

Jump detector. Number of sigma jump from 20 day mean.

table.column	Description
objects.jump1	Largest sigma jump of recent flux from previous -70 to -10 days
objects.jump2	Largest sigma jump of recent flux in different band from previous -70 to -10 days

Pair colours. Colours from 33-minute paired diaSources.

table.column	Description
objects.latestPairMJD	Latest pair MJD
objects.latestPairColourMag	Magnitude difference from latest pair
objects.latestPairColourBands	Bands used for latest pair colour, eg g-r, u-r
objects.latestPairColourTemp	Extinction corrected effective temperature from latest pair, kiloKelvin
objects.penultimatePairMJD	Penultimate pair MJD
objects.penultimatePairColourMag	Magnitude difference from Penultimate pair
objects.penultimatePairColourBands	Bands used for penultimate pair colour, eg g-r, u-r
objects.penultimatePairColourTemp	Extinction corrected effective temperature from penultimate pair, kiloKelvin

Utility. Other attributes.

table.column	Description
objects.htm16	Hierarchical Triangular Mesh level 16
objects.timestamp	Time at which this object last modified

table.column	Description
crossmatch_tns.ra	Right ascension in decimal degrees
crossmatch_tns.decl	Declination in decimal degrees
crossmatch_tns.tns_name	TNS name, for example 2021iru
crossmatch_tns.tns_prefix	For example SN or AT
crossmatch_tns.disc_mag	Discovery magnitude
crossmatch_tns.disc_mag_filter	string
crossmatch_tns.type	Astrophysical type of supernova, eg SN Ia
crossmatch_tns.z	Redshift
crossmatch_tns.hostz	Redshift of host galaxy
crossmatch_tns.host_name	Name of host galaxy
crossmatch_tns.ext_catalogs	External catalogues used
crossmatch_tns.disc_int_name	Discoverers internal name
crossmatch_tns.disc_date	Discovery date
crossmatch_tns.lastmodified_date	Last Modified date
crossmatch_tns.sender	Discoverers internal name
crossmatch_tns.reporters	Discoverers internal name
crossmatch_tns.source_group	Discoverers internal name
crossmatch_tns.htm16	Hierarchical Triangular Mesh level 16
crossmatch_tns.lasairmodified_date	Lasair last Modified date

table.column	Description
sherlock_classifications.diaObjectId	ZTF object identifier, also known as transient_object_id
sherlock_classifications.classification	Top-ranked contextual classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS)
sherlock_classifications.association_type	Association classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS)
sherlock_classifications.catalogue_table_name	Name/s of catalogue/s from which the best crossmatch is made
sherlock_classifications.catalogue_object_id	Identifier in the catalogue/s from which the best crossmatch is made
sherlock_classifications.catalogue_object_type	Type of catalogue from which the best crossmatch is made
sherlock_classifications.raDeg	RA in degrees of the transient
sherlock_classifications.decDeg	Dec in degrees of the transient
sherlock_classifications.separationArcsec	Transient's angular separation (arcseconds) from the top-ranked catalogue source match
sherlock_classifications.northSeparationArcsec	Transient's angular separation (arcseconds) from the top-ranked catalogue source match
sherlock_classifications.eastSeparationArcsec	Transient's angular separation (arcseconds) from the top-ranked catalogue source match
sherlock_classifications.physical_separation_kpc	Distance in kilo parsec between transient and top-ranked catalogue source match
sherlock_classifications.direct_distance	Determined from a non-redshift related measurement - e.g. Cepheids/standard candle (Mpc)
sherlock_classifications.distance	Luminosity distance -- conversion from the spectral redshift (Mpc)
sherlock_classifications.z	Redshift of the top-ranked catalogue source match
sherlock_classifications.photoZ	Redshift of the top-ranked catalogue source match
sherlock_classifications.photoZErr	Redshift of the top-ranked catalogue source match
sherlock_classifications.Mag	Magnitude
sherlock_classifications.MagFilter	Magnitude filter
sherlock_classifications.MagErr	Magnitude error
sherlock_classifications.classificationReliability	Reliability of classification
sherlock_classifications.major_axis_arcsec	Size of associated galaxy in arcsec
sherlock_classifications.annotator	Information about this annotation
sherlock_classifications.additional_output	Addititonal information about this annotation
sherlock_classifications.description	Long-form, human-readable summary of the transient's characteristics as infered from Sherlock's classification
sherlock_classifications.summary	Short-form summary of the transient's context usual for webpage quick-look summaries

table.column	Description
<annotator>.annotationID	auto increment counter
<annotator>.diaObjectId	ObjectId of the object that this annotator applies to
<annotator>.topic	The topic name of the annotator -- acts as primary key
<annotator>.version	Version information for the annotator software
<annotator>.timestamp	Time at which this annotation was added to the database
<annotator>.classification	Short, non-trivial string expressing the classification of this object by this annotator
<annotator>.explanation	Natural language explanation of the classification
<annotator>.classdict	Machine readable informayion about the classification
<annotator>.url	URL for further information about this annotation of this object

table.column	Description
watchlist_hits.diaObjectId	ZTF object identifier
watchlist_hits.wl_id	Watchlist identifier in watchlists
watchlist_hits.cone_id	Cone identifier in watchlist_cones
watchlist_hits.arcsec	Distance between ZTF and watchlist source (arcsec)
watchlist_hits.name	Name of cone given by user

table.column	Description
objects-ext.raErr	Uncertainty of ra.
objects-ext.decErr	Uncertainty of dec.
objects-ext.ra_dec_Cov	Covariance between ra and dec.
objects-ext.radecMjdTai	Time at which the object was at a position ra/dec, expressed as Modified Julian Date, International Atomic Time.
objects-ext.pmRaErr	Uncertainty of pmRa.
objects-ext.pmDecErr	Uncertainty of pmDec.
objects-ext.parallax	Parallax.
objects-ext.parallaxErr	Uncertainty of parallax.
objects-ext.pmRa_pmDec_Cov	Covariance of pmRa and pmDec.
objects-ext.pmRa_parallax_Cov	Covariance of pmRa and parallax.
objects-ext.pmDec_parallax_Cov	Covariance of pmDec and parallax.
objects-ext.pmParallaxLnL	Natural log of the likelihood of the linear proper motion parallax fit.
objects-ext.pmParallaxChi2	Chi^2 static of the model fit.
objects-ext.pmParallaxNdata	The number of data points used to fit the model.
objects-ext.u_psfFluxSigma	Standard deviation of the distribution of u_psfFlux.
objects-ext.u_psfFluxChi2	Chi^2 statistic for the scatter of u_psfFlux around u_psfFluxMean.
objects-ext.u_psfFluxNdata	The number of data points used to compute u_psfFluxChi2.
objects-ext.u_fpFluxMean	Weighted mean forced photometry flux for u filter.
objects-ext.u_fpFluxMeanErr	Standard error of u_fpFluxMean.
objects-ext.u_fpFluxSigma	Standard deviation of the distribution of u_fpFlux.
objects-ext.g_psfFluxSigma	Standard deviation of the distribution of g_psfFlux.
objects-ext.g_psfFluxChi2	Chi^2 statistic for the scatter of g_psfFlux around g_psfFluxMean.
objects-ext.g_psfFluxNdata	The number of data points used to compute g_psfFluxChi2.
objects-ext.g_fpFluxMean	Weighted mean forced photometry flux for g filter.
objects-ext.g_fpFluxMeanErr	Standard error of g_fpFluxMean.
objects-ext.g_fpFluxSigma	Standard deviation of the distribution of g_fpFlux.
objects-ext.r_psfFluxSigma	Standard deviation of the distribution of r_psfFlux.
objects-ext.r_psfFluxChi2	Chi^2 statistic for the scatter of r_psfFlux around r_psfFluxMean.
objects-ext.r_psfFluxNdata	The number of data points used to compute r_psfFluxChi2.
objects-ext.r_fpFluxMean	Weighted mean forced photometry flux for r filter.
objects-ext.r_fpFluxMeanErr	Standard error of r_fpFluxMean.
objects-ext.r_fpFluxSigma	Standard deviation of the distribution of r_fpFlux.
objects-ext.i_psfFluxSigma	Standard deviation of the distribution of i_psfFlux.
objects-ext.i_psfFluxChi2	Chi^2 statistic for the scatter of i_psfFlux around i_psfFluxMean.
objects-ext.i_psfFluxNdata	The number of data points used to compute i_psfFluxChi2.
objects-ext.i_fpFluxMean	Weighted mean forced photometry flux for i filter.
objects-ext.i_fpFluxMeanErr	Standard error of i_fpFluxMean.
objects-ext.i_fpFluxSigma	Standard deviation of the distribution of i_fpFlux.
objects-ext.z_psfFluxSigma	Standard deviation of the distribution of z_psfFlux.
objects-ext.z_psfFluxChi2	Chi^2 statistic for the scatter of z_psfFlux around z_psfFluxMean.
objects-ext.z_psfFluxNdata	The number of data points used to compute z_psfFluxChi2.
objects-ext.z_fpFluxMean	Weighted mean forced photometry flux for z filter.
objects-ext.z_fpFluxMeanErr	Standard error of z_fpFluxMean.
objects-ext.z_fpFluxSigma	Standard deviation of the distribution of z_fpFlux.
objects-ext.y_psfFluxSigma	Standard deviation of the distribution of y_psfFlux.
objects-ext.y_psfFluxChi2	Chi^2 statistic for the scatter of y_psfFlux around y_psfFluxMean.
objects-ext.y_psfFluxNdata	The number of data points used to compute y_psfFluxChi2.
objects-ext.y_fpFluxMean	Weighted mean forced photometry flux for y filter.
objects-ext.y_fpFluxMeanErr	Standard error of y_fpFluxMean.
objects-ext.y_fpFluxSigma	Standard deviation of the distribution of y_fpFlux.
objects-ext.nearbyObj2	Id of the second-closest nearby object.
objects-ext.nearbyObj2Dist	Distance to nearbyObj2.
objects-ext.nearbyObj2LnP	Natural log of the probability that the observed diaObject is the same as the nearbyObj2.
objects-ext.nearbyObj3	Id of the third-closest nearby object.
objects-ext.nearbyObj3Dist	Distance to nearbyObj3.
objects-ext.nearbyObj3LnP	Natural log of the probability that the observed diaObject is the same as the nearbyObj3.
objects-ext.u_psfFluxErrMean	Mean of the u band flux errors.
objects-ext.g_psfFluxErrMean	Mean of the g band flux errors.
objects-ext.r_psfFluxErrMean	Mean of the r band flux errors.
objects-ext.i_psfFluxErrMean	Mean of the i band flux errors.
objects-ext.z_psfFluxErrMean	Mean of the z band flux errors.
objects-ext.y_psfFluxErrMean	Mean of the y band flux errors.