apdb.yaml

---
name: "ApdbSchema"
"@id": "#apdbSchema"
version: "0.1.1"
description: The Alert Production Database (APDB) contains the catalogs resulting from
  image differencing during nightly Prompt Processing as well as the results of
  daily Solar System Processing.
tables:
- name: metadata
  "@id": "#metadata"
  description: Table containing various metadata key:value pairs for APDB.
  columns:
  - name: name
    "@id": "#metadata.name"
    datatype: text
    length: 1024
    nullable: false
    description: Name or key for a metadata item.
  - name: value
    "@id": "#metadata.value"
    datatype: text
    length: 65535
    nullable: false
    description: Content of the metadata item in string representation.
  primaryKey: "#metadata.name"
- name: DiaObject
  "@id": "#DiaObject"
  description: The DiaObject table contains descriptions of the astronomical objects
    detected on one or more difference images.
  columns:
  - name: diaObjectId
    "@id": "#DiaObject.diaObjectId"
    datatype: long
    nullable: false
    description: Unique identifier of this DiaObject.
    ivoa:ucd: meta.id;src
  - name: validityStart
    "@id": "#DiaObject.validityStart"
    datatype: timestamp
    length: 6
    nullable: false
    description: Processing time when validity of this diaObject starts.
    mysql:datatype: DATETIME
  - name: validityEnd
    "@id": "#DiaObject.validityEnd"
    datatype: timestamp
    length: 6
    nullable: true
    description: Processing time when validity of this diaObject ends.
    mysql:datatype: DATETIME
  - name: ra
    "@id": "#DiaObject.ra"
    datatype: double
    nullable: false
    description: Right ascension coordinate of the position of the object at time radecMjdTai.
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: raErr
    "@id": "#DiaObject.raErr"
    datatype: float
    description: Uncertainty of ra.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: dec
    "@id": "#DiaObject.dec"
    datatype: double
    nullable: false
    description: Declination coordinate of the position of the object at time radecMjdTai.
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: decErr
    "@id": "#DiaObject.decErr"
    datatype: float
    description: Uncertainty of dec.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: ra_dec_Cov
    "@id": "#DiaObject.ra_dec_Cov"
    datatype: float
    description: Covariance between ra and dec.
    fits:tunit: deg**2
  - name: radecMjdTai
    "@id": "#DiaObject.radecMjdTai"
    datatype: double
    description: Time at which the object was at a position ra/dec, expressed
      as Modified Julian Date, International Atomic Time.
    ivoa:ucd: time.epoch
  - name: pmRa
    "@id": "#DiaObject.pmRa"
    datatype: float
    description: Proper motion in right ascension.
    fits:tunit: mas/yr
    ivoa:ucd: pos.pm
  - name: pmRaErr
    "@id": "#DiaObject.pmRaErr"
    datatype: float
    description: Uncertainty of pmRa.
    fits:tunit: mas/yr
    ivoa:ucd: stat.error;pos.pm
  - name: pmDec
    "@id": "#DiaObject.pmDec"
    datatype: float
    description: Proper motion of declination.
    fits:tunit: mas/yr
    ivoa:ucd: pos.pm
  - name: pmDecErr
    "@id": "#DiaObject.pmDecErr"
    datatype: float
    description: Uncertainty of pmDec.
    fits:tunit: mas/yr
    ivoa:ucd: stat.error;pos.pm
  - name: parallax
    "@id": "#DiaObject.parallax"
    datatype: float
    description: Parallax.
    fits:tunit: mas
    ivoa:ucd: pos.parallax
  - name: parallaxErr
    "@id": "#DiaObject.parallaxErr"
    datatype: float
    description: Uncertainty of parallax.
    fits:tunit: mas
    ivoa:ucd: stat.error;pos.parallax
  - name: pmRa_pmDec_Cov
    "@id": "#DiaObject.pmRa_pmDec_Cov"
    datatype: float
    description: Covariance of pmRa and pmDec.
    fits:tunit: "mas**2/yr**2"
    ivoa:ucd: stat.covariance;pos.eq
  - name: pmRa_parallax_Cov
    "@id": "#DiaObject.pmRa_parallax_Cov"
    datatype: float
    description: Covariance of pmRa and parallax.
    fits:tunit: mas**2/yr
    ivoa:ucd: stat.covariance
  - name: pmDec_parallax_Cov
    "@id": "#DiaObject.pmDec_parallax_Cov"
    datatype: float
    description: Covariance of pmDec and parallax.
    fits:tunit: mas**2/yr
    ivoa:ucd: stat.covariance
  - name: pmParallaxLnL
    "@id": "#DiaObject.pmParallaxLnL"
    datatype: float
    description: Natural log of the likelihood of the linear proper motion parallax
      fit.
    ivoa:ucd: stat.likelihood
  - name: pmParallaxChi2
    "@id": "#DiaObject.pmParallaxChi2"
    datatype: float
    description: Chi^2 static of the model fit.
    ivoa:ucd: stat.fit.chi2
  - name: pmParallaxNdata
    "@id": "#DiaObject.pmParallaxNdata"
    datatype: int
    description: The number of data points used to fit the model.
  - name: u_psfFluxMean
    "@id": "#DiaObject.u_psfFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for u filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: u_psfFluxMeanErr
    "@id": "#DiaObject.u_psfFluxMeanErr"
    datatype: float
    description: Standard error of u_psfFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: u_psfFluxSigma
    "@id": "#DiaObject.u_psfFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of u_psfFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: u_psfFluxChi2
    "@id": "#DiaObject.u_psfFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of u_psfFlux around u_psfFluxMean.
    ivoa:ucd: stat.fit.chi2
  - name: u_psfFluxNdata
    "@id": "#DiaObject.u_psfFluxNdata"
    datatype: int
    description: The number of data points used to compute u_psfFluxChi2.
  - name: u_fpFluxMean
    "@id": "#DiaObject.u_fpFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for u filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: u_fpFluxMeanErr
    "@id": "#DiaObject.u_fpFluxMeanErr"
    datatype: float
    description: Standard error of u_fpFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: u_fpFluxSigma
    "@id": "#DiaObject.u_fpFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of u_fpFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: g_psfFluxMean
    "@id": "#DiaObject.g_psfFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for g filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: g_psfFluxMeanErr
    "@id": "#DiaObject.g_psfFluxMeanErr"
    datatype: float
    description: Standard error of g_psfFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: g_psfFluxSigma
    "@id": "#DiaObject.g_psfFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of g_psfFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: g_psfFluxChi2
    "@id": "#DiaObject.g_psfFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of g_psfFlux around g_psfFluxMean.
    ivoa:ucd: stat.fit.chi2
  - name: g_psfFluxNdata
    "@id": "#DiaObject.g_psfFluxNdata"
    datatype: int
    description: The number of data points used to compute g_psfFluxChi2.
  - name: g_fpFluxMean
    "@id": "#DiaObject.g_fpFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for g filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: g_fpFluxMeanErr
    "@id": "#DiaObject.g_fpFluxMeanErr"
    datatype: float
    description: Standard error of g_fpFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: g_fpFluxSigma
    "@id": "#DiaObject.g_fpFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of g_fpFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: r_psfFluxMean
    "@id": "#DiaObject.r_psfFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for r filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: r_psfFluxMeanErr
    "@id": "#DiaObject.r_psfFluxMeanErr"
    datatype: float
    description: Standard error of r_psfFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: r_psfFluxSigma
    "@id": "#DiaObject.r_psfFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of r_psfFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: r_psfFluxChi2
    "@id": "#DiaObject.r_psfFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of r_psfFlux around r_psfFluxMean.
    ivoa:ucd: stat.fit.chi2
  - name: r_psfFluxNdata
    "@id": "#DiaObject.r_psfFluxNdata"
    datatype: int
    description: The number of data points used to compute r_psfFluxChi2.
  - name: r_fpFluxMean
    "@id": "#DiaObject.r_fpFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for r filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: r_fpFluxMeanErr
    "@id": "#DiaObject.r_fpFluxMeanErr"
    datatype: float
    description: Standard error of r_fpFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: r_fpFluxSigma
    "@id": "#DiaObject.r_fpFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of r_fpFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: i_psfFluxMean
    "@id": "#DiaObject.i_psfFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for i filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: i_psfFluxMeanErr
    "@id": "#DiaObject.i_psfFluxMeanErr"
    datatype: float
    description: Standard error of i_psfFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: i_psfFluxSigma
    "@id": "#DiaObject.i_psfFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of i_psfFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: i_psfFluxChi2
    "@id": "#DiaObject.i_psfFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of i_psfFlux around i_psfFluxMean.
    ivoa:ucd: stat.fit.chi2
  - name: i_psfFluxNdata
    "@id": "#DiaObject.i_psfFluxNdata"
    datatype: int
    description: The number of data points used to compute i_psfFluxChi2.
  - name: i_fpFluxMean
    "@id": "#DiaObject.i_fpFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for i filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: i_fpFluxMeanErr
    "@id": "#DiaObject.i_fpFluxMeanErr"
    datatype: float
    description: Standard error of i_fpFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: i_fpFluxSigma
    "@id": "#DiaObject.i_fpFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of i_fpFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: z_psfFluxMean
    "@id": "#DiaObject.z_psfFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for z filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: z_psfFluxMeanErr
    "@id": "#DiaObject.z_psfFluxMeanErr"
    datatype: float
    description: Standard error of z_psfFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: z_psfFluxSigma
    "@id": "#DiaObject.z_psfFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of z_psfFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: z_psfFluxChi2
    "@id": "#DiaObject.z_psfFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of z_psfFlux around z_psfFluxMean.
    ivoa:ucd: stat.fit.chi2
  - name: z_psfFluxNdata
    "@id": "#DiaObject.z_psfFluxNdata"
    datatype: int
    description: The number of data points used to compute z_psfFluxChi2.
  - name: z_fpFluxMean
    "@id": "#DiaObject.z_fpFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for z filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: z_fpFluxMeanErr
    "@id": "#DiaObject.z_fpFluxMeanErr"
    datatype: float
    description: Standard error of z_fpFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: z_fpFluxSigma
    "@id": "#DiaObject.z_fpFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of z_fpFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: y_psfFluxMean
    "@id": "#DiaObject.y_psfFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for y filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: y_psfFluxMeanErr
    "@id": "#DiaObject.y_psfFluxMeanErr"
    datatype: float
    description: Standard error of y_psfFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: y_psfFluxSigma
    "@id": "#DiaObject.y_psfFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of y_psfFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: y_psfFluxChi2
    "@id": "#DiaObject.y_psfFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of y_psfFlux around y_psfFluxMean.
    ivoa:ucd: stat.fit.chi2
  - name: y_psfFluxNdata
    "@id": "#DiaObject.y_psfFluxNdata"
    datatype: int
    description: The number of data points used to compute y_psfFluxChi2.
  - name: y_fpFluxMean
    "@id": "#DiaObject.y_fpFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for y filter.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: y_fpFluxMeanErr
    "@id": "#DiaObject.y_fpFluxMeanErr"
    datatype: float
    description: Standard error of y_fpFluxMean.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: y_fpFluxSigma
    "@id": "#DiaObject.y_fpFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of y_fpFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.stdev
  - name: u_lcPeriodic
    "@id": "#DiaObject.u_lcPeriodic"
    datatype: binary
    length: 128
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for u filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: g_lcPeriodic
    "@id": "#DiaObject.g_lcPeriodic"
    datatype: binary
    length: 128
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for g filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: r_lcPeriodic
    "@id": "#DiaObject.r_lcPeriodic"
    datatype: binary
    length: 128
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for r filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: i_lcPeriodic
    "@id": "#DiaObject.i_lcPeriodic"
    datatype: binary
    length: 128
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for i filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: z_lcPeriodic
    "@id": "#DiaObject.z_lcPeriodic"
    datatype: binary
    length: 128
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for z filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: y_lcPeriodic
    "@id": "#DiaObject.y_lcPeriodic"
    datatype: binary
    length: 128
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for y filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: u_lcNonPeriodic
    "@id": "#DiaObject.u_lcNonPeriodic"
    datatype: binary
    length: 80
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for u filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: g_lcNonPeriodic
    "@id": "#DiaObject.g_lcNonPeriodic"
    datatype: binary
    length: 80
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for g filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: r_lcNonPeriodic
    "@id": "#DiaObject.r_lcNonPeriodic"
    datatype: binary
    length: 80
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for r filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: i_lcNonPeriodic
    "@id": "#DiaObject.i_lcNonPeriodic"
    datatype: binary
    length: 80
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for i filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: z_lcNonPeriodic
    "@id": "#DiaObject.z_lcNonPeriodic"
    datatype: binary
    length: 80
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for z filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: y_lcNonPeriodic
    "@id": "#DiaObject.y_lcNonPeriodic"
    datatype: binary
    length: 80
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for y filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: nearbyObj1
    "@id": "#DiaObject.nearbyObj1"
    datatype: long
    description: Id of the closest nearby object.
    ivoa:ucd: meta.id;src
  - name: nearbyObj1Dist
    "@id": "#DiaObject.nearbyObj1Dist"
    datatype: float
    description: Distance to nearbyObj1.
    fits:tunit: arcsec
  - name: nearbyObj1LnP
    "@id": "#DiaObject.nearbyObj1LnP"
    datatype: float
    description: Natural log of the probability that the observed diaObject is the
      same as the nearbyObj1.
  - name: nearbyObj2
    "@id": "#DiaObject.nearbyObj2"
    datatype: long
    description: Id of the second-closest nearby object.
    ivoa:ucd: meta.id;src
  - name: nearbyObj2Dist
    "@id": "#DiaObject.nearbyObj2Dist"
    datatype: float
    description: Distance to nearbyObj2.
    fits:tunit: arcsec
  - name: nearbyObj2LnP
    "@id": "#DiaObject.nearbyObj2LnP"
    datatype: float
    description: Natural log of the probability that the observed diaObject is the
      same as the nearbyObj2.
  - name: nearbyObj3
    "@id": "#DiaObject.nearbyObj3"
    datatype: long
    description: Id of the third-closest nearby object.
    ivoa:ucd: meta.id;src
  - name: nearbyObj3Dist
    "@id": "#DiaObject.nearbyObj3Dist"
    datatype: float
    description: Distance to nearbyObj3.
    fits:tunit: arcsec
  - name: nearbyObj3LnP
    "@id": "#DiaObject.nearbyObj3LnP"
    datatype: float
    description: Natural log of the probability that the observed diaObject is the
      same as the nearbyObj3.
  - name: nearbyExtObj1
    "@id": "#DiaObject.nearbyExtObj1"
    datatype: long
    description: Id of the closest extended DR Object by second moment-based separation.
    ivoa:ucd: meta.id;src
  - name: nearbyExtObj1Sep
    "@id": "#DiaObject.nearbyExtObj1Sep"
    datatype: float
    description: Second moment-based separation of nearbyExtObj1 (unitless).
  - name: nearbyExtObj2
    "@id": "#DiaObject.nearbyExtObj2"
    datatype: long
    description: Id of the second closest extended DR Object by second moment-based separation.
    ivoa:ucd: meta.id;src
  - name: nearbyExtObj2Sep
    "@id": "#DiaObject.nearbyExtObj2Sep"
    datatype: float
    description: Second moment-based separation of nearbyExtObj2 (unitless).
  - name: nearbyExtObj3
    "@id": "#DiaObject.nearbyExtObj3"
    datatype: long
    description: Id of the third closest extended DR Object by second moment-based separation.
    ivoa:ucd: meta.id;src
  - name: nearbyExtObj3Sep
    "@id": "#DiaObject.nearbyExtObj3Sep"
    datatype: float
    description: Second moment-based separation of nearbyExtObj3 (unitless).
  - name: nearbyLowzGal
    "@id": "#DiaObject.nearbyLowzGal"
    datatype: string
    length: 64
    description: External catalog name of the nearest low-z potential host.
  - name: nearbyLowzGalSep
    "@id": "#DiaObject.nearbyLowzGalSep"
    datatype: float
    fits:tunit: arcsec
    description: Separation distance of nearbyLowzGal.
  - name: u_scienceFluxMean
    "@id": "#DiaObject.u_scienceFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for u filter.
    ivoa:ucd: phot.count
    fits:tunit: nJy
  - name: u_scienceFluxMeanErr
    "@id": "#DiaObject.u_scienceFluxMeanErr"
    datatype: float
    description: Standard error of u_scienceFluxMean.
    ivoa:ucd: stat.error
    fits:tunit: nJy
  - name: u_scienceFluxSigma
    "@id": "#DiaObject.u_scienceFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of u_scienceFlux.
    ivoa:ucd: stat.stdev
    fits:tunit: nJy
  - name: g_scienceFluxMean
    "@id": "#DiaObject.g_scienceFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for g filter.
    ivoa:ucd: phot.count
    fits:tunit: nJy
  - name: g_scienceFluxMeanErr
    "@id": "#DiaObject.g_scienceFluxMeanErr"
    datatype: float
    description: Standard error of g_scienceFluxMean.
    ivoa:ucd: stat.error
    fits:tunit: nJy
  - name: g_scienceFluxSigma
    "@id": "#DiaObject.g_scienceFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of g_scienceFlux.
    ivoa:ucd: stat.stdev
    fits:tunit: nJy
  - name: r_scienceFluxMean
    "@id": "#DiaObject.r_scienceFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for r filter.
    ivoa:ucd: phot.count
    fits:tunit: nJy
  - name: r_scienceFluxMeanErr
    "@id": "#DiaObject.r_scienceFluxMeanErr"
    datatype: float
    description: Standard error of r_scienceFluxMean.
    ivoa:ucd: stat.error
    fits:tunit: nJy
  - name: r_scienceFluxSigma
    "@id": "#DiaObject.r_scienceFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of r_scienceFlux.
    ivoa:ucd: stat.stdev
    fits:tunit: nJy
  - name: i_scienceFluxMean
    "@id": "#DiaObject.i_scienceFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for i filter.
    ivoa:ucd: phot.count
    fits:tunit: nJy
  - name: i_scienceFluxMeanErr
    "@id": "#DiaObject.i_scienceFluxMeanErr"
    datatype: float
    description: Standard error of i_scienceFluxMean.
    ivoa:ucd: stat.error
    fits:tunit: nJy
  - name: i_scienceFluxSigma
    "@id": "#DiaObject.i_scienceFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of i_scienceFlux.
    ivoa:ucd: stat.stdev
    fits:tunit: nJy
  - name: z_scienceFluxMean
    "@id": "#DiaObject.z_scienceFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for z filter.
    ivoa:ucd: phot.count
    fits:tunit: nJy
  - name: z_scienceFluxMeanErr
    "@id": "#DiaObject.z_scienceFluxMeanErr"
    datatype: float
    description: Standard error of z_scienceFluxMean.
    ivoa:ucd: stat.error
    fits:tunit: nJy
  - name: z_scienceFluxSigma
    "@id": "#DiaObject.z_scienceFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of z_scienceFlux.
    ivoa:ucd: stat.stdev
    fits:tunit: nJy
  - name: y_scienceFluxMean
    "@id": "#DiaObject.y_scienceFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for y filter.
    ivoa:ucd: phot.count
    fits:tunit: nJy
  - name: y_scienceFluxMeanErr
    "@id": "#DiaObject.y_scienceFluxMeanErr"
    datatype: float
    description: Standard error of y_scienceFluxMean.
    ivoa:ucd: stat.error
    fits:tunit: nJy
  - name: y_scienceFluxSigma
    "@id": "#DiaObject.y_scienceFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of y_scienceFlux.
    ivoa:ucd: stat.stdev
    fits:tunit: nJy
  - name: u_psfFluxMAD
    "@id": "#DiaObject.u_psfFluxMAD"
    datatype: float
    description: Median absolute deviation u band fluxes.
    fits:tunit: nJy
  - name: u_psfFluxSkew
    "@id": "#DiaObject.u_psfFluxSkew"
    datatype: float
    description: Skewness of the u band fluxes.
  - name: u_psfFluxPercentile05
    "@id": "#DiaObject.u_psfFluxPercentile05"
    datatype: float
    description: Value at the 5% percentile of the u band fluxes.
    fits:tunit: nJy
  - name: u_psfFluxPercentile25
    "@id": "#DiaObject.u_psfFluxPercentile25"
    datatype: float
    description: Value at the 25% percentile of the u band fluxes.
    fits:tunit: nJy
  - name: u_psfFluxPercentile50
    "@id": "#DiaObject.u_psfFluxPercentile50"
    datatype: float
    description: Value at the 50% percentile (median) of the u band fluxes.
    fits:tunit: nJy
  - name: u_psfFluxPercentile75
    "@id": "#DiaObject.u_psfFluxPercentile75"
    datatype: float
    description: Value at the 75% percentile of the u band fluxes.
    fits:tunit: nJy
  - name: u_psfFluxPercentile95
    "@id": "#DiaObject.u_psfFluxPercentile95"
    datatype: float
    description: Value at the 95% percentile of the u band fluxes.
    fits:tunit: nJy
  - name: u_psfFluxMin
    "@id": "#DiaObject.u_psfFluxMin"
    datatype: float
    description: Minimum observed u band fluxes.
    fits:tunit: nJy
  - name: u_psfFluxMax
    "@id": "#DiaObject.u_psfFluxMax"
    datatype: float
    description: Maximum observed u band fluxes.
    fits:tunit: nJy
  - name: u_psfFluxStetsonJ
    "@id": "#DiaObject.u_psfFluxStetsonJ"
    datatype: float
    description: StetsonJ statistic for the u band fluxes.
  - name: u_psfFluxLinearSlope
    "@id": "#DiaObject.u_psfFluxLinearSlope"
    datatype: float
    description: Linear best fit slope of the u band fluxes.
    fits:tunit: nJy/d
  - name: u_psfFluxLinearIntercept
    "@id": "#DiaObject.u_psfFluxLinearIntercept"
    datatype: float
    description: Linear best fit Intercept of the u band fluxes.
  - name: u_psfFluxMaxSlope
    "@id": "#DiaObject.u_psfFluxMaxSlope"
    datatype: float
    description: Maximum slope between u band flux obsevations max(delta_flux/delta_time).
    fits:tunit: nJy/d
  - name: u_psfFluxErrMean
    "@id": "#DiaObject.u_psfFluxErrMean"
    datatype: float
    description: Mean of the u band flux errors.
    fits:tunit: nJy
  - name: g_psfFluxMAD
    "@id": "#DiaObject.g_psfFluxMAD"
    datatype: float
    description: Median absolute deviation g band fluxes.
    fits:tunit: nJy
  - name: g_psfFluxSkew
    "@id": "#DiaObject.g_psfFluxSkew"
    datatype: float
    description: Skewness of the g band fluxes.
  - name: g_psfFluxPercentile05
    "@id": "#DiaObject.g_psfFluxPercentile05"
    datatype: float
    description: Value at the 5% percentile of the g band fluxes.
    fits:tunit: nJy
  - name: g_psfFluxPercentile25
    "@id": "#DiaObject.g_psfFluxPercentile25"
    datatype: float
    description: Value at the 25% percentile of the g band fluxes.
    fits:tunit: nJy
  - name: g_psfFluxPercentile50
    "@id": "#DiaObject.g_psfFluxPercentile50"
    datatype: float
    description: Value at the 50% percentile (median) of the g band fluxes.
    fits:tunit: nJy
  - name: g_psfFluxPercentile75
    "@id": "#DiaObject.g_psfFluxPercentile75"
    datatype: float
    description: Value at the 75% percentile of the g band fluxes.
    fits:tunit: nJy
  - name: g_psfFluxPercentile95
    "@id": "#DiaObject.g_psfFluxPercentile95"
    datatype: float
    description: Value at the 95% percentile of the g band fluxes.
    fits:tunit: nJy
  - name: g_psfFluxMin
    "@id": "#DiaObject.g_psfFluxMin"
    datatype: float
    description: Minimum observed g band fluxes.
    fits:tunit: nJy
  - name: g_psfFluxMax
    "@id": "#DiaObject.g_psfFluxMax"
    datatype: float
    description: Maximum observed g band fluxes.
    fits:tunit: nJy
  - name: g_psfFluxStetsonJ
    "@id": "#DiaObject.g_psfFluxStetsonJ"
    datatype: float
    description: StetsonJ statistic for the g band fluxes.
  - name: g_psfFluxLinearSlope
    "@id": "#DiaObject.g_psfFluxLinearSlope"
    datatype: float
    description: Linear best fit slope of the g band fluxes.
    fits:tunit: nJy/d
  - name: g_psfFluxLinearIntercept
    "@id": "#DiaObject.g_psfFluxLinearIntercept"
    datatype: float
    description: Linear best fit Intercept of the g band fluxes.
    fits:tunit: nJy
  - name: g_psfFluxMaxSlope
    "@id": "#DiaObject.g_psfFluxMaxSlope"
    datatype: float
    description: Maximum slope between g band flux obsevations max(delta_flux/delta_time).
    fits:tunit: nJy/d
  - name: g_psfFluxErrMean
    "@id": "#DiaObject.g_psfFluxErrMean"
    datatype: float
    description: Mean of the g band flux errors.
    fits:tunit: nJy
  - name: r_psfFluxMAD
    "@id": "#DiaObject.r_psfFluxMAD"
    datatype: float
    description: Median absolute deviation r band fluxes.
    fits:tunit: nJy
  - name: r_psfFluxSkew
    "@id": "#DiaObject.r_psfFluxSkew"
    datatype: float
    description: Skewness of the r band fluxes.
  - name: r_psfFluxPercentile05
    "@id": "#DiaObject.r_psfFluxPercentile05"
    datatype: float
    description: Value at the 5% percentile of the r band fluxes.
    fits:tunit: nJy
  - name: r_psfFluxPercentile25
    "@id": "#DiaObject.r_psfFluxPercentile25"
    datatype: float
    description: Value at the 25% percentile of the r band fluxes.
    fits:tunit: nJy
  - name: r_psfFluxPercentile50
    "@id": "#DiaObject.r_psfFluxPercentile50"
    datatype: float
    description: Value at the 50% percentile (median) of the r band fluxes.
    fits:tunit: nJy
  - name: r_psfFluxPercentile75
    "@id": "#DiaObject.r_psfFluxPercentile75"
    datatype: float
    description: Value at the 75% percentile of the r band fluxes.
    fits:tunit: nJy
  - name: r_psfFluxPercentile95
    "@id": "#DiaObject.r_psfFluxPercentile95"
    datatype: float
    description: Value at the 95% percentile of the r band fluxes.
    fits:tunit: nJy
  - name: r_psfFluxMin
    "@id": "#DiaObject.r_psfFluxMin"
    datatype: float
    description: Minimum observed r band fluxes.
    fits:tunit: nJy
  - name: r_psfFluxMax
    "@id": "#DiaObject.r_psfFluxMax"
    datatype: float
    description: Maximum observed r band fluxes.
    fits:tunit: nJy
  - name: r_psfFluxStetsonJ
    "@id": "#DiaObject.r_psfFluxStetsonJ"
    datatype: float
    description: StetsonJ statistic for the r band fluxes.
  - name: r_psfFluxLinearSlope
    "@id": "#DiaObject.r_psfFluxLinearSlope"
    datatype: float
    description: Linear best fit slope of the r band fluxes.
    fits:tunit: nJy/d
  - name: r_psfFluxLinearIntercept
    "@id": "#DiaObject.r_psfFluxLinearIntercept"
    datatype: float
    description: Linear best fit Intercept of the r band fluxes.
    fits:tunit: nJy
  - name: r_psfFluxMaxSlope
    "@id": "#DiaObject.r_psfFluxMaxSlope"
    datatype: float
    description: Maximum slope between r band flux obsevations max(delta_flux/delta_time).
    fits:tunit: nJy/d
  - name: r_psfFluxErrMean
    "@id": "#DiaObject.r_psfFluxErrMean"
    datatype: float
    description: Mean of the r band flux errors.
    fits:tunit: nJy
  - name: i_psfFluxMAD
    "@id": "#DiaObject.i_psfFluxMAD"
    datatype: float
    description: Median absolute deviation i band fluxes.
    fits:tunit: nJy
  - name: i_psfFluxSkew
    "@id": "#DiaObject.i_psfFluxSkew"
    datatype: float
    description: Skewness of the i band fluxes.
  - name: i_psfFluxPercentile05
    "@id": "#DiaObject.i_psfFluxPercentile05"
    datatype: float
    description: Value at the 5% percentile of the i band fluxes.
    fits:tunit: nJy
  - name: i_psfFluxPercentile25
    "@id": "#DiaObject.i_psfFluxPercentile25"
    datatype: float
    description: Value at the 25% percentile of the i band fluxes.
    fits:tunit: nJy
  - name: i_psfFluxPercentile50
    "@id": "#DiaObject.i_psfFluxPercentile50"
    datatype: float
    description: Value at the 50% percentile (median) of the i band fluxes.
    fits:tunit: nJy
  - name: i_psfFluxPercentile75
    "@id": "#DiaObject.i_psfFluxPercentile75"
    datatype: float
    description: Value at the 75% percentile of the i band fluxes.
    fits:tunit: nJy
  - name: i_psfFluxPercentile95
    "@id": "#DiaObject.i_psfFluxPercentile95"
    datatype: float
    description: Value at the 95% percentile of the i band fluxes.
    fits:tunit: nJy
  - name: i_psfFluxMin
    "@id": "#DiaObject.i_psfFluxMin"
    datatype: float
    description: Minimum observed i band fluxes.
    fits:tunit: nJy
  - name: i_psfFluxMax
    "@id": "#DiaObject.i_psfFluxMax"
    datatype: float
    description: Maximum observed i band fluxes.
    fits:tunit: nJy
  - name: i_psfFluxStetsonJ
    "@id": "#DiaObject.i_psfFluxStetsonJ"
    datatype: float
    description: StetsonJ statistic for the i band fluxes.
  - name: i_psfFluxLinearSlope
    "@id": "#DiaObject.i_psfFluxLinearSlope"
    datatype: float
    description: Linear best fit slope of the i band fluxes.
    fits:tunit: nJy/d
  - name: i_psfFluxLinearIntercept
    "@id": "#DiaObject.i_psfFluxLinearIntercept"
    datatype: float
    description: Linear best fit Intercept of the i band fluxes.
    fits:tunit: nJy
  - name: i_psfFluxMaxSlope
    "@id": "#DiaObject.i_psfFluxMaxSlope"
    datatype: float
    description: Maximum slope between i band flux obsevations max(delta_flux/delta_time).
    fits:tunit: nJy/d
  - name: i_psfFluxErrMean
    "@id": "#DiaObject.i_psfFluxErrMean"
    datatype: float
    description: Mean of the i band flux errors.
    fits:tunit: nJy
  - name: z_psfFluxMAD
    "@id": "#DiaObject.z_psfFluxMAD"
    datatype: float
    description: Median absolute deviation z band fluxes.
    fits:tunit: nJy
  - name: z_psfFluxSkew
    "@id": "#DiaObject.z_psfFluxSkew"
    datatype: float
    description: Skewness of the z band fluxes.
  - name: z_psfFluxPercentile05
    "@id": "#DiaObject.z_psfFluxPercentile05"
    datatype: float
    description: Value at the 5% percentile of the z band fluxes.
    fits:tunit: nJy
  - name: z_psfFluxPercentile25
    "@id": "#DiaObject.z_psfFluxPercentile25"
    datatype: float
    description: Value at the 25% percentile of the z band fluxes.
    fits:tunit: nJy
  - name: z_psfFluxPercentile50
    "@id": "#DiaObject.z_psfFluxPercentile50"
    datatype: float
    description: Value at the 50% percentile (median) of the z band fluxes.
    fits:tunit: nJy
  - name: z_psfFluxPercentile75
    "@id": "#DiaObject.z_psfFluxPercentile75"
    datatype: float
    description: Value at the 75% percentile of the z band fluxes.
    fits:tunit: nJy
  - name: z_psfFluxPercentile95
    "@id": "#DiaObject.z_psfFluxPercentile95"
    datatype: float
    description: Value at the 95% percentile of the z band fluxes.
    fits:tunit: nJy
  - name: z_psfFluxMin
    "@id": "#DiaObject.z_psfFluxMin"
    datatype: float
    description: Minimum observed z band fluxes.
    fits:tunit: nJy
  - name: z_psfFluxMax
    "@id": "#DiaObject.z_psfFluxMax"
    datatype: float
    description: Maximum observed z band fluxes.
    fits:tunit: nJy
  - name: z_psfFluxStetsonJ
    "@id": "#DiaObject.z_psfFluxStetsonJ"
    datatype: float
    description: StetsonJ statistic for the z band fluxes.
  - name: z_psfFluxLinearSlope
    "@id": "#DiaObject.z_psfFluxLinearSlope"
    datatype: float
    description: Linear best fit slope of the z band fluxes.
    fits:tunit: nJy/d
  - name: z_psfFluxLinearIntercept
    "@id": "#DiaObject.z_psfFluxLinearIntercept"
    datatype: float
    description: Linear best fit Intercept of the z band fluxes.
    fits:tunit: nJy
  - name: z_psfFluxMaxSlope
    "@id": "#DiaObject.z_psfFluxMaxSlope"
    datatype: float
    description: Maximum slope between z band flux obsevations max(delta_flux/delta_time).
    fits:tunit: nJy/d
  - name: z_psfFluxErrMean
    "@id": "#DiaObject.z_psfFluxErrMean"
    datatype: float
    description: Mean of the z band flux errors.
    fits:tunit: nJy
  - name: y_psfFluxMAD
    "@id": "#DiaObject.y_psfFluxMAD"
    datatype: float
    description: Median absolute deviation y band fluxes.
    fits:tunit: nJy
  - name: y_psfFluxSkew
    "@id": "#DiaObject.y_psfFluxSkew"
    datatype: float
    description: Skewness of the y band fluxes.
  - name: y_psfFluxPercentile05
    "@id": "#DiaObject.y_psfFluxPercentile05"
    datatype: float
    description: Value at the 5% percentile of the y band fluxes.
    fits:tunit: nJy
  - name: y_psfFluxPercentile25
    "@id": "#DiaObject.y_psfFluxPercentile25"
    datatype: float
    description: Value at the 25% percentile of the y band fluxes.
    fits:tunit: nJy
  - name: y_psfFluxPercentile50
    "@id": "#DiaObject.y_psfFluxPercentile50"
    datatype: float
    description: Value at the 50% percentile (median) of the y band fluxes.
    fits:tunit: nJy
  - name: y_psfFluxPercentile75
    "@id": "#DiaObject.y_psfFluxPercentile75"
    datatype: float
    description: Value at the 75% percentile of the y band fluxes.
    fits:tunit: nJy
  - name: y_psfFluxPercentile95
    "@id": "#DiaObject.y_psfFluxPercentile95"
    datatype: float
    description: Value at the 95% percentile of the y band fluxes.
    fits:tunit: nJy
  - name: y_psfFluxMin
    "@id": "#DiaObject.y_psfFluxMin"
    datatype: float
    description: Minimum observed y band fluxes.
    fits:tunit: nJy
  - name: y_psfFluxMax
    "@id": "#DiaObject.y_psfFluxMax"
    datatype: float
    description: Maximum observed y band fluxes.
    fits:tunit: nJy
  - name: y_psfFluxStetsonJ
    "@id": "#DiaObject.y_psfFluxStetsonJ"
    datatype: float
    description: StetsonJ statistic for the y band fluxes.
  - name: y_psfFluxLinearSlope
    "@id": "#DiaObject.y_psfFluxLinearSlope"
    datatype: float
    description: Linear best fit slope of the y band fluxes.
    fits:tunit: nJy/d
  - name: y_psfFluxLinearIntercept
    "@id": "#DiaObject.y_psfFluxLinearIntercept"
    datatype: float
    description: Linear best fit Intercept of the y band fluxes.
    fits:tunit: nJy
  - name: y_psfFluxMaxSlope
    "@id": "#DiaObject.y_psfFluxMaxSlope"
    datatype: float
    description: Maximum slope between y band flux obsevations max(delta_flux/delta_time)
    fits:tunit: nJy/d
  - name: y_psfFluxErrMean
    "@id": "#DiaObject.y_psfFluxErrMean"
    datatype: float
    description: Mean of the y band flux errors.
    fits:tunit: nJy
  - name: flags
    "@id": "#DiaObject.flags"
    datatype: long
    nullable: false
    value: 0
    description: Flags, bitwise OR tbd.
    ivoa:ucd: meta.code
  - name: lastNonForcedSource
    "@id": "#DiaObject.lastNonForcedSource"
    datatype: timestamp
    length: 6
    nullable: false
    description: Last time when non-forced DIASource was seen for this object.
    mysql:datatype: DATETIME
  - name: nDiaSources
    "@id": "#DiaObject.nDiaSources"
    datatype: int
    nullable: false
    description: Total number of DiaSources associated with this DiaObject.
  primaryKey:
  - "#DiaObject.diaObjectId"
  - "#DiaObject.validityStart"
  indexes:
  - name: IDX_DiaObject_validityStart
    "@id": "#IDX_DiaObject_validityStart"
    columns:
    - "#DiaObject.validityStart"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: SSObject
  "@id": "#SSObject"
  description: LSST-computed per-object quantities. 1:1 relationship with MPCORB.
    Recomputed daily, upon MPCORB ingestion.
  primaryKey: "#SSObject.ssObjectId"
  mysql:engine: MyISAM
  mysql:charset: utf8mb4
  columns:
  - name: ssObjectId
    "@id": "#SSObject.ssObjectId"
    datatype: long
    nullable: false
    autoincrement: false
    description: Unique identifier.
    ivoa:ucd: meta.id;src
  - name: discoverySubmissionDate
    "@id": "#SSObject.discoverySubmissionDate"
    datatype: double
    description: The date the LSST first linked and submitted the discovery observations
      to the MPC. May be NULL if not an LSST discovery. The date format will follow
      general LSST conventions (MJD TAI, at the moment).
    fits:tunit: d
  - name: firstObservationDate
    "@id": "#SSObject.firstObservationDate"
    datatype: double
    description: The time of the first LSST observation of this object (could be precovered)
      as Modified Julian Date, International Atomic Time.
    fits:tunit: d
  - name: arc
    "@id": "#SSObject.arc"
    datatype: float
    description: Arc of LSST observations.
    fits:tunit: d
  - name: numObs
    "@id": "#SSObject.numObs"
    datatype: int
    description: Number of LSST observations of this object.
  - name: lcPeriodic
    "@id": "#SSObject.lcPeriodic"
    datatype: binary
    length: 768
    description: Periodic light curve features computed on phase/distance-corrected
      magnitudes (H), 6x32 floats.
    mysql:datatype: BLOB(768)
  - name: MOID
    "@id": "#SSObject.MOID"
    datatype: float
    description: Minimum orbit intersection distance to Earth.
    fits:tunit: AU
  - name: MOIDTrueAnomaly
    "@id": "#SSObject.MOIDTrueAnomaly"
    datatype: float
    description: True anomaly of the MOID point.
    fits:tunit: deg
  - name: MOIDEclipticLongitude
    "@id": "#SSObject.MOIDEclipticLongitude"
    datatype: float
    description: Ecliptic longitude of the MOID point.
    fits:tunit: deg
  - name: MOIDDeltaV
    "@id": "#SSObject.MOIDDeltaV"
    datatype: float
    description: DeltaV at the MOID point.
    fits:tunit: km/s
  - name: u_H
    "@id": "#SSObject.u_H"
    datatype: float
    description: Best fit absolute magnitude (u band).
    fits:tunit: mag
  - name: u_G12
    "@id": "#SSObject.u_G12"
    datatype: float
    description: Best fit G12 slope parameter (u band).
    fits:tunit: mag
  - name: u_HErr
    "@id": "#SSObject.u_HErr"
    datatype: float
    description: Uncertainty of H (u band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: u_G12Err
    "@id": "#SSObject.u_G12Err"
    datatype: float
    description: Uncertainty of G12 (u band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: u_H_u_G12_Cov
    "@id": "#SSObject.u_H_u_G12_Cov"
    datatype: float
    description: H-G12 covariance (u band).
    ivoa:ucd: stat.covariance
    fits:tunit: mag**2
  - name: u_Chi2
    "@id": "#SSObject.u_Chi2"
    datatype: float
    description: Chi^2 statistic of the phase curve fit (u band).
    ivoa:ucd: stat.fit.chi2
  - name: u_Ndata
    "@id": "#SSObject.u_Ndata"
    datatype: int
    description: The number of data points used to fit the phase curve (u band).
  - name: g_H
    "@id": "#SSObject.g_H"
    datatype: float
    description: Best fit absolute magnitude (g band).
    fits:tunit: mag
  - name: g_G12
    "@id": "#SSObject.g_G12"
    datatype: float
    description: Best fit G12 slope parameter (g band).
    fits:tunit: mag
  - name: g_HErr
    "@id": "#SSObject.g_HErr"
    datatype: float
    description: Uncertainty of H (g band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: g_G12Err
    "@id": "#SSObject.g_G12Err"
    datatype: float
    description: Uncertainty of G12 (g band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: g_H_g_G12_Cov
    "@id": "#SSObject.g_H_g_G12_Cov"
    datatype: float
    description: H-G12 covariance (g band).
    ivoa:ucd: stat.covariance
    fits:tunit: mag**2
  - name: g_Chi2
    "@id": "#SSObject.g_Chi2"
    datatype: float
    description: Chi^2 statistic of the phase curve fit (g band).
    ivoa:ucd: stat.fit.chi2
  - name: g_Ndata
    "@id": "#SSObject.g_Ndata"
    datatype: int
    description: The number of data points used to fit the phase curve (g band).
  - name: r_H
    "@id": "#SSObject.r_H"
    datatype: float
    description: Best fit absolute magnitude (r band).
    fits:tunit: mag
  - name: r_G12
    "@id": "#SSObject.r_G12"
    datatype: float
    description: Best fit G12 slope parameter (r band).
    fits:tunit: mag
  - name: r_HErr
    "@id": "#SSObject.r_HErr"
    datatype: float
    description: Uncertainty of H (r band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: r_G12Err
    "@id": "#SSObject.r_G12Err"
    datatype: float
    description: Uncertainty of G12 (r band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: r_H_r_G12_Cov
    "@id": "#SSObject.r_H_r_G12_Cov"
    datatype: float
    description: H-G12 covariance (r band).
    ivoa:ucd: stat.covariance
    fits:tunit: mag**2
  - name: r_Chi2
    "@id": "#SSObject.r_Chi2"
    datatype: float
    description: Chi^2 statistic of the phase curve fit (r band).
    ivoa:ucd: stat.fit.chi2
  - name: r_Ndata
    "@id": "#SSObject.r_Ndata"
    datatype: int
    description: The number of data points used to fit the phase curve (r band).
  - name: i_H
    "@id": "#SSObject.i_H"
    datatype: float
    description: Best fit absolute magnitude (i band).
    fits:tunit: mag
  - name: i_G12
    "@id": "#SSObject.i_G12"
    datatype: float
    description: Best fit G12 slope parameter (i band).
    fits:tunit: mag
  - name: i_HErr
    "@id": "#SSObject.i_HErr"
    datatype: float
    description: Uncertainty of H (i band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: i_G12Err
    "@id": "#SSObject.i_G12Err"
    datatype: float
    description: Uncertainty of G12 (i band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: i_H_i_G12_Cov
    "@id": "#SSObject.i_H_i_G12_Cov"
    datatype: float
    description: H-G12 covariance (i band).
    ivoa:ucd: stat.covariance
    fits:tunit: mag**2
  - name: i_Chi2
    "@id": "#SSObject.i_Chi2"
    datatype: float
    description: Chi^2 statistic of the phase curve fit (i band).
    ivoa:ucd: stat.fit.chi2
  - name: i_Ndata
    "@id": "#SSObject.i_Ndata"
    datatype: int
    description: The number of data points used to fit the phase curve (i band).
  - name: z_H
    "@id": "#SSObject.z_H"
    datatype: float
    description: Best fit absolute magnitude (z band).
    fits:tunit: mag
  - name: z_G12
    "@id": "#SSObject.z_G12"
    datatype: float
    description: Best fit G12 slope parameter (z band).
    fits:tunit: mag
  - name: z_HErr
    "@id": "#SSObject.z_HErr"
    datatype: float
    description: Uncertainty of H (z band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: z_G12Err
    "@id": "#SSObject.z_G12Err"
    datatype: float
    description: Uncertainty of G12 (z band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: z_H_z_G12_Cov
    "@id": "#SSObject.z_H_z_G12_Cov"
    datatype: float
    description: H-G12 covariance (z band).
    ivoa:ucd: stat.covariance
    fits:tunit: mag**2
  - name: z_Chi2
    "@id": "#SSObject.z_Chi2"
    datatype: float
    description: Chi^2 statistic of the phase curve fit (z band).
    ivoa:ucd: stat.fit.chi2
  - name: z_Ndata
    "@id": "#SSObject.z_Ndata"
    datatype: int
    description: The number of data points used to fit the phase curve (z band).
  - name: y_H
    "@id": "#SSObject.y_H"
    datatype: float
    description: Best fit absolute magnitude (y band).
    fits:tunit: mag
  - name: y_G12
    "@id": "#SSObject.y_G12"
    datatype: float
    description: Best fit G12 slope parameter (y band).
    fits:tunit: mag
  - name: y_HErr
    "@id": "#SSObject.y_HErr"
    datatype: float
    description: Uncertainty of H (y band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: y_G12Err
    "@id": "#SSObject.y_G12Err"
    datatype: float
    description: Uncertainty of G12 (y band).
    ivoa:ucd: stat.error
    fits:tunit: mag
  - name: y_H_y_G12_Cov
    "@id": "#SSObject.y_H_y_G12_Cov"
    datatype: float
    description: H-G12 covariance (y band).
    ivoa:ucd: stat.covariance
    fits:tunit: mag**2
  - name: y_Chi2
    "@id": "#SSObject.y_Chi2"
    datatype: float
    description: Chi^2 statistic of the phase curve fit (y band).
    ivoa:ucd: stat.fit.chi2
  - name: y_Ndata
    "@id": "#SSObject.y_Ndata"
    datatype: int
    description: The number of data points used to fit the phase curve (y band).
  - name: maxExtendedness
    "@id": "#SSObject.maxExtendedness"
    datatype: float
    description: maximum `extendedness` value from the DIASource.
  - name: minExtendedness
    "@id": "#SSObject.minExtendedness"
    datatype: float
    description: minimum `extendedness` value from the DIASource.
  - name: medianExtendedness
    "@id": "#SSObject.medianExtendedness"
    datatype: float
    description: median `extendedness` value from the DIASource.
  - name: flags
    "@id": "#SSObject.flags"
    datatype: long
    nullable: false
    description: Flags, bitwise OR tbd.
    value: 0
    ivoa:ucd: meta.code
- name: DiaSource
  "@id": "#DiaSource"
  description: Table to store 'difference image sources'; - sources detected at
    SNR >=5 on difference images.
  columns:
  - name: diaSourceId
    "@id": "#DiaSource.diaSourceId"
    datatype: long
    nullable: false
    autoincrement: false
    description: Unique identifier of this DiaSource.
    ivoa:ucd: meta.id;obs.image
  - name: ccdVisitId
    "@id": "#DiaSource.ccdVisitId"
    datatype: long
    nullable: false
    description: Id of the ccdVisit where this diaSource was measured.
    ivoa:ucd: meta.id;obs.image
  - name: diaObjectId
    "@id": "#DiaSource.diaObjectId"
    datatype: long
    nullable: true
    description: Id of the diaObject this source was associated with, if any. If not,
      it is set to NULL (each diaSource will be associated with either a diaObject
      or ssObject).
    ivoa:ucd: meta.id;src
  - name: ssObjectId
    "@id": "#DiaSource.ssObjectId"
    datatype: long
    nullable: true
    description: Id of the ssObject this source was associated with, if any. If not,
      it is set to NULL (each diaSource will be associated with either a diaObject
      or ssObject).
    ivoa:ucd: meta.id;src
  - name: parentDiaSourceId
    "@id": "#DiaSource.parentDiaSourceId"
    datatype: long
    description: Id of the parent diaSource this diaSource has been deblended from,
      if any.
    ivoa:ucd: meta.id;src
  - name: ssObjectReassocTime
    "@id": "#DiaSource.ssObjectReassocTime"
    datatype: timestamp
    length: 6
    description: Time when this diaSource was reassociated from diaObject to ssObject
      (if such reassociation happens, otherwise NULL).
    mysql:datatype: DATETIME
  - name: midpointMjdTai
    "@id": "#DiaSource.midpointMjdTai"
    datatype: double
    nullable: false
    description: Effective mid-visit time for this diaSource, expressed as Modified
      Julian Date, International Atomic Time.
    fits:tunit: d
    ivoa:ucd: time.epoch
  - name: ra
    "@id": "#DiaSource.ra"
    datatype: double
    nullable: false
    description: Right ascension coordinate of the center of this diaSource.
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: raErr
    "@id": "#DiaSource.raErr"
    datatype: float
    description: Uncertainty of ra.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: dec
    "@id": "#DiaSource.dec"
    datatype: double
    nullable: false
    description: Declination coordinate of the center of this diaSource.
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: decErr
    "@id": "#DiaSource.decErr"
    datatype: float
    description: Uncertainty of dec.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: ra_dec_Cov
    "@id": "#DiaSource.ra_dec_Cov"
    datatype: float
    description: Covariance between ra and dec.
    fits:tunit: deg**2
    ivoa:ucd: stat.covariance
  - name: x
    "@id": "#DiaSource.x"
    datatype: float
    nullable: false
    description: x position computed by a centroiding algorithm.
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.x
  - name: xErr
    "@id": "#DiaSource.xErr"
    datatype: float
    description: Uncertainty of x.
    fits:tunit: pixel
    ivoa:ucd: stat.error;pos.cartesian.x
  - name: y
    "@id": "#DiaSource.y"
    datatype: float
    nullable: false
    description: y position computed by a centroiding algorithm.
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.y
  - name: yErr
    "@id": "#DiaSource.yErr"
    datatype: float
    description: Uncertainty of y.
    fits:tunit: pixel
    ivoa:ucd: stat.error;pos.cartesian.y
  - name: x_y_Cov
    "@id": "#DiaSource.x_y_Cov"
    datatype: float
    description: Covariance between x and y.
    fits:tunit: pixel**2
    ivoa:ucd: stat.covariance
  - name: apFlux
    "@id": "#DiaSource.apFlux"
    datatype: float
    description: Flux in a 12 pixel radius aperture on the difference image.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: apFluxErr
    "@id": "#DiaSource.apFluxErr"
    datatype: float
    description: Estimated uncertainty of apFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.error;phot.count
  - name: snr
    "@id": "#DiaSource.snr"
    datatype: float
    description: The signal-to-noise ratio at which this source was detected in the
      difference image.
    ivoa:ucd: stat.snr
  - name: psfFlux
    "@id": "#DiaSource.psfFlux"
    datatype: float
    description: Flux for Point Source model. Note this actually measures
      the flux difference between the template and the visit image.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: psfFluxErr
    "@id": "#DiaSource.psfFluxErr"
    datatype: float
    description: Uncertainty of psfFlux.
    fits:tunit: nJy
  - name: psfRa
    "@id": "#DiaSource.psfRa"
    datatype: double
    description: Right ascension coordinate of centroid for point source model.
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: psfRaErr
    "@id": "#DiaSource.psfRaErr"
    datatype: float
    description: Uncertainty of psfRa.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: psfDec
    "@id": "#DiaSource.psfDec"
    datatype: double
    description: Declination coordinate of centroid for point source model.
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: psfDecErr
    "@id": "#DiaSource.psfDecErr"
    datatype: float
    description: Uncertainty of psfDec.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: psfFlux_psfRa_Cov
    "@id": "#DiaSource.psfFlux_psfRa_Cov"
    datatype: float
    description: Covariance between psfFlux and psfRa.
    fits:tunit: nJy.deg
    ivoa:ucd: stat.covariance
  - name: psfFlux_psfDec_Cov
    "@id": "#DiaSource.psfFlux_psfDec_Cov"
    datatype: float
    description: Covariance between psfFlux and psfDec.
    fits:tunit: nJy.deg
    ivoa:ucd: stat.covariance
  - name: psfRa_psfDec_Cov
    "@id": "#DiaSource.psfRa_psfDec_Cov"
    datatype: float
    description: Covariance between psfRa and psfDec.
    fits:tunit: deg**2
    ivoa:ucd: stat.covariance
  - name: psfLnL
    "@id": "#DiaSource.psfLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the point source
      model.
    ivoa:ucd: stat.likelihood
  - name: psfChi2
    "@id": "#DiaSource.psfChi2"
    datatype: float
    description: Chi^2 statistic of the point source model fit.
    ivoa:ucd: stat.fit.chi2
  - name: psfNdata
    "@id": "#DiaSource.psfNdata"
    datatype: int
    description: The number of data points (pixels) used to fit the point source model.
  - name: trailFlux
    "@id": "#DiaSource.trailFlux"
    datatype: float
    description: Flux for a trailed source model. Note this actually measures
      the flux difference between the template and the visit image.
    fits:tunit: nJy
  - name: trailFluxErr
    "@id": "#DiaSource.trailFluxErr"
    datatype: float
    description: Uncertainty of trailFlux.
    fits:tunit: nJy
  - name: trailRa
    "@id": "#DiaSource.trailRa"
    datatype: double
    description: Right ascension coordinate of centroid for trailed source model.
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: trailRaErr
    "@id": "#DiaSource.trailRaErr"
    datatype: float
    description: Uncertainty of trailRa.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: trailDec
    "@id": "#DiaSource.trailDec"
    datatype: double
    description: Declination coordinate of centroid for trailed source model.
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: trailDecErr
    "@id": "#DiaSource.trailDecErr"
    datatype: float
    description: Uncertainty of trailDec.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: trailLength
    "@id": "#DiaSource.trailLength"
    datatype: float
    description: Maximum likelihood fit of trail length.
    fits:tunit: arcsec
  - name: trailLengthErr
    "@id": "#DiaSource.trailLengthErr"
    datatype: float
    description: Uncertainty of trailLength.
    fits:tunit: nJy
  - name: trailAngle
    "@id": "#DiaSource.trailAngle"
    datatype: float
    description: Maximum likelihood fit of the angle between the meridian through
      the centroid and the trail direction (bearing).
    fits:tunit: deg
  - name: trailAngleErr
    "@id": "#DiaSource.trailAngleErr"
    datatype: float
    description: Uncertainty of trailAngle.
    fits:tunit: nJy
  - name: trailFlux_trailRa_Cov
    "@id": "#DiaSource.trailFlux_trailRa_Cov"
    datatype: float
    description: Covariance of trailFlux and trailRa.
    ivoa:ucd: stat.covariance
  - name: trailFlux_trailDec_Cov
    "@id": "#DiaSource.trailFlux_trailDec_Cov"
    datatype: float
    description: Covariance of trailFlux and trailDec.
    ivoa:ucd: stat.covariance
  - name: trailFlux_trailLength_Cov
    "@id": "#DiaSource.trailFlux_trailLength_Cov"
    datatype: float
    description: Covariance of trailFlux and trailLength
    ivoa:ucd: stat.covariance
  - name: trailFlux_trailAngle_Cov
    "@id": "#DiaSource.trailFlux_trailAngle_Cov"
    datatype: float
    description: Covariance of trailFlux and trailAngle
    ivoa:ucd: stat.covariance
  - name: trailRa_trailDec_Cov
    "@id": "#DiaSource.trailRa_trailDec_Cov"
    datatype: float
    description: Covariance of trailRa and trailDec.
    ivoa:ucd: stat.covariance
  - name: trailRa_trailLength_Cov
    "@id": "#DiaSource.trailRa_trailLength_Cov"
    datatype: float
    description: Covariance of trailRa and trailLength.
    ivoa:ucd: stat.covariance
  - name: trailRa_trailAngle_Cov
    "@id": "#DiaSource.trailRa_trailAngle_Cov"
    datatype: float
    description: Covariance of trailRa and trailAngle.
    ivoa:ucd: stat.covariance
  - name: trailDec_trailLength_Cov
    "@id": "#DiaSource.trailDec_trailLength_Cov"
    datatype: float
    description: Covariance of trailDec and trailLength.
    ivoa:ucd: stat.covariance
  - name: trailDec_trailAngle_Cov
    "@id": "#DiaSource.trailDec_trailAngle_Cov"
    datatype: float
    description: Covariance of trailDec and trailAngle.
    ivoa:ucd: stat.covariance
  - name: trailLength_trailAngle_Cov
    "@id": "#DiaSource.trailLength_trailAngle_Cov"
    datatype: float
    description: Covariance of trailLength and trailAngle
    ivoa:ucd: stat.covariance
  - name: trailLnL
    "@id": "#DiaSource.trailLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the trailed source
      model.
    ivoa:ucd: stat.likelihood
  - name: trailChi2
    "@id": "#DiaSource.trailChi2"
    datatype: float
    description: Chi^2 statistic of the trailed source model fit.
    ivoa:ucd: stat.fit.chi2
  - name: trailNdata
    "@id": "#DiaSource.trailNdata"
    datatype: int
    value: 0
    description: The number of data points (pixels) used to fit the trailed source model.
  - name: dipoleMeanFlux
    "@id": "#DiaSource.dipoleMeanFlux"
    datatype: float
    description: Maximum likelihood value for the mean absolute flux of the two lobes
      for a dipole model.
    fits:tunit: nJy
  - name: dipoleMeanFluxErr
    "@id": "#DiaSource.dipoleMeanFluxErr"
    datatype: float
    description: Uncertainty of dipoleMeanFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: dipoleFluxDiff
    "@id": "#DiaSource.dipoleFluxDiff"
    datatype: float
    description: Maximum likelihood value for the difference of absolute fluxes of
      the two lobes for a dipole model.
    fits:tunit: nJy
  - name: dipoleFluxDiffErr
    "@id": "#DiaSource.dipoleFluxDiffErr"
    datatype: float
    description: Uncertainty of dipoleFluxDiff.
    fits:tunit: nJy
    ivoa:ucd: stat.error
  - name: dipoleRa
    "@id": "#DiaSource.dipoleRa"
    datatype: double
    description: "Right ascension coordinate of centroid for dipole model."
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: dipoleRaErr
    "@id": "#DiaSource.dipoleRaErr"
    datatype: float
    description: Uncertainty of dipoleRa.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: dipoleDec
    "@id": "#DiaSource.dipoleDec"
    datatype: double
    description: "Declination coordinate of centroid for dipole model."
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: dipoleDecErr
    "@id": "#DiaSource.dipoleDecErr"
    datatype: float
    description: Uncertainty of dipoleDec.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: dipoleLength
    "@id": "#DiaSource.dipoleLength"
    datatype: float
    description: Maximum likelihood value for the lobe separation in dipole model.
    fits:tunit: arcsec
    ivoa:ucd: pos.angDistance
  - name: dipoleLengthErr
    "@id": "#DiaSource.dipoleLengthErr"
    datatype: float
    description: Uncertainty of dipoleLength.
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.angDistance
  - name: dipoleAngle
    "@id": "#DiaSource.dipoleAngle"
    datatype: float
    description: Maximum likelihood fit of the angle between the meridian through
      the centroid and the dipole direction (bearing, from negative to positive lobe).
    fits:tunit: deg
    ivoa:ucd: pos.posAng
  - name: dipoleAngleErr
    "@id": "#DiaSource.dipoleAngleErr"
    datatype: float
    description: Uncertainty of dipoleAngle.
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.posAng
  - name: dipoleMeanFlux_dipoleFluxDiff_Cov
    "@id": "#DiaSource.dipoleMeanFlux_dipoleFluxDiff_Cov"
    datatype: float
    description: Covariance of dipoleMeanFlux and dipoleFluxDiff.
    ivoa:ucd: stat.covariance
  - name: dipoleMeanFlux_dipoleRa_Cov
    "@id": "#DiaSource.dipoleMeanFlux_dipoleRa_Cov"
    datatype: float
    description: Covariance of dipoleMeanFlux and dipoleRa.
    ivoa:ucd: stat.covariance
  - name: dipoleMeanFlux_dipoleDec_Cov
    "@id": "#DiaSource.dipoleMeanFlux_dipoleDec_Cov"
    datatype: float
    description: Covariance of dipoleMeanFlux and dipoleDec.
    ivoa:ucd: stat.covariance
  - name: dipoleMeanFlux_dipoleLength_Cov
    "@id": "#DiaSource.dipoleMeanFlux_dipoleLength_Cov"
    datatype: float
    description: Covariance of dipoleMeanFlux and dipoleLength.
    ivoa:ucd: stat.covariance
  - name: dipoleMeanFlux_dipoleAngle_Cov
    "@id": "#DiaSource.dipoleMeanFlux_dipoleAngle_Cov"
    datatype: float
    description: Covariance of dipoleMeanFlux and dipoleAngle.
    ivoa:ucd: stat.covariance
  - name: dipoleFluxDiff_dipoleRa_Cov
    "@id": "#DiaSource.dipoleFluxDiff_dipoleRa_Cov"
    datatype: float
    description: Covariance of dipoleFluxDiff and dipoleRa.
    ivoa:ucd: stat.covariance
  - name: dipoleFluxDiff_dipoleDec_Cov
    "@id": "#DiaSource.dipoleFluxDiff_dipoleDec_Cov"
    datatype: float
    description: Covariance of dipoleFluxDiff and dipoleDec.
    ivoa:ucd: stat.covariance
  - name: dipoleFluxDiff_dipoleLength_Cov
    "@id": "#DiaSource.dipoleFluxDiff_dipoleLength_Cov"
    datatype: float
    description: Covariance of dipoleFluxDiff and dipoleLength.
    ivoa:ucd: stat.covariance
  - name: dipoleFluxDiff_dipoleAngle_Cov
    "@id": "#DiaSource.dipoleFluxDiff_dipoleAngle_Cov"
    datatype: float
    description: Covariance of dipoleFluxDiff and dipoleAngle.
    ivoa:ucd: stat.covariance
  - name: dipoleRa_dipoleDec_Cov
    "@id": "#DiaSource.dipoleRa_dipoleDec_Cov"
    datatype: float
    description: Covariance of dipoleRa and dipoleDec.
    ivoa:ucd: stat.covariance
  - name: dipoleRa_dipoleLength_Cov
    "@id": "#DiaSource.dipoleRa_dipoleLength_Cov"
    datatype: float
    description: Covariance of dipoleRa and dipoleLength.
    ivoa:ucd: stat.covariance
  - name: dipoleRa_dipoleAngle_Cov
    "@id": "#DiaSource.dipoleRa_dipoleAngle_Cov"
    datatype: float
    description: Covariance of dipoleRa and dipoleAngle.
    ivoa:ucd: stat.covariance
  - name: dipoleDec_dipoleLength_Cov
    "@id": "#DiaSource.dipoleDec_dipoleLength_Cov"
    datatype: float
    description: Covariance of dipoleDec and dipoleLength.
    ivoa:ucd: stat.covariance
  - name: dipoleDec_dipoleAngle_Cov
    "@id": "#DiaSource.dipoleDec_dipoleAngle_Cov"
    datatype: float
    description: Covariance of dipoleDec and dipoleAngle.
    ivoa:ucd: stat.covariance
  - name: dipoleLength_dipoleAngle_Cov
    "@id": "#DiaSource.dipoleLength_dipoleAngle_Cov"
    datatype: float
    description: Covariance of dipoleLength and dipoleAngle.
    ivoa:ucd: stat.covariance
  - name: dipoleLnL
    "@id": "#DiaSource.dipoleLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the dipole source
      model.
    ivoa:ucd: stat.likelihood
  - name: dipoleChi2
    "@id": "#DiaSource.dipoleChi2"
    datatype: float
    description: Chi^2 statistic of the model fit.
    ivoa:ucd: stat.fit.chi2
  - name: dipoleNdata
    "@id": "#DiaSource.dipoleNdata"
    datatype: int
    description: The number of data points (pixels) used to fit the model.
  - name: scienceFlux
    "@id": "#DiaSource.scienceFlux"
    datatype: float
    description: Forced photometry flux for a point source model measured on the visit image
      centered at DiaSource position.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: scienceFluxErr
    "@id": "#DiaSource.scienceFluxErr"
    datatype: float
    description: Estimated uncertainty of scienceFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.error;phot.count
  - name: snapDiffFlux
    "@id": "#DiaSource.snapDiffFlux"
    datatype: float
    description: Calibrated flux for Point Source model centered on radec but measured
      on the difference of snaps comprising this visit.
    fits:tunit: nJy
  - name: snapDiffFluxErr
    "@id": "#DiaSource.snapDiffFluxErr"
    datatype: float
    description: Estimated uncertainty of snapDiffFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.error;phot.count
  - name: fpBkgd
    "@id": "#DiaSource.fpBkgd"
    datatype: float
    description: Estimated sky background at the position (centroid) of the object.
    fits:tunit: nJy/arcsec**2
  - name: fpBkgdErr
    "@id": "#DiaSource.fpBkgdErr"
    datatype: float
    description: Estimated uncertainty of fpBkgd.
    fits:tunit: nJy/arcsec**2
  - name: ixx
    "@id": "#DiaSource.ixx"
    datatype: float
    description: Adaptive second moment of the source intensity.
    fits:tunit: nJy.arcsec**2
  - name: ixxErr
    "@id": "#DiaSource.ixxErr"
    datatype: float
    description: Uncertainty of ixx.
    fits:tunit: nJy.arcsec**2
    ivoa:ucd: stat.error
  - name: iyy
    "@id": "#DiaSource.iyy"
    datatype: float
    description: Adaptive second moment of the source intensity.
    fits:tunit: nJy.arcsec**2
  - name: iyyErr
    "@id": "#DiaSource.iyyErr"
    datatype: float
    description: Uncertainty of iyy.
    fits:tunit: nJy.arcsec**2
    ivoa:ucd: stat.error
  - name: ixy
    "@id": "#DiaSource.ixy"
    datatype: float
    description: Adaptive second moment of the source intensity.
    fits:tunit: nJy.arcsec**2
  - name: ixyErr
    "@id": "#DiaSource.ixyErr"
    datatype: float
    description: Uncertainty of ixy.
    fits:tunit: nJy.arcsec**2
    ivoa:ucd: stat.error
  - name: ixx_iyy_Cov
    "@id": "#DiaSource.ixx_iyy_Cov"
    datatype: float
    description: Covariance of ixx and iyy.
    fits:tunit: nJy**2.arcsec**4
  - name: ixx_ixy_Cov
    "@id": "#DiaSource.ixx_ixy_Cov"
    datatype: float
    description: Covariance of ixx and ixy.
    fits:tunit: nJy**2.arcsec**4
  - name: iyy_ixy_Cov
    "@id": "#DiaSource.iyy_ixy_Cov"
    datatype: float
    description: Covariance of iyy and ixy.
    fits:tunit: nJy**2.arcsec**4
  - name: ixxPSF
    "@id": "#DiaSource.ixxPSF"
    datatype: float
    description: Adaptive second moment for the PSF.
    fits:tunit: nJy.arcsec**2
  - name: iyyPSF
    "@id": "#DiaSource.iyyPSF"
    datatype: float
    description: Adaptive second moment for the PSF.
    fits:tunit: nJy.arcsec**2
  - name: ixyPSF
    "@id": "#DiaSource.ixyPSF"
    datatype: float
    description: Adaptive second moment for the PSF.
    fits:tunit: nJy.arcsec**2
  - name: extendedness
    "@id": "#DiaSource.extendedness"
    datatype: float
    description: A measure of extendedness, Computed using a combination of available
      moments and model fluxes or from a likelihood ratio of point/trailed source
      models (exact algorithm TBD). extendedness = 1 implies a high degree of confidence
      that the source is extended. extendedness = 0 implies a high degree of confidence
      that the source is point-like.
  - name: reliability
    "@id": "#DiaSource.reliability"
    datatype: float
    description: A measure of reliability, computed using information from the source
      and image characterization, as well as the information on the Telescope and
      Camera system (e.g., ghost maps, defect maps, etc.).
  - name: flags
    "@id": "#DiaSource.flags"
    datatype: long
    nullable: false
    description: Flags, bitwise OR tbd.
    value: 0
    ivoa:ucd: meta.code
  - name: band
    "@id": "#DiaSource.band"
    datatype: char
    length: 1
    description: Filter band this source was observed with.
  - name: isDipole
    "@id": "#DiaSource.isDipole"
    datatype: boolean
    description: Object determined to be a dipole.
  - name: time_processed
    "@id": "#DiaSource.time_processed"
    datatype: timestamp
    length: 6
    nullable: false
    description: Time when the image was processed and this DiaSource record was generated.
    mysql:datatype: DATETIME
  - name: time_withdrawn
    "@id": "#DiaSource.time_withdrawn"
    datatype: timestamp
    length: 6
    nullable: true
    description: Time when this record was marked invalid.
    mysql:datatype: DATETIME
  - name: bboxSize
    "@id": "#DiaSource.bboxSize"
    datatype: long
  primaryKey: "#DiaSource.diaSourceId"
  indexes:
  - name: IDX_DiaSource_ccdVisitId
    "@id": "#IDX_DiaSource_ccdVisitId"
    columns:
    - "#DiaSource.ccdVisitId"
  - name: IDX_DiaSource_diaObjectId
    "@id": "#IDX_DiaSource_diaObjectId"
    columns:
    - "#DiaSource.diaObjectId"
  - name: IDX_DiaSource_ssObjectId
    "@id": "#IDX_DiaSource_ssObjectId"
    columns:
    - "#DiaSource.ssObjectId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: DiaForcedSource
  "@id": "#DiaForcedSource"
  description: Forced-photometry source measurement on an individual difference Exposure
    based on a Multifit shape model derived from a deep detection.
  columns:
  - name: diaForcedSourceId
    "@id": "#DiaForcedSource.diaForcedSourceId"
    datatype: long
    nullable: false
    description: Unique id.
  - name: diaObjectId
    "@id": "#DiaForcedSource.diaObjectId"
    datatype: long
    nullable: false
    description: Id of the DiaObject that this DiaForcedSource was associated with.
    ivoa:ucd: meta.id;src
  - name: ccdVisitId
    "@id": "#DiaForcedSource.ccdVisitId"
    datatype: long
    nullable: false
    description: Id of the ccdVisit where this forcedSource was measured.
    ivoa:ucd: meta.id;obs.image
  - name: psfFlux
    "@id": "#DiaForcedSource.psfFlux"
    datatype: float
    description: Point Source model flux.
    fits:tunit: nJy
    ivoa:ucd: phot.count
  - name: psfFluxErr
    "@id": "#DiaForcedSource.psfFluxErr"
    datatype: float
    description: Uncertainty of psfFlux.
    fits:tunit: nJy
    ivoa:ucd: stat.error;phot.count
  - name: x
    "@id": "#DiaForcedSource.x"
    datatype: float
    description: x position at which psfFlux has been measured.
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.x
  - name: y
    "@id": "#DiaForcedSource.y"
    datatype: float
    description: y position at which psfFlux has been measured.
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.y
  - name: flags
    "@id": "#DiaForcedSource.flags"
    datatype: long
    description: Flags, bitwise OR tbd
    value: 0
    ivoa:ucd: meta.code
  - name: midpointMjdTai
    "@id": "#DiaForcedSource.midpointMjdTai"
    datatype: double
    nullable: false
    description: Effective mid-visit time for this diaForcedSource, expressed as Modified
      Julian Date, International Atomic Time.
    ivoa:ucd: time.epoch
    fits:tunit: d
  - name: scienceFlux
    "@id": "#DiaForcedSource.scienceFlux"
    datatype: float
    description: Forced photometry flux for a point source model measured on the visit image
      centered at the DiaObject position.
    ivoa:ucd: phot.count
    fits:tunit: nJy
  - name: scienceFluxErr
    "@id": "#DiaForcedSource.scienceFluxErr"
    datatype: float
    description: Uncertainty of scienceFlux.
    ivoa:ucd: stat.error;phot.count
    fits:tunit: nJy
  - name: band
    "@id": "#DiaForcedSource.band"
    datatype: char
    length: 1
    description: Filter band this source was observed with.
    ivoa:ucd: meta.id;instr.filter
  - name: time_processed
    "@id": "#DiaForcedSource.time_processed"
    datatype: timestamp
    length: 6
    nullable: false
    description: Time when this record was generated.
    mysql:datatype: DATETIME
  - name: time_withdrawn
    "@id": "#DiaForcedSource.time_withdrawn"
    datatype: timestamp
    length: 6
    nullable: true
    description: Time when this record was marked invalid.
    mysql:datatype: DATETIME
  primaryKey:
  - "#DiaForcedSource.diaObjectId"
  - "#DiaForcedSource.ccdVisitId"
  indexes:
  - name: IDX_DiaForcedSource_ccdVisitId
    "@id": "#IDX_DiaForcedSource_ccdVisitId"
    columns:
    - "#DiaForcedSource.ccdVisitId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: DiaObject_To_Object_Match
  "@id": "#DiaObject_To_Object_Match"
  description: The table stores mapping of diaObjects to the nearby objects.
  columns:
  - name: diaObjectId
    "@id": "#DiaObject_To_Object_Match.diaObjectId"
    datatype: long
    nullable: false
    description: Id of diaObject.
    ivoa:ucd: meta.id;src
  - name: objectId
    "@id": "#DiaObject_To_Object_Match.objectId"
    datatype: long
    nullable: false
    description: Id of a nearby object.
    ivoa:ucd: meta.id;src
  - name: dist
    "@id": "#DiaObject_To_Object_Match.dist"
    datatype: float
    description: The distance between the diaObject and the object.
    fits:tunit: arcsec
  - name: lnP
    "@id": "#DiaObject_To_Object_Match.lnP"
    datatype: float
    description: Natural log of the probability that the observed diaObject is the
      same as the nearby object.
  indexes:
  - name: IDX_DiaObjectToObjectMatch_diaObjectId
    "@id": "#IDX_DiaObjectToObjectMatch_diaObjectId"
    columns:
    - "#DiaObject_To_Object_Match.diaObjectId"
  - name: IDX_DiaObjectToObjectMatch_objectId
    "@id": "#IDX_DiaObjectToObjectMatch_objectId"
    columns:
    - "#DiaObject_To_Object_Match.objectId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: DiaObjectLast
  "@id": "#DiaObjectLast"
  description: Table with a subset of DiaObject columns used to store only the
    latest version of each object.
  columns:
  - name: diaObjectId
    "@id": "#DiaObjectLast.diaObjectId"
    datatype: long
    nullable: false
    autoincrement: false
    description: Unique id.
    ivoa:ucd: meta.id;src
  - name: lastNonForcedSource
    "@id": "#DiaObjectLast.lastNonForcedSource"
    datatype: timestamp
    length: 6
    nullable: false
    description: Last time when non-forced DIASource was seen for this object.
  - name: ra
    "@id": "#DiaObjectLast.ra"
    datatype: double
    nullable: false
    description: Right ascension coordinate of the position of the object at time radecMjdTai.
    ivoa:ucd: pos.eq.ra
    fits:tunit: deg
  - name: raErr
    "@id": "#DiaObjectLast.raErr"
    datatype: float
    description: Uncertainty of ra.
    ivoa:ucd: stat.error;pos.eq.ra
    fits:tunit: deg
  - name: dec
    "@id": "#DiaObjectLast.dec"
    datatype: double
    nullable: false
    description: Declination coordinate of the position of the object at time radecMjdTai.
    ivoa:ucd: pos.eq.dec
    fits:tunit: deg
  - name: decErr
    "@id": "#DiaObjectLast.decErr"
    datatype: float
    description: Uncertainty of dec.
    ivoa:ucd: stat.error;pos.eq.dec
    fits:tunit: deg
  - name: ra_dec_Cov
    "@id": "#DiaObjectLast.ra_dec_Cov"
    datatype: float
    description: Covariance between ra and dec.
    fits:tunit: deg**2
  - name: radecMjdTai
    "@id": "#DiaObjectLast.radecMjdTai"
    datatype: double
    nullable: false
    description: Time at which the object was at a position ra/dec, expressed
      as Modified Julian Date, International Atomic Time.
    ivoa:ucd: time.epoch
  - name: pmRa
    "@id": "#DiaObjectLast.pmRa"
    datatype: float
    description: Proper motion (RA).
    ivoa:ucd: pos.pm
    fits:tunit: mas/yr
  - name: pmRaErr
    "@id": "#DiaObjectLast.pmRaErr"
    datatype: float
    description: Uncertainty of pmRa.
    ivoa:ucd: stat.error;pos.pm
    fits:tunit: mas/yr
  - name: pmDec
    "@id": "#DiaObjectLast.pmDec"
    datatype: float
    description: Proper motion (Dec).
    ivoa:ucd: pos.pm
    fits:tunit: mas/yr
  - name: pmDecErr
    "@id": "#DiaObjectLast.pmDecErr"
    datatype: float
    description: Uncertainty of pmDec.
    ivoa:ucd: stat.error;pos.pm
    fits:tunit: mas/yr
  - name: parallax
    "@id": "#DiaObjectLast.parallax"
    datatype: float
    description: Parallax.
    ivoa:ucd: pos.parallax
    fits:tunit: mas
  - name: parallaxErr
    "@id": "#DiaObjectLast.parallaxErr"
    datatype: float
    description: Uncertainty of parallax.
    ivoa:ucd: stat.error;pos.parallax
    fits:tunit: mas
  - name: pmRa_pmDec_Cov
    "@id": "#DiaObjectLast.pmRa_pmDec_Cov"
    datatype: float
    description: Covariance of pmRa and pmDec.
    ivoa:ucd: stat.covariance;pos.eq
    fits:tunit: mas**2/yr**2
  - name: pmRa_parallax_Cov
    "@id": "#DiaObjectLast.pmRa_parallax_Cov"
    datatype: float
    description: Covariance of pmRa and parallax.
    ivoa:ucd: stat.covariance
    fits:tunit: mas**2/yr
  - name: pmDec_parallax_Cov
    "@id": "#DiaObjectLast.pmDec_parallax_Cov"
    datatype: float
    description: Covariance of pmDec and parallax.
    ivoa:ucd: stat.covariance
    fits:tunit: mas**2/yr
  primaryKey: "#DiaObjectLast.diaObjectId"
- name: MPCORB
  "@id": "#MPCORB"
  description: The orbit catalog produced by the Minor Planet Center. Ingested daily.
    O(10M) rows by survey end. The columns are described at https://minorplanetcenter.net//iau/info/MPOrbitFormat.html
  primaryKey: "#MPCORB.mpcDesignation"
  mysql:engine: MyISAM
  mysql:charset: utf8mb4
  columns:
  - name: mpcDesignation
    "@id": "#MPCORB.mpcDesignation"
    datatype: char
    length: 8
    description: 'MPCORB: Number or provisional designation (in packed form)'
    mysql:datatype: VARCHAR(8)
    ivoa:ucd: meta.id;src
  - name: mpcNumber
    "@id": "#MPCORB.mpcNumber"
    datatype: int
    description: MPC number (if the asteroid has been numbered; NULL otherwise). Provided
      for convenience.
  - name: ssObjectId
    "@id": "#MPCORB.ssObjectId"
    datatype: long
    description: LSST unique identifier (if observed by LSST)
    ivoa:ucd: meta.id;src
  - name: mpcH
    "@id": "#MPCORB.mpcH"
    datatype: float
    description: 'MPCORB: Absolute magnitude, H'
    fits:tunit: mag
  - name: mpcG
    "@id": "#MPCORB.mpcG"
    datatype: float
    description: 'MPCORB: Slope parameter, G'
  - name: epoch
    "@id": "#MPCORB.epoch"
    datatype: double
    description: 'MPCORB: Epoch (in MJD, .0 TT)'
    fits:tunit: d
  - name: M
    "@id": "#MPCORB.M"
    datatype: double
    description: 'MPCORB: Mean anomaly at the epoch, in degrees'
    fits:tunit: deg
  - name: peri
    "@id": "#MPCORB.peri"
    datatype: double
    description: 'MPCORB: Argument of perihelion, J2000.0 (degrees)'
    fits:tunit: deg
  - name: node
    "@id": "#MPCORB.node"
    datatype: double
    description: 'MPCORB: Longitude of the ascending node, J2000.0 (degrees)'
    fits:tunit: deg
  - name: incl
    "@id": "#MPCORB.incl"
    datatype: double
    description: 'MPCORB: Inclination to the ecliptic, J2000.0 (degrees)'
    fits:tunit: deg
  - name: e
    "@id": "#MPCORB.e"
    datatype: double
    description: 'MPCORB: Orbital eccentricity'
  - name: n
    "@id": "#MPCORB.n"
    datatype: double
    description: 'MPCORB: Mean daily motion (degrees per day)'
    fits:tunit: deg/d
  - name: a
    "@id": "#MPCORB.a"
    datatype: double
    description: 'MPCORB: Semimajor axis (AU)'
    fits:tunit: AU
  - name: uncertaintyParameter
    "@id": "#MPCORB.uncertaintyParameter"
    datatype: char
    length: 1
    description: 'MPCORB: Uncertainty parameter, U'
    mysql:datatype: VARCHAR(1)
  - name: reference
    "@id": "#MPCORB.reference"
    datatype: char
    length: 9
    description: 'MPCORB: Reference'
    mysql:datatype: VARCHAR(9)
  - name: nobs
    "@id": "#MPCORB.nobs"
    datatype: int
    description: 'MPCORB: Number of observations'
  - name: nopp
    "@id": "#MPCORB.nopp"
    datatype: int
    description: 'MPCORB: Number of oppositions'
  - name: arc
    "@id": "#MPCORB.arc"
    datatype: float
    description: 'MPCORB: Arc (days), for single-opposition objects'
    fits:tunit: d
  - name: arcStart
    "@id": "#MPCORB.arcStart"
    datatype: timestamp
    length: 6
    description: 'MPCORB: Year of first observation (for multi-opposition objects)'
    mysql:datatype: DATETIME
  - name: arcEnd
    "@id": "#MPCORB.arcEnd"
    datatype: timestamp
    length: 6
    description: 'MPCORB: Year of last observation (for multi-opposition objects)'
    mysql:datatype: DATETIME
  - name: rms
    "@id": "#MPCORB.rms"
    datatype: float
    description: 'MPCORB: r.m.s residual (")'
    fits:tunit: arcsec
  - name: pertsShort
    "@id": "#MPCORB.pertsShort"
    datatype: char
    length: 3
    description: 'MPCORB: Coarse indicator of perturbers (blank if unperturbed one-opposition
      object)'
    mysql:datatype: VARCHAR(3)
  - name: pertsLong
    "@id": "#MPCORB.pertsLong"
    datatype: char
    length: 3
    description: 'MPCORB: Precise indicator of perturbers (blank if unperturbed one-opposition
      object)'
    mysql:datatype: VARCHAR(3)
  - name: computer
    "@id": "#MPCORB.computer"
    datatype: char
    length: 10
    description: 'MPCORB: Computer name'
    mysql:datatype: VARCHAR(10)
  - name: flags
    "@id": "#MPCORB.flags"
    datatype: int
    description: 'MPCORB: 4-hexdigit flags. See https://minorplanetcenter.net//iau/info/MPOrbitFormat.html
      for details'
  - name: fullDesignation
    "@id": "#MPCORB.fullDesignation"
    datatype: char
    length: 26
    description: 'MPCORB: Readable designation'
    mysql:datatype: VARCHAR(26)
  - name: lastIncludedObservation
    "@id": "#MPCORB.lastIncludedObservation"
    datatype: float
    description: 'MPCORB: Date of last observation included in orbit solution'
    fits:tunit: d
- name: MPCORBDESIGMAP
  "@id": "#MPCORBDESIGMAP"
  description: The mapping between old and new provisional MPC designation, produced
    by the Minor Planet Center. Ingested daily. O(few x 10M) rows by survey end.
  primaryKey: "#MPCORBDESIGMAP.mpcDesignation"
  mysql:engine: MyISAM
  mysql:charset: utf8mb4
  columns:
  - name: mpcDesignation
    "@id": "#MPCORBDESIGMAP.mpcDesignation"
    datatype: char
    length: 8
    description: Either the MPC provisional or permanent designation
    mysql:datatype: VARCHAR(8)
    ivoa:ucd: meta.id;src
  - name: mpcNumber
    "@id": "#MPCORBDESIGMAP.mpcNumber"
    datatype: int
    description: MPC number (if the asteroid has been numbered)
  - name: otherDesignation
    "@id": "#MPCORBDESIGMAP.otherDesignation"
    datatype: char
    length: 8
    description: Other designation by which this object is known
    mysql:datatype: VARCHAR(8)
  - name: ssObjectId
    "@id": "#MPCORBDESIGMAP.ssObjectId"
    datatype: long
    description: LSST unique identifier (if observed by LSST)
    ivoa:ucd: meta.id;src
- name: SSSource
  "@id": "#SSSource"
  description: LSST-computed per-source quantities. 1:1 relationship with DIASource.
    Recomputed daily, upon MPCORB ingestion.
  primaryKey: "#SSSource.ssObjectId"
  mysql:engine: MyISAM
  mysql:charset: utf8mb4
  columns:
  - name: ssObjectId
    "@id": "#SSSource.ssObjectId"
    datatype: long
    autoincrement: false
    description: Unique identifier of the object.
    ivoa:ucd: meta.id;src
  - name: diaSourceId
    "@id": "#SSSource.diaSourceId"
    datatype: long
    description: Unique identifier of the observation
    ivoa:ucd: meta.id;src
  - name: mpcUniqueId
    "@id": "#SSSource.mpcUniqueId"
    datatype: long
    description: MPC unique identifier of the observation
  - name: nearbyObj1
    "@id": "#SSSource.nearbyObj1"
    datatype: long
    description: Closest Objects (3 stars and 3 galaxies) in Level 2 database.
  - name: nearbyObj2
    "@id": "#SSSource.nearbyObj2"
    datatype: long
    description: Closest Objects (3 stars and 3 galaxies) in Level 2 database.
  - name: nearbyObj3
    "@id": "#SSSource.nearbyObj3"
    datatype: long
    description: Closest Objects (3 stars and 3 galaxies) in Level 2 database.
  - name: nearbyObj4
    "@id": "#SSSource.nearbyObj4"
    datatype: long
    description: Closest Objects (3 stars and 3 galaxies) in Level 2 database.
  - name: nearbyObj5
    "@id": "#SSSource.nearbyObj5"
    datatype: long
    description: Closest Objects (3 stars and 3 galaxies) in Level 2 database.
  - name: nearbyObj6
    "@id": "#SSSource.nearbyObj6"
    datatype: long
    description: Closest Objects (3 stars and 3 galaxies) in Level 2 database.
  - name: nearbyObjDist1
    "@id": "#SSSource.nearbyObjDist1"
    datatype: float
    description: Distances to nearbyObj
  - name: nearbyObjDist2
    "@id": "#SSSource.nearbyObjDist2"
    datatype: float
    description: Distances to nearbyObj
  - name: nearbyObjDist3
    "@id": "#SSSource.nearbyObjDist3"
    datatype: float
    description: Distances to nearbyObj
  - name: nearbyObjDist4
    "@id": "#SSSource.nearbyObjDist4"
    datatype: float
    description: Distances to nearbyObj
  - name: nearbyObjDist5
    "@id": "#SSSource.nearbyObjDist5"
    datatype: float
    description: Distances to nearbyObj
  - name: nearbyObjDist6
    "@id": "#SSSource.nearbyObjDist6"
    datatype: float
    description: Distances to nearbyObj
  - name: nearbyObjLnP1
    "@id": "#SSSource.nearbyObjLnP1"
    datatype: float
    description: Natural log of the probability that the observed DIAObject is the
      same as the nearby Object
  - name: nearbyObjLnP2
    "@id": "#SSSource.nearbyObjLnP2"
    datatype: float
    description: Natural log of the probability that the observed DIAObject is the
      same as the nearby Object
  - name: nearbyObjLnP3
    "@id": "#SSSource.nearbyObjLnP3"
    datatype: float
    description: Natural log of the probability that the observed DIAObject is the
      same as the nearby Object
  - name: nearbyObjLnP4
    "@id": "#SSSource.nearbyObjLnP4"
    datatype: float
    description: Natural log of the probability that the observed DIAObject is the
      same as the nearby Object
  - name: nearbyObjLnP5
    "@id": "#SSSource.nearbyObjLnP5"
    datatype: float
    description: Natural log of the probability that the observed DIAObject is the
      same as the nearby Object
  - name: nearbyObjLnP6
    "@id": "#SSSource.nearbyObjLnP6"
    datatype: float
    description: Natural log of the probability that the observed DIAObject is the
      same as the nearby Object
  - name: eclipticLambda
    "@id": "#SSSource.eclipticLambda"
    datatype: double
    description: Ecliptic longitude
    fits:tunit: deg
  - name: eclipticBeta
    "@id": "#SSSource.eclipticBeta"
    datatype: double
    description: Ecliptic latitude
    fits:tunit: deg
  - name: galacticL
    "@id": "#SSSource.galacticL"
    datatype: double
    description: Galactic longitude
    fits:tunit: deg
  - name: galacticB
    "@id": "#SSSource.galacticB"
    datatype: double
    description: Galactic latitute
    fits:tunit: deg
  - name: phaseAngle
    "@id": "#SSSource.phaseAngle"
    datatype: float
    description: Phase angle
    fits:tunit: deg
  - name: heliocentricDist
    "@id": "#SSSource.heliocentricDist"
    datatype: float
    description: Heliocentric distance
    fits:tunit: AU
  - name: topocentricDist
    "@id": "#SSSource.topocentricDist"
    datatype: float
    description: Topocentric distace
    fits:tunit: AU
  - name: predictedMagnitude
    "@id": "#SSSource.predictedMagnitude"
    datatype: float
    description: Predicted magnitude
    fits:tunit: mag
  - name: predictedMagnitudeSigma
    "@id": "#SSSource.predictedMagnitudeSigma"
    datatype: float
    description: Prediction uncertainty (1-sigma)
    fits:tunit: mag
  - name: residualRa
    "@id": "#SSSource.residualRa"
    datatype: double
    description: Residual R.A. vs. ephemeris
    fits:tunit: deg
  - name: residualDec
    "@id": "#SSSource.residualDec"
    datatype: double
    description: Residual Dec vs. ephemeris
    fits:tunit: deg
  - name: predictedRaSigma
    "@id": "#SSSource.predictedRaSigma"
    datatype: float
    description: Predicted R.A. uncertainty
    fits:tunit: deg
  - name: predictedDecSigma
    "@id": "#SSSource.predictedDecSigma"
    datatype: float
    description: Predicted Dec uncertainty
    fits:tunit: deg
  - name: predictedRaDecCov
    "@id": "#SSSource.predictedRaDecCov"
    datatype: float
    description: Predicted R.A./Dec covariance
    fits:tunit: deg**2
  - name: heliocentricX
    "@id": "#SSSource.heliocentricX"
    datatype: float
    description: Cartesian heliocentric X coordinate (at the emit time)
    fits:tunit: AU
  - name: heliocentricY
    "@id": "#SSSource.heliocentricY"
    datatype: float
    description: Cartesian heliocentric Y coordinate (at the emit time)
    fits:tunit: AU
  - name: heliocentricZ
    "@id": "#SSSource.heliocentricZ"
    datatype: float
    description: Cartesian heliocentric Z coordinate (at the emit time)
    fits:tunit: AU
  - name: heliocentricVX
    "@id": "#SSSource.heliocentricVX"
    datatype: float
    description: Cartesian heliocentric X velocity (at the emit time)
    fits:tunit: AU
  - name: heliocentricVY
    "@id": "#SSSource.heliocentricVY"
    datatype: float
    description: Cartesian heliocentric Y velocity (at the emit time)
    fits:tunit: AU
  - name: heliocentricVZ
    "@id": "#SSSource.heliocentricVZ"
    datatype: float
    description: Cartesian heliocentric Z velocity (at the emit time)
    fits:tunit: AU
  - name: topocentricX
    "@id": "#SSSource.topocentricX"
    datatype: float
    description: Cartesian topocentric X coordinate (at the emit time)
    fits:tunit: AU
  - name: topocentricY
    "@id": "#SSSource.topocentricY"
    datatype: float
    description: Cartesian topocentric Y coordinate (at the emit time)
    fits:tunit: AU
  - name: topocentricZ
    "@id": "#SSSource.topocentricZ"
    datatype: float
    description: Cartesian topocentric Z coordinate (at the emit time)
    fits:tunit: AU
  - name: topocentricVX
    "@id": "#SSSource.topocentricVX"
    datatype: float
    description: Cartesian topocentric X velocity (at the emit time)
    fits:tunit: AU
  - name: topocentricVY
    "@id": "#SSSource.topocentricVY"
    datatype: float
    description: Cartesian topocentric Y velocity (at the emit time)
    fits:tunit: AU
  - name: topocentricVZ
    "@id": "#SSSource.topocentricVZ"
    datatype: float
    description: Cartesian topocentric Z velocity (at the emit time)
    fits:tunit: AU
- name: DetectorVisitProcessingSummary
  '@id': '#DetectorVisitProcessingSummary'
  description: Properties of an image from one processing of a single detector in a visit.
  columns:
  - name: ccdVisitId
    '@id': '#DetectorVisitProcessingSummary.ccdVisitId'
    datatype: long
    description: Unique identifier.
  - name: visit
    '@id': '#DetectorVisitProcessingSummary.visit'
    datatype: long
    description: Id of the visit this visit was a part of.
    mysql:datatype: INTEGER
  - name: detector
    '@id': '#DetectorVisitProcessingSummary.detector'
    datatype: long
    description: Id of the detector on the instrument that took this visit.
  - name: ra
    '@id': '#DetectorVisitProcessingSummary.ra'
    datatype: double
    description: Right Ascension of detector center.
    fits:tunit: deg
  - name: dec
    '@id': '#DetectorVisitProcessingSummary.dec'
    datatype: double
    description: Declination of detector center.
    fits:tunit: deg
  - name: zeroPoint
    '@id': '#DetectorVisitProcessingSummary.zeroPoint'
    datatype: float
    description: Zero-point for the detector, estimated at detector center.
    fits:tunit: mag
  - name: psfSigma
    '@id': '#DetectorVisitProcessingSummary.psfSigma'
    datatype: float
    description: PSF model second-moments determinant radius (center of detector).
    fits:tunit: pixel
  - name: skyBg
    '@id': '#DetectorVisitProcessingSummary.skyBg'
    datatype: float
    description: Average sky background.
    fits:tunit: adu
  - name: skyNoise
    '@id': '#DetectorVisitProcessingSummary.skyNoise'
    datatype: float
    description: RMS noise of the sky background.
    fits:tunit: adu
  - name: seeing
    '@id': '#DetectorVisitProcessingSummary.seeing'
    datatype: double
    description: Mean measured FWHM of the PSF.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: xSize
    '@id': '#DetectorVisitProcessingSummary.xSize'
    datatype: long
    description: Number of columns in the image.
    mysql:datatype: INTEGER
    fits:tunit: pixel
  - name: ySize
    '@id': '#DetectorVisitProcessingSummary.ySize'
    datatype: long
    description: Number of rows in the image.
    mysql:datatype: INTEGER
    fits:tunit: pixel
  - name: llcra
    '@id': '#DetectorVisitProcessingSummary.llcra'
    datatype: double
    description: RA of lower left corner.
    fits:tunit: deg
  - name: llcdec
    '@id': '#DetectorVisitProcessingSummary.llcdec'
    datatype: double
    description: Declination of lower left corner.
    fits:tunit: deg
  - name: ulcra
    '@id': '#DetectorVisitProcessingSummary.ulcra'
    datatype: double
    description: RA of upper left corner.
    fits:tunit: deg
  - name: ulcdec
    '@id': '#DetectorVisitProcessingSummary.ulcdec'
    datatype: double
    description: Declination of upper left corner.
    fits:tunit: deg
  - name: urcra
    '@id': '#DetectorVisitProcessingSummary.urcra'
    datatype: double
    description: RA of upper right corner.
    fits:tunit: deg
  - name: urcdec
    '@id': '#DetectorVisitProcessingSummary.urcdec'
    datatype: double
    description: Declination of upper right corner.
    fits:tunit: deg
  - name: lrcra
    '@id': '#DetectorVisitProcessingSummary.lrcra'
    datatype: double
    description: RA of lower right corner.
    fits:tunit: deg
  - name: lrcdec
    '@id': '#DetectorVisitProcessingSummary.lrcdec'
    datatype: double
    description: Declination of lower right corner.
    fits:tunit: deg
  - name: astromOffsetMean
    '@id': '#DetectorVisitProcessingSummary.astromOffsetMean'
    datatype: double
    description: Mean offset of astrometric calibration matches (arcsec).
    fits:tunit: arcsec
  - name: astromOffsetStd
    '@id': '#DetectorVisitProcessingSummary.astromOffsetStd'
    datatype: double
    description: Standard deviation of offsets of astrometric calibration matches (arcsec).
    fits:tunit: arcsec
  - name: nPsfStar
    '@id': '#DetectorVisitProcessingSummary.nPsfStar'
    datatype: int
    description: Number of stars used for PSF model.
    fits:tunit:
  - name: psfStarDeltaE1Median
    '@id': '#DetectorVisitProcessingSummary.psfStarDeltaE1Median'
    datatype: double
    description: Median E1 residual (starE1 - psfE1) for psf stars.
    fits:tunit:
  - name: psfStarDeltaE2Median
    '@id': '#DetectorVisitProcessingSummary.psfStarDeltaE2Median'
    datatype: double
    description: Median E2 residual (starE2 - psfE2) for psf stars.
    fits:tunit:
  - name: psfStarDeltaE1Scatter
    '@id': '#DetectorVisitProcessingSummary.psfStarDeltaE1Scatter'
    datatype: double
    description: Scatter (via MAD) of E1 residual (starE1 - psfE1) for psf stars.
    fits:tunit:
  - name: psfStarDeltaE2Scatter
    '@id': '#DetectorVisitProcessingSummary.psfStarDeltaE2Scatter'
    datatype: double
    description: Scatter (via MAD) of E2 residual (starE2 - psfE2) for psf stars.
    fits:tunit:
  - name: psfStarDeltaSizeMedian
    '@id': '#DetectorVisitProcessingSummary.psfStarDeltaSizeMedian'
    datatype: double
    description: Median size residual (starSize - psfSize) for psf stars (pixel).
    fits:tunit: pixel
  - name: psfStarDeltaSizeScatter
    '@id': '#DetectorVisitProcessingSummary.psfStarDeltaSizeScatter'
    datatype: double
    description: Scatter (via MAD) of size residual (starSize - psfSize) for stars (pixel).
    fits:tunit: pixel
  - name: psfStarScaledDeltaSizeScatter
    '@id': '#DetectorVisitProcessingSummary.psfStarScaledDeltaSizeScatter'
    datatype: double
    description: Scatter (via MAD) of size residual scaled by median size squared.
    fits:tunit:
  - name: psfTraceRadiusDelta
    '@id': '#DetectorVisitProcessingSummary.psfTraceRadiusDelta'
    datatype: double
    description: Delta (max - min) of model psf trace radius values evaluated on a grid of unmasked pixels (pixel).
    fits:tunit: pixel
  - name: maxDistToNearestPsf
    '@id': '#DetectorVisitProcessingSummary.maxDistToNearestPsf'
    datatype: double
    description: Maximum distance of an unmasked pixel to its nearest model psf star (pixel).
    fits:tunit: pixel
- name: Instrument
  '@id': '#Instrument'
  description: The instrument that took this data.
  columns:
  - name: instrument
    '@id': '#Instrument.instrument'
    datatype: string
    length: 32
    description: Name of the instrument that took this data.
    mysql:datatype: VARCHAR(64)