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

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

table.column	Description
objects.lastDiaSourceMjdTai	Latest MJD of a diaSource
objects.firstDiaSourceMjdTai	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

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.validityStartMjdTai	Processing time when validity of this diaObject starts, expressed as Modified Julian Date, International Atomic Time.
objects-ext.raErr	Uncertainty of ra [deg].
objects-ext.decErr	Uncertainty of dec [deg].
objects-ext.ra_dec_Cov	Covariance between ra and dec [deg**2].
objects-ext.u_psfFluxSigma	Standard deviation of the distribution of u_psfFlux [nJy].
objects-ext.u_psfFluxNdata	The number of u-band data points.
objects-ext.u_fpFluxMean	Weighted mean forced photometry flux for u filter [nJy].
objects-ext.u_fpFluxMeanErr	Standard error of u_fpFluxMean [nJy].
objects-ext.g_psfFluxSigma	Standard deviation of the distribution of g_psfFlux [nJy].
objects-ext.g_psfFluxNdata	The number of g-band data points.
objects-ext.g_fpFluxMean	Weighted mean forced photometry flux for g filter [nJy].
objects-ext.g_fpFluxMeanErr	Standard error of g_fpFluxMean [nJy].
objects-ext.r_psfFluxSigma	Standard deviation of the distribution of r_psfFlux [nJy].
objects-ext.r_psfFluxNdata	The number of r-band data points.
objects-ext.r_fpFluxMean	Weighted mean forced photometry flux for r filter [nJy].
objects-ext.r_fpFluxMeanErr	Standard error of r_fpFluxMean [nJy].
objects-ext.i_psfFluxSigma	Standard deviation of the distribution of i_psfFlux [nJy].
objects-ext.i_psfFluxNdata	The number of i-band data points.
objects-ext.i_fpFluxMean	Weighted mean forced photometry flux for i filter [nJy].
objects-ext.i_fpFluxMeanErr	Standard error of i_fpFluxMean [nJy].
objects-ext.z_psfFluxSigma	Standard deviation of the distribution of z_psfFlux [nJy].
objects-ext.z_psfFluxNdata	The number of z-band data points.
objects-ext.z_fpFluxMean	Weighted mean forced photometry flux for z filter [nJy].
objects-ext.z_fpFluxMeanErr	Standard error of z_fpFluxMean [nJy].
objects-ext.y_psfFluxSigma	Standard deviation of the distribution of y_psfFlux [nJy].
objects-ext.y_psfFluxNdata	The number of y-band data points.
objects-ext.y_fpFluxMean	Weighted mean forced photometry flux for y filter [nJy].
objects-ext.y_fpFluxMeanErr	Standard error of y_fpFluxMean [nJy].
objects-ext.u_scienceFluxMean	Weighted mean forced photometry flux for u filter [nJy].
objects-ext.u_scienceFluxMeanErr	Standard error of u_scienceFluxMean [nJy].
objects-ext.g_scienceFluxMean	Weighted mean forced photometry flux for g filter [nJy].
objects-ext.g_scienceFluxMeanErr	Standard error of g_scienceFluxMean [nJy].
objects-ext.r_scienceFluxMean	Weighted mean forced photometry flux for r filter [nJy].
objects-ext.r_scienceFluxMeanErr	Standard error of r_scienceFluxMean [nJy].
objects-ext.i_scienceFluxMean	Weighted mean forced photometry flux for i filter [nJy].
objects-ext.i_scienceFluxMeanErr	Standard error of i_scienceFluxMean [nJy].
objects-ext.z_scienceFluxMean	Weighted mean forced photometry flux for z filter [nJy].
objects-ext.z_scienceFluxMeanErr	Standard error of z_scienceFluxMean [nJy].
objects-ext.y_scienceFluxMean	Weighted mean forced photometry flux for y filter [nJy].
objects-ext.y_scienceFluxMeanErr	Standard error of y_scienceFluxMean [nJy].
objects-ext.u_psfFluxMin	Minimum observed u band fluxes [nJy].
objects-ext.u_psfFluxMax	Maximum observed u band fluxes [nJy].
objects-ext.u_psfFluxMaxSlope	Maximum slope between u band flux obsevations max(delta_flux/delta_time) [nJy/d].
objects-ext.u_psfFluxErrMean	Mean of the u band flux errors [nJy].
objects-ext.g_psfFluxMin	Minimum observed g band fluxes [nJy].
objects-ext.g_psfFluxMax	Maximum observed g band fluxes [nJy].
objects-ext.g_psfFluxMaxSlope	Maximum slope between g band flux obsevations max(delta_flux/delta_time) [nJy/d].
objects-ext.g_psfFluxErrMean	Mean of the g band flux errors [nJy].
objects-ext.r_psfFluxMin	Minimum observed r band fluxes [nJy].
objects-ext.r_psfFluxMax	Maximum observed r band fluxes [nJy].
objects-ext.r_psfFluxMaxSlope	Maximum slope between r band flux obsevations max(delta_flux/delta_time) [nJy/d].
objects-ext.r_psfFluxErrMean	Mean of the r band flux errors [nJy].
objects-ext.i_psfFluxMin	Minimum observed i band fluxes [nJy].
objects-ext.i_psfFluxMax	Maximum observed i band fluxes [nJy].
objects-ext.i_psfFluxMaxSlope	Maximum slope between i band flux obsevations max(delta_flux/delta_time) [nJy/d].
objects-ext.i_psfFluxErrMean	Mean of the i band flux errors [nJy].
objects-ext.z_psfFluxMin	Minimum observed z band fluxes [nJy].
objects-ext.z_psfFluxMax	Maximum observed z band fluxes [nJy].
objects-ext.z_psfFluxMaxSlope	Maximum slope between z band flux obsevations max(delta_flux/delta_time) [nJy/d].
objects-ext.z_psfFluxErrMean	Mean of the z band flux errors [nJy].
objects-ext.y_psfFluxMin	Minimum observed y band fluxes [nJy].
objects-ext.y_psfFluxMax	Maximum observed y band fluxes [nJy].
objects-ext.y_psfFluxMaxSlope	Maximum slope between y band flux obsevations max(delta_flux/delta_time) [nJy/d].
objects-ext.y_psfFluxErrMean	Mean of the y band flux errors [nJy].
objects-ext.nDiaSources	Total number of DiaSources associated with this DiaObject.