Schemas for the tables

All attributes are floating point or double unless otherwise noted.

Schema for "objects" table

objectIdZTF object identifierstring
decmeanMean Dec in degreesdouble
decstdStandard deviation of Dec in arcsecondsdouble
rameanMean RA in degreesdouble
rastdStandard deviation of RA in arcsecondsdouble
glatmeanMean galactic latitude in degreesdouble
glonmeanMean galactic longitude in degreesdouble
jdgmaxLatest Julian Day of g mag candidatesdouble
gmagLatest g magnitude float
dmdt_gmost recent increase in g magnitude divided by time difference, (brightening = positive)float
dmdt_g_2deprecated -- always Nullfloat
mag_g02Latest Exponential Moving Average of difference magnitude in g band, with 2-day timescale (see note)float
mag_g08Latest Exponential Moving Average of difference magnitude in g band, with 8-day timescale (see note)float
mag_g28Latest Exponential Moving Average of difference magnitude in g band, with 28-day timescale (see note)float
maggmaxMaximum g magnitude of light curve (faintest)float
maggmeanMean g magnitude of light curvefloat
maggminMinimum g magnitude of light curve (brightest)float
jdrmaxLatest Julian Day of r mag candidatesdouble
mag_r02Latest Exponential Moving Average of difference magnitude in r band, with 2-day timescale (see note)float
mag_r08Latest Exponential Moving Average of difference magnitude in r band, with 8-day timescale (see note)float
mag_r28Latest Exponential Moving Average of difference magnitude in r band, with 28-day timescale (see note)float
rmaglatest r magnitudefloat
dmdt_rmost recent increase in r magnitude divided by time difference, (brightening = positive)float
dmdt_r_2deprecated -- always Nullfloat
magrmaxMaximum r magnitude of light curve (faintest)float
magrmeanMean r magnitude of light curvefloat
magrminMinimum r magnitude of light curve (brightest)float
jdmaxMaximum of jdgmax and jdrmaxdouble
jdminEarliest Julian Day of candidates that cite this objectdouble
ncandNumber in light curveint
ncandgpNumber in light curve with good quality and brighter than referenceint
distpsnr1Distance of closest source from PS1 catalog; if exists within 30 arcsec [arcsec]float
sgscore1Star/Galaxy score of closest source from PS1 catalog 0 <= sgscore <= 1 where closer to 1 implies higher likelihood of being a starfloat
sgmag1g-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsecfloat
srmag1r-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsecfloat
htm16Hierarchical Triangular Mesh level 16bigint
g_minus_rValue of g-r on most recent night when both were available and both positive difference magnitudesfloat
jd_g_minus_rJulian date of most recent g measure on a night when both ag and r were available and both positive difference magnitudesdouble
ncandgp_7Number in light curve with good quality and brighter than reference in last 7 daysint
ncandgp_14Number in light curve with good quality and brighter than reference in last 14 daysint
ssnamenrMPC name of Solar System objectstring
dmdt_g_errError estimate for dmdt_gfloat
dmdt_r_errError estimate for dmdt_rfloat

Schema for "sherlock_classifications" table

(for more information see Sherlock documentation)
objectIdZTF object identifier, also known as transient_object_idstring
classificationTop-ranked contextual classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS)string
association_typeAssociation classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS)string
catalogue_table_nameName/s of catalogue/s from which the best crossmatch is madebigstring
catalogue_object_idIdentifier in the catalogue/s from which the best crossmatch is madebigstring
catalogue_object_typeType of catalogue from which the best crossmatch is madestring
raDegRA in degrees of the transientdouble
decDegDec in degrees of the transientdouble
separationArcsecTransient's angular separation (arcseconds) from the top-ranked catalogue source matchfloat
northSeparationArcsecTransient's angular separation (arcseconds) from the top-ranked catalogue source matchfloat
eastSeparationArcsecTransient's angular separation (arcseconds) from the top-ranked catalogue source matchfloat
physical_separation_kpcDistance in kilo parsec between transient and top-ranked catalogue source matchfloat
direct_distanceDetermined from a non-redshift related measurement - e.g. Cepheids/standard candle (Mpc)float
distanceLuminosity distance -- conversion from the spectral redshift (Mpc)float
zRedshift of the top-ranked catalogue source matchfloat
photoZRedshift of the top-ranked catalogue source matchfloat
photoZErrRedshift of the top-ranked catalogue source matchfloat
MagMagnitudefloat
MagFilterMagnitude filterstring
MagErrMagnitude errorfloat
classificationReliabilityReliability of classificationint
major_axis_arcsecSize of associated galaxy in arcsecfloat
annotatorInformation about this annotationbigstring
additional_outputAddititonal information about this annotationbigstring
descriptionLong-form, human-readable summary of the transient's characteristics as infered from Sherlock's classificationtext
summaryShort-form summary of the transient's context usual for webpage quick-look summariesbigstring

Schema for "crossmatch_tns" table

raRight ascension in decimal degreesdouble
declDeclination in decimal degreesdouble
tns_nameTNS name, for example 2021irustring
tns_prefixFor example SN or ATstring
disc_magDiscovery magnitudefloat
disc_mag_filterstringstring
typeAstrophysical type of supernova, eg SN Iabigstring
zRedshiftfloat
hostzRedshift of host galaxyfloat
host_nameName of host galaxybigstring
ext_catalogsExternal catalogues usedbigstring
disc_int_nameDiscoverers internal namebigstring
disc_dateDiscovery datedate
lastmodified_dateLast Modified datedate
senderDiscoverers internal namestring
reportersDiscoverers internal namebigstring
source_groupDiscoverers internal namestring
htm16Hierarchical Triangular Mesh level 16bigint
lasairmodified_dateLasair last Modified datetimestamp

Schema for "annotations" table

annotationIDauto increment counterint
objectIdObjectId of the object that this annotator applies tostring
topicThe topic name of the annotator -- acts as primary keystring
versionVersion information for the annotator softwarestring
timestampTime at which this annotation was added to the databasetimestamp
classificationShort, non-trivial string expressing the classification of this object by this annotatorstring
explanationNatural language explanation of the classificationtext
classdictMachine readable informayion about the classificationJSON
urlURL for further information about this annotation of this objecttext