---
name: BaselineSchema
"@id": "#baselineSchema"
tables:
- name: ZZZ_Schema_Description
  "@id": "#ZZZ_Schema_Description"
  description: Internal table used for storing schema version and description.
  columns:
  - name: version
    "@id": "#ZZZ_Schema_Description.version"
    datatype: string
    description: The schema version.
    length: 255
    mysql:datatype: VARCHAR(255)
  - name: descr
    "@id": "#ZZZ_Schema_Description.descr"
    datatype: string
    description: Description of the schema.
    length: 255
    mysql:datatype: VARCHAR(255)
  mysql:engine: MyISAM
  mysql:charset: latin1
- 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
    description: Unique id.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: validityStart
    "@id": "#DiaObject.validityStart"
    datatype: timestamp
    description: Time when validity of this diaObject starts.
    mysql:datatype: DATETIME
  - name: validityEnd
    "@id": "#DiaObject.validityEnd"
    datatype: timestamp
    description: Time when validity of this diaObject ends.
    mysql:datatype: DATETIME
  - name: ra
    "@id": "#DiaObject.ra"
    datatype: double
    description: RA-coordinate of the position of the object at time radecTai.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: raErr
    "@id": "#DiaObject.raErr"
    datatype: float
    description: Uncertainty of ra.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: decl
    "@id": "#DiaObject.decl"
    datatype: double
    description: Decl-coordinate of the position of the object at time radecTai.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: declErr
    "@id": "#DiaObject.declErr"
    datatype: float
    description: Uncertainty of decl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: ra_decl_Cov
    "@id": "#DiaObject.ra_decl_Cov"
    datatype: float
    description: Covariance between ra and decl.
    mysql:datatype: FLOAT
    fits:tunit: deg^2
  - name: radecTai
    "@id": "#DiaObject.radecTai"
    datatype: double
    description: Time at which the object was at a position ra/decl.
    mysql:datatype: DOUBLE
    ivoa:ucd: time.epoch
  - name: pmRa
    "@id": "#DiaObject.pmRa"
    datatype: float
    description: Proper motion (ra).
    mysql:datatype: FLOAT
    fits:tunit: mas/yr
    ivoa:ucd: pos.pm
  - name: pmRaErr
    "@id": "#DiaObject.pmRaErr"
    datatype: float
    description: Uncertainty of pmRa.
    mysql:datatype: FLOAT
    fits:tunit: mas/yr
    ivoa:ucd: stat.error;pos.pm
  - name: pmDecl
    "@id": "#DiaObject.pmDecl"
    datatype: float
    description: Proper motion (decl).
    mysql:datatype: FLOAT
    fits:tunit: mas/yr
    ivoa:ucd: pos.pm
  - name: pmDeclErr
    "@id": "#DiaObject.pmDeclErr"
    datatype: float
    description: Uncertainty of pmDecl.
    mysql:datatype: FLOAT
    fits:tunit: mas/yr
    ivoa:ucd: stat.error;pos.pm
  - name: parallax
    "@id": "#DiaObject.parallax"
    datatype: float
    description: Parallax.
    mysql:datatype: FLOAT
    fits:tunit: mas
    ivoa:ucd: pos.parallax
  - name: parallaxErr
    "@id": "#DiaObject.parallaxErr"
    datatype: float
    description: Uncertainty of parallax.
    mysql:datatype: FLOAT
    fits:tunit: mas
    ivoa:ucd: stat.error;pos.parallax
  - name: pmRa_pmDecl_Cov
    "@id": "#DiaObject.pmRa_pmDecl_Cov"
    datatype: float
    description: Covariance of pmRa and pmDecl.
    mysql:datatype: FLOAT
    fits:tunit: "(mas/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.
    mysql:datatype: FLOAT
    fits:tunit: mas^2/yr
    ivoa:ucd: stat.covariance
  - name: pmDecl_parallax_Cov
    "@id": "#DiaObject.pmDecl_parallax_Cov"
    datatype: float
    description: Covariance of pmDecl and parallax.
    mysql:datatype: FLOAT
    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.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.likelihood
  - name: pmParallaxChi2
    "@id": "#DiaObject.pmParallaxChi2"
    datatype: float
    description: Chi^2 static of the model fit.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: pmParallaxNdata
    "@id": "#DiaObject.pmParallaxNdata"
    datatype: int
    description: The number of data points used to fit the model.
    mysql:datatype: INT
  - name: uPSFluxMean
    "@id": "#DiaObject.uPSFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for u filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: uPSFluxMeanErr
    "@id": "#DiaObject.uPSFluxMeanErr"
    datatype: float
    description: Standard error of uPSFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: uPSFluxSigma
    "@id": "#DiaObject.uPSFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of uPSFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: uPSFluxChi2
    "@id": "#DiaObject.uPSFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of uPSFlux around uPSFluxMean.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: uPSFluxNdata
    "@id": "#DiaObject.uPSFluxNdata"
    datatype: int
    description: The number of data points used to compute uPSFluxChi2.
    mysql:datatype: INT
  - name: uFPFluxMean
    "@id": "#DiaObject.uFPFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for u filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: uFPFluxMeanErr
    "@id": "#DiaObject.uFPFluxMeanErr"
    datatype: float
    description: Standard error of uFPFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: uFPFluxSigma
    "@id": "#DiaObject.uFPFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of uFPFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: gPSFluxMean
    "@id": "#DiaObject.gPSFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for g filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: gPSFluxMeanErr
    "@id": "#DiaObject.gPSFluxMeanErr"
    datatype: float
    description: Standard error of gPSFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: gPSFluxSigma
    "@id": "#DiaObject.gPSFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of gPSFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: gPSFluxChi2
    "@id": "#DiaObject.gPSFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of gPSFlux around gPSFluxMean.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: gPSFluxNdata
    "@id": "#DiaObject.gPSFluxNdata"
    datatype: int
    description: The number of data points used to compute gPSFluxChi2.
    mysql:datatype: INT
  - name: gFPFluxMean
    "@id": "#DiaObject.gFPFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for g filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: gFPFluxMeanErr
    "@id": "#DiaObject.gFPFluxMeanErr"
    datatype: float
    description: Standard error of gFPFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: gFPFluxSigma
    "@id": "#DiaObject.gFPFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of gFPFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: rPSFluxMean
    "@id": "#DiaObject.rPSFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for r filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: rPSFluxMeanErr
    "@id": "#DiaObject.rPSFluxMeanErr"
    datatype: float
    description: Standard error of rPSFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: rPSFluxSigma
    "@id": "#DiaObject.rPSFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of rPSFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: rPSFluxChi2
    "@id": "#DiaObject.rPSFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of rPSFlux around rPSFluxMean.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: rPSFluxNdata
    "@id": "#DiaObject.rPSFluxNdata"
    datatype: int
    description: The number of data points used to compute rPSFluxChi2.
    mysql:datatype: INT
  - name: rFPFluxMean
    "@id": "#DiaObject.rFPFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for r filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: rFPFluxMeanErr
    "@id": "#DiaObject.rFPFluxMeanErr"
    datatype: float
    description: Standard error of rFPFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: rFPFluxSigma
    "@id": "#DiaObject.rFPFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of rFPFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: iPSFluxMean
    "@id": "#DiaObject.iPSFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for i filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: iPSFluxMeanErr
    "@id": "#DiaObject.iPSFluxMeanErr"
    datatype: float
    description: Standard error of iPSFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: iPSFluxSigma
    "@id": "#DiaObject.iPSFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of iPSFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: iPSFluxChi2
    "@id": "#DiaObject.iPSFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of iPSFlux around iPSFluxMean.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: iPSFluxNdata
    "@id": "#DiaObject.iPSFluxNdata"
    datatype: int
    description: The number of data points used to compute iPSFluxChi2.
    mysql:datatype: INT
  - name: iFPFluxMean
    "@id": "#DiaObject.iFPFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for i filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: iFPFluxMeanErr
    "@id": "#DiaObject.iFPFluxMeanErr"
    datatype: float
    description: Standard error of iFPFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: iFPFluxSigma
    "@id": "#DiaObject.iFPFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of iFPFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: zPSFluxMean
    "@id": "#DiaObject.zPSFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for z filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: zPSFluxMeanErr
    "@id": "#DiaObject.zPSFluxMeanErr"
    datatype: float
    description: Standard error of zPSFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: zPSFluxSigma
    "@id": "#DiaObject.zPSFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of zPSFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: zPSFluxChi2
    "@id": "#DiaObject.zPSFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of zPSFlux around zPSFluxMean.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: zPSFluxNdata
    "@id": "#DiaObject.zPSFluxNdata"
    datatype: int
    description: The number of data points used to compute zPSFluxChi2.
    mysql:datatype: INT
  - name: zFPFluxMean
    "@id": "#DiaObject.zFPFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for z filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: zFPFluxMeanErr
    "@id": "#DiaObject.zFPFluxMeanErr"
    datatype: float
    description: Standard error of zFPFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: zFPFluxSigma
    "@id": "#DiaObject.zFPFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of zFPFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: yPSFluxMean
    "@id": "#DiaObject.yPSFluxMean"
    datatype: float
    description: Weighted mean point-source model magnitude for y filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: yPSFluxMeanErr
    "@id": "#DiaObject.yPSFluxMeanErr"
    datatype: float
    description: Standard error of yPSFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: yPSFluxSigma
    "@id": "#DiaObject.yPSFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of yPSFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: yPSFluxChi2
    "@id": "#DiaObject.yPSFluxChi2"
    datatype: float
    description: Chi^2 statistic for the scatter of yPSFlux around yPSFluxMean.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: yPSFluxNdata
    "@id": "#DiaObject.yPSFluxNdata"
    datatype: int
    description: The number of data points used to compute yPSFluxChi2.
    mysql:datatype: INT
  - name: yFPFluxMean
    "@id": "#DiaObject.yFPFluxMean"
    datatype: float
    description: Weighted mean forced photometry flux for y filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: yFPFluxMeanErr
    "@id": "#DiaObject.yFPFluxMeanErr"
    datatype: float
    description: Standard error of yFPFluxMean.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: yFPFluxSigma
    "@id": "#DiaObject.yFPFluxSigma"
    datatype: float
    description: Standard deviation of the distribution of yFPFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.stdev
  - name: uLcPeriodic
    "@id": "#DiaObject.uLcPeriodic"
    datatype: binary
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for u filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: gLcPeriodic
    "@id": "#DiaObject.gLcPeriodic"
    datatype: binary
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for g filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: rLcPeriodic
    "@id": "#DiaObject.rLcPeriodic"
    datatype: binary
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for r filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: iLcPeriodic
    "@id": "#DiaObject.iLcPeriodic"
    datatype: binary
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for i filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: zLcPeriodic
    "@id": "#DiaObject.zLcPeriodic"
    datatype: binary
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for z filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: yLcPeriodic
    "@id": "#DiaObject.yLcPeriodic"
    datatype: binary
    description: Periodic features extracted from light-curves using generalized Lomb-Scargle
      periodogram for y filter. [32 FLOAT].
    mysql:datatype: BLOB
  - name: uLcNonPeriodic
    "@id": "#DiaObject.uLcNonPeriodic"
    datatype: binary
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for u filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: gLcNonPeriodic
    "@id": "#DiaObject.gLcNonPeriodic"
    datatype: binary
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for g filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: rLcNonPeriodic
    "@id": "#DiaObject.rLcNonPeriodic"
    datatype: binary
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for r filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: iLcNonPeriodic
    "@id": "#DiaObject.iLcNonPeriodic"
    datatype: binary
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for i filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: zLcNonPeriodic
    "@id": "#DiaObject.zLcNonPeriodic"
    datatype: binary
    description: Non-periodic features extracted from light-curves using generalized
      Lomb-Scargle periodogram for z filter. [20 FLOAT].
    mysql:datatype: BLOB
  - name: yLcNonPeriodic
    "@id": "#DiaObject.yLcNonPeriodic"
    datatype: binary
    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.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: nearbyObj1Dist
    "@id": "#DiaObject.nearbyObj1Dist"
    datatype: float
    description: Distance to nearbyObj1.
    mysql:datatype: FLOAT
    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.
    mysql:datatype: FLOAT
  - name: nearbyObj2
    "@id": "#DiaObject.nearbyObj2"
    datatype: long
    description: Id of the second-closest nearby object.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: nearbyObj2Dist
    "@id": "#DiaObject.nearbyObj2Dist"
    datatype: float
    description: Distance to nearbyObj2.
    mysql:datatype: FLOAT
    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.
    mysql:datatype: FLOAT
  - name: nearbyObj3
    "@id": "#DiaObject.nearbyObj3"
    datatype: long
    description: Id of the third-closest nearby object.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: nearbyObj3Dist
    "@id": "#DiaObject.nearbyObj3Dist"
    datatype: float
    description: Distance to nearbyObj3.
    mysql:datatype: FLOAT
    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.
    mysql:datatype: FLOAT
  - name: flags
    "@id": "#DiaObject.flags"
    datatype: long
    description: Flags, bitwise OR tbd.
    defaultValue: '0'
    mysql:datatype: BIGINT
    ivoa:ucd: meta.code
  - name: htmId20
    "@id": "#DiaObject.htmId20"
    datatype: long
    description: HTM index.
    mysql:datatype: BIGINT
  primaryKey:
  - "#DiaObject.diaObjectId"
  - "#DiaObject.validityStart"
  indexes:
  - name: IDX_DiaObject_validityStart
    "@id": "#IDX_DiaObject_validityStart"
    columns:
    - "#DiaObject.validityStart"
  - name: IDX_DiaObject_htmId20
    "@id": "#IDX_DiaObject_htmId20"
    columns:
    - "#DiaObject.htmId20"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: SSObject
  "@id": "#SSObject"
  description: The SSObject table contains description of the Solar System (moving)
    Objects.
  columns:
  - name: ssObjectId
    "@id": "#SSObject.ssObjectId"
    datatype: long
    description: Unique identifier.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: q
    "@id": "#SSObject.q"
    datatype: double
    description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
    mysql:datatype: DOUBLE
  - name: qErr
    "@id": "#SSObject.qErr"
    datatype: double
    description: Uncertainty of q.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.error
  - name: e
    "@id": "#SSObject.e"
    datatype: double
    description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
    mysql:datatype: DOUBLE
  - name: eErr
    "@id": "#SSObject.eErr"
    datatype: double
    description: Uncertainty of e.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.error
  - name: i
    "@id": "#SSObject.i"
    datatype: double
    description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
    mysql:datatype: DOUBLE
  - name: iErr
    "@id": "#SSObject.iErr"
    datatype: double
    description: Uncertainty of i.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.error
  - name: lan
    "@id": "#SSObject.lan"
    datatype: double
    description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
    mysql:datatype: DOUBLE
  - name: lanErr
    "@id": "#SSObject.lanErr"
    datatype: double
    description: Uncertainty of lan.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.error
  - name: aop
    "@id": "#SSObject.aop"
    datatype: double
    description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
    mysql:datatype: DOUBLE
  - name: aopErr
    "@id": "#SSObject.aopErr"
    datatype: double
    description: Uncertainty of aop.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.error
  - name: M
    "@id": "#SSObject.M"
    datatype: double
    description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
    mysql:datatype: DOUBLE
  - name: MErr
    "@id": "#SSObject.MErr"
    datatype: double
    description: Uncertainty of M.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.error
  - name: epoch
    "@id": "#SSObject.epoch"
    datatype: double
    description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
    mysql:datatype: DOUBLE
  - name: epochErr
    "@id": "#SSObject.epochErr"
    datatype: double
    description: Uncertainty of epoch.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.error
  - name: q_e_Cov
    "@id": "#SSObject.q_e_Cov"
    datatype: double
    description: Covariance of q and e.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: q_i_Cov
    "@id": "#SSObject.q_i_Cov"
    datatype: double
    description: Covariance of q and i.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: q_lan_Cov
    "@id": "#SSObject.q_lan_Cov"
    datatype: double
    description: Covariance of q and lan.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: q_aop_Cov
    "@id": "#SSObject.q_aop_Cov"
    datatype: double
    description: Covariance of q and aop.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: q_M_Cov
    "@id": "#SSObject.q_M_Cov"
    datatype: double
    description: Covariance of q and M.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: q_epoch_Cov
    "@id": "#SSObject.q_epoch_Cov"
    datatype: double
    description: Covariance of q and epoch.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: e_i_Cov
    "@id": "#SSObject.e_i_Cov"
    datatype: double
    description: Covariance of e and i.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: e_lan_Cov
    "@id": "#SSObject.e_lan_Cov"
    datatype: double
    description: Covariance of e and lan.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: e_aop_Cov
    "@id": "#SSObject.e_aop_Cov"
    datatype: double
    description: Covariance of e and aop.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: e_M_Cov
    "@id": "#SSObject.e_M_Cov"
    datatype: double
    description: Covariance of e and M.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: e_epoch_Cov
    "@id": "#SSObject.e_epoch_Cov"
    datatype: double
    description: Covariance of e and epoch.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: i_lan_Cov
    "@id": "#SSObject.i_lan_Cov"
    datatype: double
    description: Covariance of i and lan.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: i_aop_Cov
    "@id": "#SSObject.i_aop_Cov"
    datatype: double
    description: Covariance of i and aop.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: i_M_Cov
    "@id": "#SSObject.i_M_Cov"
    datatype: double
    description: Covariance of i and M.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: i_epoch_Cov
    "@id": "#SSObject.i_epoch_Cov"
    datatype: double
    description: Covariance of i and epoch.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: lan_aop_Cov
    "@id": "#SSObject.lan_aop_Cov"
    datatype: double
    description: Covariance of lan and aop.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: lan_M_Cov
    "@id": "#SSObject.lan_M_Cov"
    datatype: double
    description: Covariance of lan and M.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: lan_epoch_Cov
    "@id": "#SSObject.lan_epoch_Cov"
    datatype: double
    description: Covariance of lan and epoch.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: aop_M_Cov
    "@id": "#SSObject.aop_M_Cov"
    datatype: double
    description: Covariance of aop and M.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: aop_epoch_Cov
    "@id": "#SSObject.aop_epoch_Cov"
    datatype: double
    description: Covariance of aop and epoch.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: M_epoch_Cov
    "@id": "#SSObject.M_epoch_Cov"
    datatype: double
    description: Covariance of M and epoch.
    mysql:datatype: DOUBLE
    ivoa:ucd: stat.covariance
  - name: arc
    "@id": "#SSObject.arc"
    datatype: float
    description: Arc of observation.
    mysql:datatype: FLOAT
    fits:tunit: days
  - name: orbFitLnL
    "@id": "#SSObject.orbFitLnL"
    datatype: float
    description: Natural log of the likelihood of the orbital elements fit.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.likelihood
  - name: orbFitChi2
    "@id": "#SSObject.orbFitChi2"
    datatype: float
    description: Chi^2 statistic of the orbital elements fit.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: orbFitNdata
    "@id": "#SSObject.orbFitNdata"
    datatype: int
    description: Number of observations used in the fit.
    mysql:datatype: INTEGER
  - name: MOID1
    "@id": "#SSObject.MOID1"
    datatype: float
    description: Minimum orbit intersection distance.
    mysql:datatype: FLOAT
    fits:tunit: AU
  - name: MOID2
    "@id": "#SSObject.MOID2"
    datatype: float
    description: Minimum orbit intersection distance.
    mysql:datatype: FLOAT
    fits:tunit: AU
  - name: moidLon1
    "@id": "#SSObject.moidLon1"
    datatype: double
    description: MOID longitudes.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: moidLon2
    "@id": "#SSObject.moidLon2"
    datatype: double
    description: MOID longitudes.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: uH
    "@id": "#SSObject.uH"
    datatype: float
    description: Mean absolute magnitude for u filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: uHErr
    "@id": "#SSObject.uHErr"
    datatype: float
    description: Uncertainty of uH estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: uG1
    "@id": "#SSObject.uG1"
    datatype: float
    description: Fitted G1 slope parameter for u filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: uG1Err
    "@id": "#SSObject.uG1Err"
    datatype: float
    description: Uncertainty of uG1 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: uG2
    "@id": "#SSObject.uG2"
    datatype: float
    description: Fitted G2 slope parameter for u filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: uG2Err
    "@id": "#SSObject.uG2Err"
    datatype: float
    description: Uncertainty of uG2 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: gH
    "@id": "#SSObject.gH"
    datatype: float
    description: Mean absolute magnitude for g filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: gHErr
    "@id": "#SSObject.gHErr"
    datatype: float
    description: Uncertainty of gH estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: gG1
    "@id": "#SSObject.gG1"
    datatype: float
    description: Fitted G1 slope parameter for g filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: gG1Err
    "@id": "#SSObject.gG1Err"
    datatype: float
    description: Uncertainty of gG1 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: gG2
    "@id": "#SSObject.gG2"
    datatype: float
    description: Fitted G2 slope parameter for g filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: gG2Err
    "@id": "#SSObject.gG2Err"
    datatype: float
    description: Uncertainty of gG2 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: rH
    "@id": "#SSObject.rH"
    datatype: float
    description: Mean absolute magnitude for r filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: rHErr
    "@id": "#SSObject.rHErr"
    datatype: float
    description: Uncertainty of rH estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: rG1
    "@id": "#SSObject.rG1"
    datatype: float
    description: Fitted G1 slope parameter for r filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: rG1Err
    "@id": "#SSObject.rG1Err"
    datatype: float
    description: Uncertainty of rG1 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: rG2
    "@id": "#SSObject.rG2"
    datatype: float
    description: Fitted G2 slope parameter for r filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: rG2Err
    "@id": "#SSObject.rG2Err"
    datatype: float
    description: Uncertainty of rG2 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: iH
    "@id": "#SSObject.iH"
    datatype: float
    description: Mean absolute magnitude for i filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: iHErr
    "@id": "#SSObject.iHErr"
    datatype: float
    description: Uncertainty of iH estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: iG1
    "@id": "#SSObject.iG1"
    datatype: float
    description: Fitted G1 slope parameter for i filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: iG1Err
    "@id": "#SSObject.iG1Err"
    datatype: float
    description: Uncertainty of iG1 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: iG2
    "@id": "#SSObject.iG2"
    datatype: float
    description: Fitted G2 slope parameter for i filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: iG2Err
    "@id": "#SSObject.iG2Err"
    datatype: float
    description: Uncertainty of iG2 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: zH
    "@id": "#SSObject.zH"
    datatype: float
    description: Mean absolute magnitude for z filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: zHErr
    "@id": "#SSObject.zHErr"
    datatype: float
    description: Uncertainty of zH estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: zG1
    "@id": "#SSObject.zG1"
    datatype: float
    description: Fitted G1 slope parameter for z filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: zG1Err
    "@id": "#SSObject.zG1Err"
    datatype: float
    description: Uncertainty of zG1 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: zG2
    "@id": "#SSObject.zG2"
    datatype: float
    description: Fitted G2 slope parameter for z filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: zG2Err
    "@id": "#SSObject.zG2Err"
    datatype: float
    description: Uncertainty of zG2 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: yH
    "@id": "#SSObject.yH"
    datatype: float
    description: Mean absolute magnitude for y filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: yHErr
    "@id": "#SSObject.yHErr"
    datatype: float
    description: Uncertainty of yH estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: yG1
    "@id": "#SSObject.yG1"
    datatype: float
    description: Fitted G1 slope parameter for y filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: yG1Err
    "@id": "#SSObject.yG1Err"
    datatype: float
    description: Uncertainty of yG1 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: yG2
    "@id": "#SSObject.yG2"
    datatype: float
    description: Fitted G2 slope parameter for y filter.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: yG2Err
    "@id": "#SSObject.yG2Err"
    datatype: float
    description: Uncertainty of yG2 estimate.
    mysql:datatype: FLOAT
    fits:tunit: mag
    ivoa:ucd: stat.error
  - name: flags
    "@id": "#SSObject.flags"
    datatype: long
    description: Flags, bitwise OR tbd.
    defaultValue: '0'
    mysql:datatype: BIGINT
    ivoa:ucd: meta.code
  primaryKey: "#SSObject.ssObjectId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- 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
    description: Unique id.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: ccdVisitId
    "@id": "#DiaSource.ccdVisitId"
    datatype: long
    description: Id of the ccdVisit where this diaSource was measured. Note that we
      are allowing a diaSource to belong to multiple amplifiers, but it may not span
      multiple ccds.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: diaObjectId
    "@id": "#DiaSource.diaObjectId"
    datatype: long
    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).
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: ssObjectId
    "@id": "#DiaSource.ssObjectId"
    datatype: long
    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).
    mysql:datatype: BIGINT
    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.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: prv_procOrder
    "@id": "#DiaSource.prv_procOrder"
    datatype: int
    description: Position of this diaSource in the processing order relative to other
      diaSources within a given diaObjectId or ssObjectId.
    mysql:datatype: INT
  - name: ssObjectReassocTime
    "@id": "#DiaSource.ssObjectReassocTime"
    datatype: timestamp
    description: Time when this diaSource was reassociated from diaObject to ssObject
      (if such reassociation happens, otherwise NULL).
    mysql:datatype: DATETIME
  - name: midPointTai
    "@id": "#DiaSource.midPointTai"
    datatype: double
    description: Effective mid-exposure time for this diaSource.
    mysql:datatype: DOUBLE
    fits:tunit: d
    ivoa:ucd: time.epoch
  - name: ra
    "@id": "#DiaSource.ra"
    datatype: double
    description: RA-coordinate of the center of this diaSource.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: raErr
    "@id": "#DiaSource.raErr"
    datatype: float
    description: Uncertainty of ra.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: decl
    "@id": "#DiaSource.decl"
    datatype: double
    description: " Decl-coordinate of the center of this diaSource."
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: declErr
    "@id": "#DiaSource.declErr"
    datatype: float
    description: Uncertainty of decl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: ra_decl_Cov
    "@id": "#DiaSource.ra_decl_Cov"
    datatype: float
    description: Covariance between ra and decl.
    mysql:datatype: FLOAT
    fits:tunit: deg^2
    ivoa:ucd: stat.covariance
  - name: x
    "@id": "#DiaSource.x"
    datatype: float
    description: x position computed by a centroiding algorithm.
    mysql:datatype: FLOAT
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.x
  - name: xErr
    "@id": "#DiaSource.xErr"
    datatype: float
    description: Uncertainty of x.
    mysql:datatype: FLOAT
    fits:tunit: pixel
    ivoa:ucd: stat.error:pos.cartesian.x
  - name: y
    "@id": "#DiaSource.y"
    datatype: float
    description: y position computed by a centroiding algorithm.
    mysql:datatype: FLOAT
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.y
  - name: yErr
    "@id": "#DiaSource.yErr"
    datatype: float
    description: Uncertainty of y.
    mysql:datatype: FLOAT
    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.
    mysql:datatype: FLOAT
    fits:tunit: pixel^2
    ivoa:ucd: stat.covariance
  - name: apFlux
    "@id": "#DiaSource.apFlux"
    datatype: float
    description: Calibrated aperture flux. Note that this actually measures the difference
      between the template and the visit image.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: apFluxErr
    "@id": "#DiaSource.apFluxErr"
    datatype: float
    description: Estimated uncertainty of apFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    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.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.snr
  - name: psFlux
    "@id": "#DiaSource.psFlux"
    datatype: float
    description: Calibrated flux for Point Source model. Note this actually measures
      the flux difference between the template and the visit image.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: psFluxErr
    "@id": "#DiaSource.psFluxErr"
    datatype: float
    description: Uncertainty of psFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: psRa
    "@id": "#DiaSource.psRa"
    datatype: double
    description: " RA-coordinate of centroid for point source model."
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: psRaErr
    "@id": "#DiaSource.psRaErr"
    datatype: float
    description: Uncertainty of psRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: psDecl
    "@id": "#DiaSource.psDecl"
    datatype: double
    description: " Decl-coordinate of centroid for point source model."
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: psDeclErr
    "@id": "#DiaSource.psDeclErr"
    datatype: float
    description: Uncertainty of psDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: psFlux_psRa_Cov
    "@id": "#DiaSource.psFlux_psRa_Cov"
    datatype: float
    description: Covariance between psFlux and psRa.
    mysql:datatype: FLOAT
    fits:tunit: ngmy*deg
    ivoa:ucd: stat.covariance
  - name: psFlux_psDecl_Cov
    "@id": "#DiaSource.psFlux_psDecl_Cov"
    datatype: float
    description: Covariance between psFlux and psDecl.
    mysql:datatype: FLOAT
    fits:tunit: ngmy*deg
    ivoa:ucd: stat.covariance
  - name: psRa_psDecl_Cov
    "@id": "#DiaSource.psRa_psDecl_Cov"
    datatype: float
    description: Covariance between psRa and psDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg^2
    ivoa:ucd: stat.covariance
  - name: psLnL
    "@id": "#DiaSource.psLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the Point Source
      model.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.likelihood
  - name: psChi2
    "@id": "#DiaSource.psChi2"
    datatype: float
    description: Chi^2 statistic of the model fit.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: psNdata
    "@id": "#DiaSource.psNdata"
    datatype: int
    description: The number of data points (pixels) used to fit the model.
    mysql:datatype: INT
  - name: trailFlux
    "@id": "#DiaSource.trailFlux"
    datatype: float
    description: Calibrated flux for a trailed source model. Note this actually measures
      the flux difference between the template and the visit image.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: trailFluxErr
    "@id": "#DiaSource.trailFluxErr"
    datatype: float
    description: Uncertainty of trailFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: trailRa
    "@id": "#DiaSource.trailRa"
    datatype: double
    description: " RA-coordinate of centroid for trailed source model."
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: trailRaErr
    "@id": "#DiaSource.trailRaErr"
    datatype: float
    description: Uncertainty of trailRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: trailDecl
    "@id": "#DiaSource.trailDecl"
    datatype: double
    description: " Decl-coordinate of centroid for trailed source model."
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: trailDeclErr
    "@id": "#DiaSource.trailDeclErr"
    datatype: float
    description: Uncertainty of trailDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: trailLength
    "@id": "#DiaSource.trailLength"
    datatype: float
    description: Maximum likelihood fit of trail length.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: trailLengthErr
    "@id": "#DiaSource.trailLengthErr"
    datatype: float
    description: Uncertainty of trailLength.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - 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).
    mysql:datatype: FLOAT
    fits:tunit: deg
  - name: trailAngleErr
    "@id": "#DiaSource.trailAngleErr"
    datatype: float
    description: Uncertainty of trailAngle.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: trailFlux_trailRa_Cov
    "@id": "#DiaSource.trailFlux_trailRa_Cov"
    datatype: float
    description: Covariance of trailFlux and trailRa.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailFlux_trailDecl_Cov
    "@id": "#DiaSource.trailFlux_trailDecl_Cov"
    datatype: float
    description: Covariance of trailFlux and trailDecl.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailFlux_trailLength_Cov
    "@id": "#DiaSource.trailFlux_trailLength_Cov"
    datatype: float
    description: Covariance of trailFlux and trailLength
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailFlux_trailAngle_Cov
    "@id": "#DiaSource.trailFlux_trailAngle_Cov"
    datatype: float
    description: Covariance of trailFlux and trailAngle
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailRa_trailDecl_Cov
    "@id": "#DiaSource.trailRa_trailDecl_Cov"
    datatype: float
    description: Covariance of trailRa and trailDecl.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailRa_trailLength_Cov
    "@id": "#DiaSource.trailRa_trailLength_Cov"
    datatype: float
    description: Covariance of trailRa and trailLength.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailRa_trailAngle_Cov
    "@id": "#DiaSource.trailRa_trailAngle_Cov"
    datatype: float
    description: Covariance of trailRa and trailAngle.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailDecl_trailLength_Cov
    "@id": "#DiaSource.trailDecl_trailLength_Cov"
    datatype: float
    description: Covariance of trailDecl and trailLength.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailDecl_trailAngle_Cov
    "@id": "#DiaSource.trailDecl_trailAngle_Cov"
    datatype: float
    description: Covariance of trailDecl and trailAngle.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailLength_trailAngle_Cov
    "@id": "#DiaSource.trailLength_trailAngle_Cov"
    datatype: float
    description: Covariance of trailLength and trailAngle
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: trailLnL
    "@id": "#DiaSource.trailLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the trailed source
      model.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.likelihood
  - name: trailChi2
    "@id": "#DiaSource.trailChi2"
    datatype: float
    description: Chi^2 statistic of the model fit.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: trailNdata
    "@id": "#DiaSource.trailNdata"
    datatype: int
    description: The number of data points (pixels) used to fit the model.
    mysql:datatype: INT
  - name: dipMeanFlux
    "@id": "#DiaSource.dipMeanFlux"
    datatype: float
    description: Maximum likelihood value for the mean absolute flux of the two lobes
      for a dipole model.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: dipMeanFluxErr
    "@id": "#DiaSource.dipMeanFluxErr"
    datatype: float
    description: Uncertainty of dipMeanFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: dipFluxDiff
    "@id": "#DiaSource.dipFluxDiff"
    datatype: float
    description: Maximum likelihood value for the difference of absolute fluxes of
      the two lobes for a dipole model.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: dipFluxDiffErr
    "@id": "#DiaSource.dipFluxDiffErr"
    datatype: float
    description: Uncertainty of dipFluxDiff.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error
  - name: dipRa
    "@id": "#DiaSource.dipRa"
    datatype: double
    description: " RA-coordinate of centroid for dipole model."
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: dipRaErr
    "@id": "#DiaSource.dipRaErr"
    datatype: float
    description: Uncertainty of trailRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: dipDecl
    "@id": "#DiaSource.dipDecl"
    datatype: double
    description: " Decl-coordinate of centroid for dipole model."
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: dipDeclErr
    "@id": "#DiaSource.dipDeclErr"
    datatype: float
    description: Uncertainty of dipDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: dipLength
    "@id": "#DiaSource.dipLength"
    datatype: float
    description: Maximum likelihood value for the lobe separation in dipole model.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
    ivoa:ucd: pos.angDistance
  - name: dipLengthErr
    "@id": "#DiaSource.dipLengthErr"
    datatype: float
    description: Uncertainty of dipLength.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.angDistance
  - name: dipAngle
    "@id": "#DiaSource.dipAngle"
    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).
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: pos.posAng
  - name: dipAngleErr
    "@id": "#DiaSource.dipAngleErr"
    datatype: float
    description: Uncertainty of dipAngle.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.posAng
  - name: dipMeanFlux_dipFluxDiff_Cov
    "@id": "#DiaSource.dipMeanFlux_dipFluxDiff_Cov"
    datatype: float
    description: Covariance of dipMeanFlux and dipFluxDiff.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipMeanFlux_dipRa_Cov
    "@id": "#DiaSource.dipMeanFlux_dipRa_Cov"
    datatype: float
    description: Covariance of dipMeanFlux and dipRa.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipMeanFlux_dipDecl_Cov
    "@id": "#DiaSource.dipMeanFlux_dipDecl_Cov"
    datatype: float
    description: Covariance of dipMeanFlux and dipDecl.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipMeanFlux_dipLength_Cov
    "@id": "#DiaSource.dipMeanFlux_dipLength_Cov"
    datatype: float
    description: Covariance of dipMeanFlux and dipLength.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipMeanFlux_dipAngle_Cov
    "@id": "#DiaSource.dipMeanFlux_dipAngle_Cov"
    datatype: float
    description: Covariance of dipMeanFlux and dipAngle.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipFluxDiff_dipRa_Cov
    "@id": "#DiaSource.dipFluxDiff_dipRa_Cov"
    datatype: float
    description: Covariance of dipFluxDiff and dipRa.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipFluxDiff_dipDecl_Cov
    "@id": "#DiaSource.dipFluxDiff_dipDecl_Cov"
    datatype: float
    description: Covariance of dipFluxDiff and dipDecl.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipFluxDiff_dipLength_Cov
    "@id": "#DiaSource.dipFluxDiff_dipLength_Cov"
    datatype: float
    description: Covariance of dipFluxDiff and dipLength.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipFluxDiff_dipAngle_Cov
    "@id": "#DiaSource.dipFluxDiff_dipAngle_Cov"
    datatype: float
    description: Covariance of dipFluxDiff and dipAngle.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipRa_dipDecl_Cov
    "@id": "#DiaSource.dipRa_dipDecl_Cov"
    datatype: float
    description: Covariance of dipRa and dipDecl.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipRa_dipLength_Cov
    "@id": "#DiaSource.dipRa_dipLength_Cov"
    datatype: float
    description: Covariance of dipRa and dipLength.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipRa_dipAngle_Cov
    "@id": "#DiaSource.dipRa_dipAngle_Cov"
    datatype: float
    description: Covariance of dipRa and dipAngle.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipDecl_dipLength_Cov
    "@id": "#DiaSource.dipDecl_dipLength_Cov"
    datatype: float
    description: Covariance of dipDecl and dipLength.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipDecl_dipAngle_Cov
    "@id": "#DiaSource.dipDecl_dipAngle_Cov"
    datatype: float
    description: Covariance of dipDecl and dipAngle.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipLength_dipAngle_Cov
    "@id": "#DiaSource.dipLength_dipAngle_Cov"
    datatype: float
    description: Covariance of dipLength and dipAngle.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.covariance
  - name: dipLnL
    "@id": "#DiaSource.dipLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the dipole source
      model.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.likelihood
  - name: dipChi2
    "@id": "#DiaSource.dipChi2"
    datatype: float
    description: Chi^2 statistic of the model fit.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.fit.chi2
  - name: dipNdata
    "@id": "#DiaSource.dipNdata"
    datatype: int
    description: The number of data points (pixels) used to fit the model.
    mysql:datatype: INT
  - name: totFlux
    "@id": "#DiaSource.totFlux"
    datatype: float
    description: Calibrated flux for Point Source model measured on the visit image
      centered at the centroid measured on the difference image (forced photometry
      flux).
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: totFluxErr
    "@id": "#DiaSource.totFluxErr"
    datatype: float
    description: Estimated uncertainty of totFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: diffFlux
    "@id": "#DiaSource.diffFlux"
    datatype: float
    description: Calibrated flux for Point Source model centered on radec but measured
      on the difference of snaps comprising this visit.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: diffFluxErr
    "@id": "#DiaSource.diffFluxErr"
    datatype: float
    description: Estimated uncertainty of diffFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: fpBkgd
    "@id": "#DiaSource.fpBkgd"
    datatype: float
    description: Estimated sky background at the position (centroid) of the object.
    mysql:datatype: FLOAT
    fits:tunit: nmgy/asec^2
  - name: fpBkgdErr
    "@id": "#DiaSource.fpBkgdErr"
    datatype: float
    description: Estimated uncertainty of fpBkgd.
    mysql:datatype: FLOAT
    fits:tunit: nmgy/asec^2
  - name: ixx
    "@id": "#DiaSource.ixx"
    datatype: float
    description: Adaptive second moment of the source intensity.
    mysql:datatype: FLOAT
    fits:tunit: nmgy*asec^2
  - name: ixxErr
    "@id": "#DiaSource.ixxErr"
    datatype: float
    description: Uncertainty of ixx.
    mysql:datatype: FLOAT
    fits:tunit: nmgy*asec^2
    ivoa:ucd: stat.error
  - name: iyy
    "@id": "#DiaSource.iyy"
    datatype: float
    description: Adaptive second moment of the source intensity.
    mysql:datatype: FLOAT
    fits:tunit: nmgy*asec^2
  - name: iyyErr
    "@id": "#DiaSource.iyyErr"
    datatype: float
    description: Uncertainty of iyy.
    mysql:datatype: FLOAT
    fits:tunit: nmgy*asec^2
    ivoa:ucd: stat.error
  - name: ixy
    "@id": "#DiaSource.ixy"
    datatype: float
    description: Adaptive second moment of the source intensity.
    mysql:datatype: FLOAT
    fits:tunit: nmgy*asec^2
  - name: ixyErr
    "@id": "#DiaSource.ixyErr"
    datatype: float
    description: Uncertainty of ixy.
    mysql:datatype: FLOAT
    fits:tunit: nmgy*asec^2
    ivoa:ucd: stat.error
  - name: ixx_iyy_Cov
    "@id": "#DiaSource.ixx_iyy_Cov"
    datatype: float
    description: Covariance of ixx and iyy.
    mysql:datatype: FLOAT
    fits:tunit: nmgy^2*asec^4
  - name: ixx_ixy_Cov
    "@id": "#DiaSource.ixx_ixy_Cov"
    datatype: float
    description: Covariance of ixx and ixy.
    mysql:datatype: FLOAT
    fits:tunit: nmgy^2*asec^4
  - name: iyy_ixy_Cov
    "@id": "#DiaSource.iyy_ixy_Cov"
    datatype: float
    description: Covariance of iyy and ixy.
    mysql:datatype: FLOAT
    fits:tunit: nmgy^2*asec^4
  - name: ixxPSF
    "@id": "#DiaSource.ixxPSF"
    datatype: float
    description: Adaptive second moment for the PSF.
    mysql:datatype: FLOAT
    fits:tunit: nmgy*asec^2
  - name: iyyPSF
    "@id": "#DiaSource.iyyPSF"
    datatype: float
    description: Adaptive second moment for the PSF.
    mysql:datatype: FLOAT
    fits:tunit: nmgy*asec^2
  - name: ixyPSF
    "@id": "#DiaSource.ixyPSF"
    datatype: float
    description: Adaptive second moment for the PSF.
    mysql:datatype: FLOAT
    fits:tunit: nmgy*asec^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.
    mysql:datatype: FLOAT
  - name: spuriousness
    "@id": "#DiaSource.spuriousness"
    datatype: float
    description: A measure of spuriousness, 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.).
    mysql:datatype: FLOAT
  - name: flags
    "@id": "#DiaSource.flags"
    datatype: long
    description: Flags, bitwise OR tbd.
    defaultValue: '0'
    mysql:datatype: BIGINT
    ivoa:ucd: meta.code
  - name: htmId20
    "@id": "#DiaSource.htmId20"
    datatype: long
    description: HTM index.
    mysql:datatype: BIGINT
  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"
  - name: IDX_DiaSource_htmId20
    "@id": "#IDX_DiaSource_htmId20"
    columns:
    - "#DiaSource.htmId20"
  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: diaObjectId
    "@id": "#DiaForcedSource.diaObjectId"
    datatype: long
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: ccdVisitId
    "@id": "#DiaForcedSource.ccdVisitId"
    datatype: long
    description: Id of the visit where this forcedSource was measured. Note that we
      are allowing a forcedSource to belong to multiple amplifiers, but it may not
      span multiple ccds.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: psFlux
    "@id": "#DiaForcedSource.psFlux"
    datatype: float
    description: Point Source model flux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: psFluxErr
    "@id": "#DiaForcedSource.psFluxErr"
    datatype: float
    description: Uncertainty of psFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: x
    "@id": "#DiaForcedSource.x"
    datatype: float
    description: x position at which psFlux has been measured.
    mysql:datatype: FLOAT
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.x
  - name: y
    "@id": "#DiaForcedSource.y"
    datatype: float
    description: y position at which psFlux has been measured.
    mysql:datatype: FLOAT
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.y
  - name: flags
    "@id": "#DiaForcedSource.flags"
    datatype: long
    description: Flags, bitwise OR tbd
    defaultValue: '0'
    mysql:datatype: BIGINT
    ivoa:ucd: meta.code
  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
    description: Id of diaObject.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: objectId
    "@id": "#DiaObject_To_Object_Match.objectId"
    datatype: long
    description: Id of a nearby object.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: dist
    "@id": "#DiaObject_To_Object_Match.dist"
    datatype: float
    description: The distance between the diaObject and the object.
    mysql:datatype: FLOAT
    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.
    mysql:datatype: FLOAT
  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: Object
  "@id": "#Object"
  description: The Object table contains descriptions of the multi-epoch static astronomical
    objects, in particular their astrophysical properties as derived from analysis
    of the Sources that are associated with them. Note that fast moving objects are
    kept in the MovingObject tables. Note that less-frequently used columns are stored
    in a separate table called Object_Extra.
  columns:
  - name: objectId
    "@id": "#Object.objectId"
    datatype: long
    description: Unique id.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: parentObjectId
    "@id": "#Object.parentObjectId"
    datatype: long
    description: Id of the parent object this object has been deblended from, if any.
    mysql:datatype: BIGINT
  - name: prv_inputId
    "@id": "#Object.prv_inputId"
    datatype: int
    description: Pointer to prv_InputType. Indicates which input was used to produce
      a given object.
    mysql:datatype: INT
  - name: psRa
    "@id": "#Object.psRa"
    datatype: double
    description: RA-coordinate of the center of the object for the Point Source model
      at time 'psEpoch'.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: psRaErr
    "@id": "#Object.psRaErr"
    datatype: float
    description: Uncertainty of psRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: psDecl
    "@id": "#Object.psDecl"
    datatype: double
    description: Decl-coordinate of the center of the object for the Point Source
      model at time 'psEpoch'.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: psDeclErr
    "@id": "#Object.psDeclErr"
    datatype: float
    description: Uncertainty of psDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: psMuRa
    "@id": "#Object.psMuRa"
    datatype: float
    description: Proper motion (ra) for the Point Source model.
    mysql:datatype: FLOAT
    fits:tunit: mas/yr
    ivoa:ucd: pos.pm
  - name: psMuRaErr
    "@id": "#Object.psMuRaErr"
    datatype: float
    description: Uncertainty of psMuRa.
    mysql:datatype: FLOAT
    fits:tunit: mas/yr
    ivoa:ucd: stat.error;pos.pm
  - name: psMuDecl
    "@id": "#Object.psMuDecl"
    datatype: float
    description: Proper motion (decl) for the Point Source model.
    mysql:datatype: FLOAT
    fits:tunit: mas/yr
    ivoa:ucd: pos.pm
  - name: psMuDeclErr
    "@id": "#Object.psMuDeclErr"
    datatype: float
    description: Uncertainty of psMuDecl.
    mysql:datatype: FLOAT
    fits:tunit: mas/yr
    ivoa:ucd: stat.error;pos.pm
  - name: psParallax
    "@id": "#Object.psParallax"
    datatype: float
    description: Stellar parallax. for the Point Source model.
    mysql:datatype: FLOAT
    fits:tunit: mas
    ivoa:ucd: pos.parallax
  - name: psParallaxErr
    "@id": "#Object.psParallaxErr"
    datatype: float
    description: Uncertainty of psParallax.
    mysql:datatype: FLOAT
    fits:tunit: mas
    ivoa:ucd: stat.error;pos.parallax
  - name: uPsFlux
    "@id": "#Object.uPsFlux"
    datatype: float
    description: Calibrated flux for Point Source model for u filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: uPsFluxErr
    "@id": "#Object.uPsFluxErr"
    datatype: float
    description: Uncertainty of uPsFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: gPsFlux
    "@id": "#Object.gPsFlux"
    datatype: float
    description: Calibrated flux for Point Source model for g filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: gPsFluxErr
    "@id": "#Object.gPsFluxErr"
    datatype: float
    description: Uncertainty of gPsFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: rPsFlux
    "@id": "#Object.rPsFlux"
    datatype: float
    description: Calibrated flux for Point Source model for r filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: rPsFluxErr
    "@id": "#Object.rPsFluxErr"
    datatype: float
    description: Uncertainty of rPsFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: iPsFlux
    "@id": "#Object.iPsFlux"
    datatype: float
    description: Calibrated flux for Point Source model for i filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: iPsFluxErr
    "@id": "#Object.iPsFluxErr"
    datatype: float
    description: Uncertainty of iPsFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: zPsFlux
    "@id": "#Object.zPsFlux"
    datatype: float
    description: Calibrated flux for Point Source model for z filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: zPsFluxErr
    "@id": "#Object.zPsFluxErr"
    datatype: float
    description: Uncertainty of zPsFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: yPsFlux
    "@id": "#Object.yPsFlux"
    datatype: float
    description: Calibrated flux for Point Source model for y filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: yPsFluxErr
    "@id": "#Object.yPsFluxErr"
    datatype: float
    description: Uncertainty of yPsFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: psLnL
    "@id": "#Object.psLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the Point Source
      model.
    mysql:datatype: FLOAT
  - name: psChi2
    "@id": "#Object.psChi2"
    datatype: float
    description: Chi^2 static of the model fit.
    mysql:datatype: FLOAT
  - name: psN
    "@id": "#Object.psN"
    datatype: int
    description: The number of data points (pixels) used to fit the model.
    mysql:datatype: INT
  - name: uBbdRa
    "@id": "#Object.uBbdRa"
    datatype: double
    description: RA-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For u filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: uBdRaErr
    "@id": "#Object.uBdRaErr"
    datatype: float
    description: Uncertainty of uBdRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: uBdDecl
    "@id": "#Object.uBdDecl"
    datatype: double
    description: Decl-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For u filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: uBdDeclErr
    "@id": "#Object.uBdDeclErr"
    datatype: float
    description: Uncertainty of uBdDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: uBdE1
    "@id": "#Object.uBdE1"
    datatype: float
    description: Ellipticity for the Bulge+Disk (e1). For u filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: uBdE1Err
    "@id": "#Object.uBdE1Err"
    datatype: float
    description: Uncertainty of uBdE1.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: uBdE2
    "@id": "#Object.uBdE2"
    datatype: float
    description: Ellipticity for Bulge+Disk model (e2). For u filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: uBdE2Err
    "@id": "#Object.uBdE2Err"
    datatype: float
    description: Uncertainty of uBdE2.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: uBdFluxB
    "@id": "#Object.uBdFluxB"
    datatype: float
    description: Integrated flux of the de Vaucouleurs component for the Bulge+Disk
      model. For u filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: uBdFluxBErr
    "@id": "#Object.uBdFluxBErr"
    datatype: float
    description: Uncertainty of uBdFluxB.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: uBdFluxD
    "@id": "#Object.uBdFluxD"
    datatype: float
    description: Integrated flux of the exponential component for the Bulge+Disk model.
      For u filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: uBdFluxDErr
    "@id": "#Object.uBdFluxDErr"
    datatype: float
    description: Uncertainty of uBdFluxD.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: uBdReB
    "@id": "#Object.uBdReB"
    datatype: float
    description: Effective radius of the de Vaucouleurs profile component for the
      Bulge+Disk model. For u filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uBdReBErr
    "@id": "#Object.uBdReBErr"
    datatype: float
    description: Uncertainty of uBdReB.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uBdReD
    "@id": "#Object.uBdReD"
    datatype: float
    description: Effective radius of the exponential profile component for the Bulge+Disk
      model. For u filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uBdReDErr
    "@id": "#Object.uBdReDErr"
    datatype: float
    description: Uncertainty of uBdReD.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uBdLnL
    "@id": "#Object.uBdLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the Bulge+Disk
      model. For u filter.
    mysql:datatype: FLOAT
  - name: uBdChi2
    "@id": "#Object.uBdChi2"
    datatype: float
    description: Chi^2 static of the model fit. For u filter.
    mysql:datatype: FLOAT
  - name: uBdN
    "@id": "#Object.uBdN"
    datatype: int
    description: The number of data points (pixels) used to fit the model. For u filter.
    mysql:datatype: INT
  - name: gBbdRa
    "@id": "#Object.gBbdRa"
    datatype: double
    description: RA-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For g filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: gBdRaErr
    "@id": "#Object.gBdRaErr"
    datatype: float
    description: Uncertainty of gBdRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: gBdDecl
    "@id": "#Object.gBdDecl"
    datatype: double
    description: Decl-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For g filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: gBdDeclErr
    "@id": "#Object.gBdDeclErr"
    datatype: float
    description: Uncertainty of gBdDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: gBdE1
    "@id": "#Object.gBdE1"
    datatype: float
    description: Ellipticity for the Bulge+Disk (e1). For g filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: gBdE1Err
    "@id": "#Object.gBdE1Err"
    datatype: float
    description: Uncertainty of gBdE1.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: gBdE2
    "@id": "#Object.gBdE2"
    datatype: float
    description: Ellipticity for Bulge+Disk model (e2). For g filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: gBdE2Err
    "@id": "#Object.gBdE2Err"
    datatype: float
    description: Uncertainty of gBdE2.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: gBdFluxB
    "@id": "#Object.gBdFluxB"
    datatype: float
    description: Integrated flux of the de Vaucouleurs component for the Bulge+Disk
      model. For g filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: gBdFluxBErr
    "@id": "#Object.gBdFluxBErr"
    datatype: float
    description: Uncertainty of gBdFluxB.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: gBdFluxD
    "@id": "#Object.gBdFluxD"
    datatype: float
    description: Integrated flux of the exponential component for the Bulge+Disk model.
      For g filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: gBdFluxDErr
    "@id": "#Object.gBdFluxDErr"
    datatype: float
    description: Uncertainty of gBdFluxD.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: gBdReB
    "@id": "#Object.gBdReB"
    datatype: float
    description: Effective radius of the de Vaucouleurs profile component for the
      Bulge+Disk model. For g filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gBdReBErr
    "@id": "#Object.gBdReBErr"
    datatype: float
    description: Uncertainty of gBdReB.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gBdReD
    "@id": "#Object.gBdReD"
    datatype: float
    description: Effective radius of the exponential profile component for the Bulge+Disk
      model. For g filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gBdReDErr
    "@id": "#Object.gBdReDErr"
    datatype: float
    description: Uncertainty of gBdReD.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gBdLnL
    "@id": "#Object.gBdLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the Bulge+Disk
      model. For g filter.
    mysql:datatype: FLOAT
  - name: gBdChi2
    "@id": "#Object.gBdChi2"
    datatype: float
    description: Chi^2 static of the model fit. For g filter.
    mysql:datatype: FLOAT
  - name: gBdN
    "@id": "#Object.gBdN"
    datatype: int
    description: The number of data points (pixels) used to fit the model. For g filter.
    mysql:datatype: INT
  - name: rBbdRa
    "@id": "#Object.rBbdRa"
    datatype: double
    description: RA-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For r filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: rBdRaErr
    "@id": "#Object.rBdRaErr"
    datatype: float
    description: Uncertainty of rBdRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: rBdDecl
    "@id": "#Object.rBdDecl"
    datatype: double
    description: Decl-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For r filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: rBdDeclErr
    "@id": "#Object.rBdDeclErr"
    datatype: float
    description: Uncertainty of rBdDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: rBdE1
    "@id": "#Object.rBdE1"
    datatype: float
    description: Ellipticity for the Bulge+Disk (e1). For r filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: rBdE1Err
    "@id": "#Object.rBdE1Err"
    datatype: float
    description: Uncertainty of rBdE1.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: rBdE2
    "@id": "#Object.rBdE2"
    datatype: float
    description: Ellipticity for Bulge+Disk model (e2). For r filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: rBdE2Err
    "@id": "#Object.rBdE2Err"
    datatype: float
    description: Uncertainty of rBdE2.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: rBdFluxB
    "@id": "#Object.rBdFluxB"
    datatype: float
    description: Integrated flux of the de Vaucouleurs component for the Bulge+Disk
      model. For r filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: rBdFluxBErr
    "@id": "#Object.rBdFluxBErr"
    datatype: float
    description: Uncertainty of rBdFluxB.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: rBdFluxD
    "@id": "#Object.rBdFluxD"
    datatype: float
    description: Integrated flux of the exponential component for the Bulge+Disk model.
      For r filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: rBdFluxDErr
    "@id": "#Object.rBdFluxDErr"
    datatype: float
    description: Uncertainty of rBdFluxD.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: rBdReB
    "@id": "#Object.rBdReB"
    datatype: float
    description: Effective radius of the de Vaucouleurs profile component for the
      Bulge+Disk model. For r filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rBdReBErr
    "@id": "#Object.rBdReBErr"
    datatype: float
    description: Uncertainty of rBdReB.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rBdReD
    "@id": "#Object.rBdReD"
    datatype: float
    description: Effective radius of the exponential profile component for the Bulge+Disk
      model. For r filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rBdReDErr
    "@id": "#Object.rBdReDErr"
    datatype: float
    description: Uncertainty of rBdReD.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rBdLnL
    "@id": "#Object.rBdLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the Bulge+Disk
      model. For r filter.
    mysql:datatype: FLOAT
  - name: rBdChi2
    "@id": "#Object.rBdChi2"
    datatype: float
    description: Chi^2 static of the model fit. For r filter.
    mysql:datatype: FLOAT
  - name: rBdN
    "@id": "#Object.rBdN"
    datatype: int
    description: The number of data points (pixels) used to fit the model. For r filter.
    mysql:datatype: INT
  - name: iBbdRa
    "@id": "#Object.iBbdRa"
    datatype: double
    description: RA-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For i filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: iBdRaErr
    "@id": "#Object.iBdRaErr"
    datatype: float
    description: Uncertainty of iBdRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: iBdDecl
    "@id": "#Object.iBdDecl"
    datatype: double
    description: Decl-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For i filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: iBdDeclErr
    "@id": "#Object.iBdDeclErr"
    datatype: float
    description: Uncertainty of iBdDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: iBdE1
    "@id": "#Object.iBdE1"
    datatype: float
    description: Ellipticity for the Bulge+Disk (e1). For i filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: iBdE1Err
    "@id": "#Object.iBdE1Err"
    datatype: float
    description: Uncertainty of iBdE1.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: iBdE2
    "@id": "#Object.iBdE2"
    datatype: float
    description: Ellipticity for Bulge+Disk model (e2). For i filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: iBdE2Err
    "@id": "#Object.iBdE2Err"
    datatype: float
    description: Uncertainty of iBdE2.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: iBdFluxB
    "@id": "#Object.iBdFluxB"
    datatype: float
    description: Integrated flux of the de Vaucouleurs component for the Bulge+Disk
      model. For i filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: iBdFluxBErr
    "@id": "#Object.iBdFluxBErr"
    datatype: float
    description: Uncertainty of iBdFluxB.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: iBdFluxD
    "@id": "#Object.iBdFluxD"
    datatype: float
    description: Integrated flux of the exponential component for the Bulge+Disk model.
      For i filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: iBdFluxDErr
    "@id": "#Object.iBdFluxDErr"
    datatype: float
    description: Uncertainty of iBdFluxD.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: iBdReB
    "@id": "#Object.iBdReB"
    datatype: float
    description: Effective radius of the de Vaucouleurs profile component for the
      Bulge+Disk model. For i filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iBdReBErr
    "@id": "#Object.iBdReBErr"
    datatype: float
    description: Uncertainty of iBdReB.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iBdReD
    "@id": "#Object.iBdReD"
    datatype: float
    description: Effective radius of the exponential profile component for the Bulge+Disk
      model. For i filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iBdReDErr
    "@id": "#Object.iBdReDErr"
    datatype: float
    description: Uncertainty of iBdReD.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iBdLnL
    "@id": "#Object.iBdLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the Bulge+Disk
      model. For i filter.
    mysql:datatype: FLOAT
  - name: iBdChi2
    "@id": "#Object.iBdChi2"
    datatype: float
    description: Chi^2 static of the model fit. For i filter.
    mysql:datatype: FLOAT
  - name: iBdN
    "@id": "#Object.iBdN"
    datatype: int
    description: The number of data points (pixels) used to fit the model. For i filter.
    mysql:datatype: INT
  - name: zBbdRa
    "@id": "#Object.zBbdRa"
    datatype: double
    description: RA-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For z filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: zBdRaErr
    "@id": "#Object.zBdRaErr"
    datatype: float
    description: Uncertainty of zBdRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: zBdDecl
    "@id": "#Object.zBdDecl"
    datatype: double
    description: Decl-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For z filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: zBdDeclErr
    "@id": "#Object.zBdDeclErr"
    datatype: float
    description: Uncertainty of zBdDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: zBdE1
    "@id": "#Object.zBdE1"
    datatype: float
    description: Ellipticity for the Bulge+Disk (e1). For z filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: zBdE1Err
    "@id": "#Object.zBdE1Err"
    datatype: float
    description: Uncertainty of zBdE1.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: zBdE2
    "@id": "#Object.zBdE2"
    datatype: float
    description: Ellipticity for Bulge+Disk model (e2). For z filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: zBdE2Err
    "@id": "#Object.zBdE2Err"
    datatype: float
    description: Uncertainty of zBdE2.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: zBdFluxB
    "@id": "#Object.zBdFluxB"
    datatype: float
    description: Integrated flux of the de Vaucouleurs component for the Bulge+Disk
      model. For z filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: zBdFluxBErr
    "@id": "#Object.zBdFluxBErr"
    datatype: float
    description: Uncertainty of zBdFluxB.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: zBdFluxD
    "@id": "#Object.zBdFluxD"
    datatype: float
    description: Integrated flux of the exponential component for the Bulge+Disk model.
      For z filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: zBdFluxDErr
    "@id": "#Object.zBdFluxDErr"
    datatype: float
    description: Uncertainty of zBdFluxD.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: zBdReB
    "@id": "#Object.zBdReB"
    datatype: float
    description: Effective radius of the de Vaucouleurs profile component for the
      Bulge+Disk model. For z filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zBdReBErr
    "@id": "#Object.zBdReBErr"
    datatype: float
    description: Uncertainty of zBdReB.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zBdReD
    "@id": "#Object.zBdReD"
    datatype: float
    description: Effective radius of the exponential profile component for the Bulge+Disk
      model. For z filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zBdReDErr
    "@id": "#Object.zBdReDErr"
    datatype: float
    description: Uncertainty of zBdReD.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zBdLnL
    "@id": "#Object.zBdLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the Bulge+Disk
      model. For z filter.
    mysql:datatype: FLOAT
  - name: zBdChi2
    "@id": "#Object.zBdChi2"
    datatype: float
    description: Chi^2 static of the model fit. For z filter.
    mysql:datatype: FLOAT
  - name: zBdN
    "@id": "#Object.zBdN"
    datatype: int
    description: The number of data points (pixels) used to fit the model. For z filter.
    mysql:datatype: INT
  - name: yBbdRa
    "@id": "#Object.yBbdRa"
    datatype: double
    description: RA-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For y filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: yBdRaErr
    "@id": "#Object.yBdRaErr"
    datatype: float
    description: Uncertainty of yBdRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: yBdDecl
    "@id": "#Object.yBdDecl"
    datatype: double
    description: Decl-coordinate of the center of the object for the Bulge+Disk model
      at time radecTai. For y filter.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: yBdDeclErr
    "@id": "#Object.yBdDeclErr"
    datatype: float
    description: Uncertainty of yBdDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: yBdE1
    "@id": "#Object.yBdE1"
    datatype: float
    description: Ellipticity for the Bulge+Disk (e1). For y filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: yBdE1Err
    "@id": "#Object.yBdE1Err"
    datatype: float
    description: Uncertainty of yBdE1.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: yBdE2
    "@id": "#Object.yBdE2"
    datatype: float
    description: Ellipticity for Bulge+Disk model (e2). For y filter.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: yBdE2Err
    "@id": "#Object.yBdE2Err"
    datatype: float
    description: Uncertainty of yBdE2.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: yBdFluxB
    "@id": "#Object.yBdFluxB"
    datatype: float
    description: Integrated flux of the de Vaucouleurs component for the Bulge+Disk
      model. For y filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: yBdFluxBErr
    "@id": "#Object.yBdFluxBErr"
    datatype: float
    description: Uncertainty of yBdFluxB.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: yBdFluxD
    "@id": "#Object.yBdFluxD"
    datatype: float
    description: Integrated flux of the exponential component for the Bulge+Disk model.
      For y filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: yBdFluxDErr
    "@id": "#Object.yBdFluxDErr"
    datatype: float
    description: Uncertainty of yBdFluxD.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: yBdReB
    "@id": "#Object.yBdReB"
    datatype: float
    description: Effective radius of the de Vaucouleurs profile component for the
      Bulge+Disk model. For y filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yBdReBErr
    "@id": "#Object.yBdReBErr"
    datatype: float
    description: Uncertainty of yBdReB.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yBdReD
    "@id": "#Object.yBdReD"
    datatype: float
    description: Effective radius of the exponential profile component for the Bulge+Disk
      model. For y filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yBdReDErr
    "@id": "#Object.yBdReDErr"
    datatype: float
    description: Uncertainty of yBdReD.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yBdLnL
    "@id": "#Object.yBdLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the Bulge+Disk
      model. For y filter.
    mysql:datatype: FLOAT
  - name: yBdChi2
    "@id": "#Object.yBdChi2"
    datatype: float
    description: Chi^2 static of the model fit. For y filter.
    mysql:datatype: FLOAT
  - name: yBdN
    "@id": "#Object.yBdN"
    datatype: int
    description: The number of data points (pixels) used to fit the model. For y filter.
    mysql:datatype: INT
  - name: ugStd
    "@id": "#Object.ugStd"
    datatype: float
    description: Color of the object measured in 'standard seeing'. While the exact
      algorithm is yet to be determined, this color is guaranteed to be seeing-independent
      and suitable for photo-Z determinations.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: ugStdErr
    "@id": "#Object.ugStdErr"
    datatype: float
    description: Uncertainty of ugStd.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: grStd
    "@id": "#Object.grStd"
    datatype: float
    description: Color of the object measured in 'standard seeing'. While the exact
      algorithm is yet to be determined, this color is guaranteed to be seeing-independent
      and suitable for photo-Z determinations.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: grStdErr
    "@id": "#Object.grStdErr"
    datatype: float
    description: Uncertainty of grStd.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: riStd
    "@id": "#Object.riStd"
    datatype: float
    description: Color of the object measured in 'standard seeing'. While the exact
      algorithm is yet to be determined, this color is is guaranteed to be seeing-independent
      and suitable for photo-Z determinations.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: riStdErr
    "@id": "#Object.riStdErr"
    datatype: float
    description: Uncertainty of riStd.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: izStd
    "@id": "#Object.izStd"
    datatype: float
    description: Color of the object measured in 'standard seeing'. While the exact
      algorithm is yet to be determined, this color is guaranteed to be seeing-independent
      and suitable for photo-Z determinations.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: izStdErr
    "@id": "#Object.izStdErr"
    datatype: float
    description: Uncertainty of izStd.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: zyStd
    "@id": "#Object.zyStd"
    datatype: float
    description: Color of the object measured in 'standard seeing'. While the exact
      algorithm is yet to be determined, this color is guaranteed to be seeing-independent
      and suitable for photo-Z determinations.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: zyStdErr
    "@id": "#Object.zyStdErr"
    datatype: float
    description: Uncertainty of zyStd.
    mysql:datatype: FLOAT
    fits:tunit: mag
  - name: uRa
    "@id": "#Object.uRa"
    datatype: double
    description: RA-coordinate coordinate of the centroid computed for u filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.ra
  - name: uRaErr
    "@id": "#Object.uRaErr"
    datatype: double
    description: Uncertainty of uRa.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.ra
  - name: uDecl
    "@id": "#Object.uDecl"
    datatype: double
    description: Decl-coordinate coordinate of the centroid computed for u filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.dec
  - name: uDeclErr
    "@id": "#Object.uDeclErr"
    datatype: double
    description: Uncertainty of uDecl.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.dec
  - name: gRa
    "@id": "#Object.gRa"
    datatype: double
    description: RA--coordinate coordinate of the centroid computed for g filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.ra
  - name: gRaErr
    "@id": "#Object.gRaErr"
    datatype: double
    description: Uncertainty of gRa.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.ra
  - name: gDecl
    "@id": "#Object.gDecl"
    datatype: double
    description: Decl--coordinate coordinate of the centroid computed for g filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.dec
  - name: gDeclErr
    "@id": "#Object.gDeclErr"
    datatype: double
    description: Uncertainty of gDecl.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.dec
  - name: rRa
    "@id": "#Object.rRa"
    datatype: double
    description: RA-coordinate coordinate of the centroid computed for r filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.ra
  - name: rRaErr
    "@id": "#Object.rRaErr"
    datatype: double
    description: Uncertainty of rRa.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.ra
  - name: rDecl
    "@id": "#Object.rDecl"
    datatype: double
    description: Decl-coordinate coordinate of the centroid computed for r filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.dec
  - name: rDeclErr
    "@id": "#Object.rDeclErr"
    datatype: double
    description: Uncertainty of rDecl.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.dec
  - name: iRa
    "@id": "#Object.iRa"
    datatype: double
    description: RA-coordinate coordinate of the centroid computed for i filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.ra
  - name: iRaErr
    "@id": "#Object.iRaErr"
    datatype: double
    description: Uncertainty of iRa.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.ra
  - name: iDecl
    "@id": "#Object.iDecl"
    datatype: double
    description: Decl-coordinate coordinate of the centroid computed for i filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.dec
  - name: iDeclErr
    "@id": "#Object.iDeclErr"
    datatype: double
    description: Uncertainty of iDecl.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.dec
  - name: zRa
    "@id": "#Object.zRa"
    datatype: double
    description: RA-coordinate coordinate of the centroid computed for z filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.ra
  - name: zRaErr
    "@id": "#Object.zRaErr"
    datatype: double
    description: Uncertainty of zRa.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.ra
  - name: zDecl
    "@id": "#Object.zDecl"
    datatype: double
    description: Decl-coordinate coordinate of the centroid computed for z filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.dec
  - name: zDeclErr
    "@id": "#Object.zDeclErr"
    datatype: double
    description: Uncertainty of zDecl.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.dec
  - name: yRa
    "@id": "#Object.yRa"
    datatype: double
    description: RA-coordinate coordinate of the centroid computed for y filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.ra
  - name: yRaErr
    "@id": "#Object.yRaErr"
    datatype: double
    description: Uncertainty of yRa.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.ra
  - name: yDecl
    "@id": "#Object.yDecl"
    datatype: double
    description: Decl-coordinate coordinate of the centroid computed for y filter.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.dec
  - name: yDeclErr
    "@id": "#Object.yDeclErr"
    datatype: double
    description: Uncertainty of yDecl.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.dec
  - name: uE1
    "@id": "#Object.uE1"
    datatype: float
    description: Adaptive e1 shape measure for u filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: uE1Err
    "@id": "#Object.uE1Err"
    datatype: float
    description: Uncertainty of uE1
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: uE2
    "@id": "#Object.uE2"
    datatype: float
    description: Adaptive e2 shape measure for u filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: uE2Err
    "@id": "#Object.uE2Err"
    datatype: float
    description: Uncertainty of uE2
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: uE1_E2_Cov
    "@id": "#Object.uE1_E2_Cov"
    datatype: float
    description: Covariance of uE1 and uE2.
    mysql:datatype: FLOAT
  - name: gE1
    "@id": "#Object.gE1"
    datatype: float
    description: Adaptive e1 shape measure for g filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: gE1Err
    "@id": "#Object.gE1Err"
    datatype: float
    description: Uncertainty of gE1
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: gE2
    "@id": "#Object.gE2"
    datatype: float
    description: Adaptive e2 shape measure for g filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: gE2Err
    "@id": "#Object.gE2Err"
    datatype: float
    description: Uncertainty of gE2
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: gE1_E2_Cov
    "@id": "#Object.gE1_E2_Cov"
    datatype: float
    description: Covariance of gE1 and gE2.
    mysql:datatype: FLOAT
  - name: rE1
    "@id": "#Object.rE1"
    datatype: float
    description: Adaptive e1 shape measure for r filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: rE1Err
    "@id": "#Object.rE1Err"
    datatype: float
    description: Uncertainty of rE1
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: rE2
    "@id": "#Object.rE2"
    datatype: float
    description: Adaptive e2 shape measure for r filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: rE2Err
    "@id": "#Object.rE2Err"
    datatype: float
    description: Uncertainty of rE2
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: rE1_E2_Cov
    "@id": "#Object.rE1_E2_Cov"
    datatype: float
    description: Covariance of rE1 and rE2.
    mysql:datatype: FLOAT
  - name: iE1
    "@id": "#Object.iE1"
    datatype: float
    description: Adaptive e1 shape measure for i filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: iE1Err
    "@id": "#Object.iE1Err"
    datatype: float
    description: Uncertainty of iE1
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: iE2
    "@id": "#Object.iE2"
    datatype: float
    description: Adaptive e2 shape measure for i filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: iE2Err
    "@id": "#Object.iE2Err"
    datatype: float
    description: Uncertainty of iE2
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: iE1_E2_Cov
    "@id": "#Object.iE1_E2_Cov"
    datatype: float
    description: Covariance of iE1 and iE2.
    mysql:datatype: FLOAT
  - name: zE1
    "@id": "#Object.zE1"
    datatype: float
    description: Adaptive e1 shape measure for z filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: zE1Err
    "@id": "#Object.zE1Err"
    datatype: float
    description: Uncertainty of zE1
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: zE2
    "@id": "#Object.zE2"
    datatype: float
    description: Adaptive e2 shape measure for z filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: zE2Err
    "@id": "#Object.zE2Err"
    datatype: float
    description: Uncertainty of zE2
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: zE1_E2_Cov
    "@id": "#Object.zE1_E2_Cov"
    datatype: float
    description: Covariance of zE1 and zE2.
    mysql:datatype: FLOAT
  - name: yE1
    "@id": "#Object.yE1"
    datatype: float
    description: Adaptive e1 shape measure for y filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: yE1Err
    "@id": "#Object.yE1Err"
    datatype: float
    description: Uncertainty of yE1
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: yE2
    "@id": "#Object.yE2"
    datatype: float
    description: Adaptive e2 shape measure for y filter. See Bernstein and Jarvis
      (2002) for detailed discussion of all adaptive-moment related quantities.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: yE2Err
    "@id": "#Object.yE2Err"
    datatype: float
    description: Uncertainty of yE2
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error;phys.size.axisRatio
  - name: yE1_E2_Cov
    "@id": "#Object.yE1_E2_Cov"
    datatype: float
    description: Covariance of yE1 and yE2.
    mysql:datatype: FLOAT
  - name: uMSum
    "@id": "#Object.uMSum"
    datatype: float
    description: Sum of second adaptive moments for u filter.
    mysql:datatype: FLOAT
  - name: uMSumErr
    "@id": "#Object.uMSumErr"
    datatype: float
    description: Uncertainty of uMSum
    mysql:datatype: FLOAT
  - name: gMSum
    "@id": "#Object.gMSum"
    datatype: float
    description: Sum of second adaptive moments for g filter.
    mysql:datatype: FLOAT
  - name: gMSumErr
    "@id": "#Object.gMSumErr"
    datatype: float
    description: Uncertainty of gMSum
    mysql:datatype: FLOAT
  - name: rMSum
    "@id": "#Object.rMSum"
    datatype: float
    description: Sum of second adaptive moments for r filter.
    mysql:datatype: FLOAT
  - name: rMSumErr
    "@id": "#Object.rMSumErr"
    datatype: float
    description: Uncertainty of rMSum
    mysql:datatype: FLOAT
  - name: iMSum
    "@id": "#Object.iMSum"
    datatype: float
    description: Sum of second adaptive moments for i filter.
    mysql:datatype: FLOAT
  - name: iMSumErr
    "@id": "#Object.iMSumErr"
    datatype: float
    description: Uncertainty of iMSum
    mysql:datatype: FLOAT
  - name: zMSum
    "@id": "#Object.zMSum"
    datatype: float
    description: Sum of second adaptive moments for z filter.
    mysql:datatype: FLOAT
  - name: zMSumErr
    "@id": "#Object.zMSumErr"
    datatype: float
    description: Uncertainty of zMSum
    mysql:datatype: FLOAT
  - name: yMSum
    "@id": "#Object.yMSum"
    datatype: float
    description: Sum of second adaptive moments for y filter.
    mysql:datatype: FLOAT
  - name: yMSumErr
    "@id": "#Object.yMSumErr"
    datatype: float
    description: Uncertainty of yMSum
    mysql:datatype: FLOAT
  - name: uM4
    "@id": "#Object.uM4"
    datatype: float
    description: Fourth order adaptive moment for u filter.
    mysql:datatype: FLOAT
  - name: gM4
    "@id": "#Object.gM4"
    datatype: float
    description: Fourth order adaptive moment for g filter.
    mysql:datatype: FLOAT
  - name: rM4
    "@id": "#Object.rM4"
    datatype: float
    description: Fourth order adaptive moment for r filter.
    mysql:datatype: FLOAT
  - name: iM4
    "@id": "#Object.iM4"
    datatype: float
    description: Fourth order adaptive moment for i filter.
    mysql:datatype: FLOAT
  - name: zM4
    "@id": "#Object.zM4"
    datatype: float
    description: Fourth order adaptive moment for z filter.
    mysql:datatype: FLOAT
  - name: yM4
    "@id": "#Object.yM4"
    datatype: float
    description: Fourth order adaptive moment for y filter.
    mysql:datatype: FLOAT
  - name: uPetroRad
    "@id": "#Object.uPetroRad"
    datatype: float
    description: Petrosian radius, computed using elliptical apertures defined by
      the adaptive moments for u filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uPetroRadErr
    "@id": "#Object.uPetroRadErr"
    datatype: float
    description: Uncertainty of uPetroRad
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gPetroRad
    "@id": "#Object.gPetroRad"
    datatype: float
    description: Petrosian radius, computed using elliptical apertures defined by
      the adaptive moments for g filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gPetroRadErr
    "@id": "#Object.gPetroRadErr"
    datatype: float
    description: Uncertainty of gPetroRad
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rPetroRad
    "@id": "#Object.rPetroRad"
    datatype: float
    description: Petrosian radius, computed using elliptical apertures defined by
      the adaptive moments for r filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rPetroRadErr
    "@id": "#Object.rPetroRadErr"
    datatype: float
    description: Uncertainty of rPetroRad
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iPetroRad
    "@id": "#Object.iPetroRad"
    datatype: float
    description: Petrosian radius, computed using elliptical apertures defined by
      the adaptive moments for i filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iPetroRadErr
    "@id": "#Object.iPetroRadErr"
    datatype: float
    description: Uncertainty of iPetroRad
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zPetroRad
    "@id": "#Object.zPetroRad"
    datatype: float
    description: Petrosian radius, computed using elliptical apertures defined by
      the adaptive moments for z filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zPetroRadErr
    "@id": "#Object.zPetroRadErr"
    datatype: float
    description: Uncertainty of zPetroRad
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yPetroRad
    "@id": "#Object.yPetroRad"
    datatype: float
    description: Petrosian radius, computed using elliptical apertures defined by
      the adaptive moments for y filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yPetroRadErr
    "@id": "#Object.yPetroRadErr"
    datatype: float
    description: Uncertainty of yPetroRad
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: petroFilter
    "@id": "#Object.petroFilter"
    datatype: char
    description: Name of the filter of the canonical petroRad.
    length: 1
    mysql:datatype: CHAR(1)
  - name: uPetroFlux
    "@id": "#Object.uPetroFlux"
    datatype: float
    description: Petrosian flux within a defined multiple of the canonical petroRad
      for u filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: uPetroFluxErr
    "@id": "#Object.uPetroFluxErr"
    datatype: float
    description: Uncertainty of uPetroFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: gPetroFlux
    "@id": "#Object.gPetroFlux"
    datatype: float
    description: Petrosian flux within a defined multiple of the canonical petroRad
      for g filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: gPetroFluxErr
    "@id": "#Object.gPetroFluxErr"
    datatype: float
    description: Uncertainty of gPetroFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: rPetroFlux
    "@id": "#Object.rPetroFlux"
    datatype: float
    description: Petrosian flux within a defined multiple of the canonical petroRad
      for r filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: rPetroFluxErr
    "@id": "#Object.rPetroFluxErr"
    datatype: float
    description: Uncertainty of rPetroFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: iPetroFlux
    "@id": "#Object.iPetroFlux"
    datatype: float
    description: Petrosian flux within a defined multiple of the canonical petroRad
      for i filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: iPetroFluxErr
    "@id": "#Object.iPetroFluxErr"
    datatype: float
    description: Uncertainty of iPetroFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: zPetroFlux
    "@id": "#Object.zPetroFlux"
    datatype: float
    description: Petrosian flux within a defined multiple of the canonical petroRad
      for z filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: zPetroFluxErr
    "@id": "#Object.zPetroFluxErr"
    datatype: float
    description: Uncertainty of zPetroFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: yPetroFlux
    "@id": "#Object.yPetroFlux"
    datatype: float
    description: Petrosian flux within a defined multiple of the canonical petroRad
      for y filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: yPetroFluxErr
    "@id": "#Object.yPetroFluxErr"
    datatype: float
    description: Uncertainty of yPetroFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: uPetroRad50
    "@id": "#Object.uPetroRad50"
    datatype: float
    description: Radius containing 50% of Petrosian flux for u filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uPetroRad50Err
    "@id": "#Object.uPetroRad50Err"
    datatype: float
    description: Uncertainty of uPetroRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gPetroRad50
    "@id": "#Object.gPetroRad50"
    datatype: float
    description: Radius containing 50% of Petrosian flux for g filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gPetroRad50Err
    "@id": "#Object.gPetroRad50Err"
    datatype: float
    description: Uncertainty of gPetroRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rPetroRad50
    "@id": "#Object.rPetroRad50"
    datatype: float
    description: Radius containing 50% of Petrosian flux for r filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rPetroRad50Err
    "@id": "#Object.rPetroRad50Err"
    datatype: float
    description: Uncertainty of rPetroRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iPetroRad50
    "@id": "#Object.iPetroRad50"
    datatype: float
    description: Radius containing 50% of Petrosian flux for i filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iPetroRad50Err
    "@id": "#Object.iPetroRad50Err"
    datatype: float
    description: Uncertainty of iPetroRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zPetroRad50
    "@id": "#Object.zPetroRad50"
    datatype: float
    description: Radius containing 50% of Petrosian flux for z filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zPetroRad50Err
    "@id": "#Object.zPetroRad50Err"
    datatype: float
    description: Uncertainty of zPetroRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yPetroRad50
    "@id": "#Object.yPetroRad50"
    datatype: float
    description: Radius containing 50% of Petrosian flux for y filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yPetroRad50Err
    "@id": "#Object.yPetroRad50Err"
    datatype: float
    description: Uncertainty of yPetroRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uPetroRad90
    "@id": "#Object.uPetroRad90"
    datatype: float
    description: Radius containing 90% of Petrosian flux for u filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uPetroRad90Err
    "@id": "#Object.uPetroRad90Err"
    datatype: float
    description: Uncertainty of uPetroRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gPetroRad90
    "@id": "#Object.gPetroRad90"
    datatype: float
    description: Radius containing 90% of Petrosian flux for g filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gPetroRad90Err
    "@id": "#Object.gPetroRad90Err"
    datatype: float
    description: Uncertainty of gPetroRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rPetroRad90
    "@id": "#Object.rPetroRad90"
    datatype: float
    description: Radius containing 90% of Petrosian flux for r filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rPetroRad90Err
    "@id": "#Object.rPetroRad90Err"
    datatype: float
    description: Uncertainty of rPetroRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iPetroRad90
    "@id": "#Object.iPetroRad90"
    datatype: float
    description: Radius containing 90% of Petrosian flux for i filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iPetroRad90Err
    "@id": "#Object.iPetroRad90Err"
    datatype: float
    description: Uncertainty of iPetroRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zPetroRad90
    "@id": "#Object.zPetroRad90"
    datatype: float
    description: Radius containing 90% of Petrosian flux for z filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zPetroRad90Err
    "@id": "#Object.zPetroRad90Err"
    datatype: float
    description: Uncertainty of zPetroRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yPetroRad90
    "@id": "#Object.yPetroRad90"
    datatype: float
    description: Radius containing 90% of Petrosian flux for y filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yPetroRad90Err
    "@id": "#Object.yPetroRad90Err"
    datatype: float
    description: Uncertainty of yPetroRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uKronRad
    "@id": "#Object.uKronRad"
    datatype: float
    description: Kron radius (computed using elliptical apertures defined by the adaptive
      moments) for u filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uKronRadErr
    "@id": "#Object.uKronRadErr"
    datatype: float
    description: Uncertainty of uKronRad.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gKronRad
    "@id": "#Object.gKronRad"
    datatype: float
    description: Kron radius (computed using elliptical apertures defined by the adaptive
      moments) for g filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gKronRadErr
    "@id": "#Object.gKronRadErr"
    datatype: float
    description: Uncertainty of gKronRad.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rKronRad
    "@id": "#Object.rKronRad"
    datatype: float
    description: Kron radius (computed using elliptical apertures defined by the adaptive
      moments) for r filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rKronRadErr
    "@id": "#Object.rKronRadErr"
    datatype: float
    description: Uncertainty of rKronRad.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iKronRad
    "@id": "#Object.iKronRad"
    datatype: float
    description: Kron radius (computed using elliptical apertures defined by the adaptive
      moments) for i filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iKronRadErr
    "@id": "#Object.iKronRadErr"
    datatype: float
    description: Uncertainty of iKronRad.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zKronRad
    "@id": "#Object.zKronRad"
    datatype: float
    description: Kron radius (computed using elliptical apertures defined by the adaptive
      moments) for z filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zKronRadErr
    "@id": "#Object.zKronRadErr"
    datatype: float
    description: Uncertainty of zKronRad.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yKronRad
    "@id": "#Object.yKronRad"
    datatype: float
    description: Kron radius (computed using elliptical apertures defined by the adaptive
      moments) for y filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yKronRadErr
    "@id": "#Object.yKronRadErr"
    datatype: float
    description: Uncertainty of yKronRad.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: kronFilter
    "@id": "#Object.kronFilter"
    datatype: char
    description: The filter of the canonical kronRad.
    length: 1
    mysql:datatype: CHAR(1)
  - name: uKronFlux
    "@id": "#Object.uKronFlux"
    datatype: float
    description: Kron flux within a defined multiple of the canonical kronRad for
      u filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: uKronFluxErr
    "@id": "#Object.uKronFluxErr"
    datatype: float
    description: Uncertainty of uKronFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: gKronFlux
    "@id": "#Object.gKronFlux"
    datatype: float
    description: Kron flux within a defined multiple of the canonical kronRad for
      g filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: gKronFluxErr
    "@id": "#Object.gKronFluxErr"
    datatype: float
    description: Uncertainty of gKronFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: rKronFlux
    "@id": "#Object.rKronFlux"
    datatype: float
    description: Kron flux within a defined multiple of the canonical kronRad for
      r filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: rKronFluxErr
    "@id": "#Object.rKronFluxErr"
    datatype: float
    description: Uncertainty of rKronFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: iKronFlux
    "@id": "#Object.iKronFlux"
    datatype: float
    description: Kron flux within a defined multiple of the canonical kronRad for
      i filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: iKronFluxErr
    "@id": "#Object.iKronFluxErr"
    datatype: float
    description: Uncertainty of iKronFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: zKronFlux
    "@id": "#Object.zKronFlux"
    datatype: float
    description: Kron flux within a defined multiple of the canonical kronRad for
      z filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: zKronFluxErr
    "@id": "#Object.zKronFluxErr"
    datatype: float
    description: Uncertainty of zKronFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: yKronFlux
    "@id": "#Object.yKronFlux"
    datatype: float
    description: Kron flux within a defined multiple of the canonical kronRad for
      y filter.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: yKronFluxErr
    "@id": "#Object.yKronFluxErr"
    datatype: float
    description: Uncertainty of yKronFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: uKronRad50
    "@id": "#Object.uKronRad50"
    datatype: float
    description: Radius containing 50% of Kron flux for u filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uKronRad50Err
    "@id": "#Object.uKronRad50Err"
    datatype: float
    description: Uncertainty of uKronRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gKronRad50
    "@id": "#Object.gKronRad50"
    datatype: float
    description: Radius containing 50% of Kron flux for g filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gKronRad50Err
    "@id": "#Object.gKronRad50Err"
    datatype: float
    description: Uncertainty of gKronRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rKronRad50
    "@id": "#Object.rKronRad50"
    datatype: float
    description: Radius containing 50% of Kron flux for r filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rKronRad50Err
    "@id": "#Object.rKronRad50Err"
    datatype: float
    description: Uncertainty of rKronRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iKronRad50
    "@id": "#Object.iKronRad50"
    datatype: float
    description: Radius containing 50% of Kron flux for i filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iKronRad50Err
    "@id": "#Object.iKronRad50Err"
    datatype: float
    description: Uncertainty of iKronRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zKronRad50
    "@id": "#Object.zKronRad50"
    datatype: float
    description: Radius containing 50% of Kron flux for z filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zKronRad50Err
    "@id": "#Object.zKronRad50Err"
    datatype: float
    description: Uncertainty of zKronRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yKronRad50
    "@id": "#Object.yKronRad50"
    datatype: float
    description: Radius containing 50% of Kron flux for y filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yKronRad50Err
    "@id": "#Object.yKronRad50Err"
    datatype: float
    description: Uncertainty of yKronRad50.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uKronRad90
    "@id": "#Object.uKronRad90"
    datatype: float
    description: Radius containing 90% of Kron flux for u filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uKronRad90Err
    "@id": "#Object.uKronRad90Err"
    datatype: float
    description: Uncertainty of uKronRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gKronRad90
    "@id": "#Object.gKronRad90"
    datatype: float
    description: Radius containing 90% of Kron flux for g filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: gKronRad90Err
    "@id": "#Object.gKronRad90Err"
    datatype: float
    description: Uncertainty of gKronRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rKronRad90
    "@id": "#Object.rKronRad90"
    datatype: float
    description: Radius containing 90% of Kron flux for r filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: rKronRad90Err
    "@id": "#Object.rKronRad90Err"
    datatype: float
    description: Uncertainty of rKronRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iKronRad90
    "@id": "#Object.iKronRad90"
    datatype: float
    description: Radius containing 90% of Kron flux for i filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: iKronRad90Err
    "@id": "#Object.iKronRad90Err"
    datatype: float
    description: Uncertainty of iKronRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zKronRad90
    "@id": "#Object.zKronRad90"
    datatype: float
    description: Radius containing 90% of Kron flux for z filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: zKronRad90Err
    "@id": "#Object.zKronRad90Err"
    datatype: float
    description: Uncertainty of zKronRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yKronRad90
    "@id": "#Object.yKronRad90"
    datatype: float
    description: Radius containing 90% of Kron flux for y filter.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: yKronRad90Err
    "@id": "#Object.yKronRad90Err"
    datatype: float
    description: Uncertainty of yKronRad90.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: uApN
    "@id": "#Object.uApN"
    datatype: byte
    description: Number of elliptical annuli (see below) for u filter.
    mysql:datatype: TINYINT
  - name: gApN
    "@id": "#Object.gApN"
    datatype: byte
    description: Number of elliptical annuli (see below) for g filter.
    mysql:datatype: TINYINT
  - name: rApN
    "@id": "#Object.rApN"
    datatype: byte
    description: Number of elliptical annuli (see below) for r filter.
    mysql:datatype: TINYINT
  - name: iApN
    "@id": "#Object.iApN"
    datatype: byte
    description: Number of elliptical annuli (see below) for i filter.
    mysql:datatype: TINYINT
  - name: zApN
    "@id": "#Object.zApN"
    datatype: byte
    description: Number of elliptical annuli (see below) for z filter.
    mysql:datatype: TINYINT
  - name: yApN
    "@id": "#Object.yApN"
    datatype: byte
    description: Number of elliptical annuli (see below) for y filter.
    mysql:datatype: TINYINT
  - name: extendedness
    "@id": "#Object.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.
    mysql:datatype: FLOAT
  - name: FLAGS1
    "@id": "#Object.FLAGS1"
    datatype: long
    description: Flags, tbd.
    mysql:datatype: BIGINT
  - name: FLAGS2
    "@id": "#Object.FLAGS2"
    datatype: long
    description: Flags, tbd.
    mysql:datatype: BIGINT
  primaryKey: "#Object.objectId"
  indexes:
  - name: IDX_Object_decl
    "@id": "#IDX_Object_decl"
    columns:
    - "#Object.psDecl"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: Object_Extra
  "@id": "#Object_Extra"
  description: Less frequently used information from The Object table.
  columns:
  - name: objectId
    "@id": "#Object_Extra.objectId"
    datatype: long
    description: Unique id.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: psCov
    "@id": "#Object_Extra.psCov"
    datatype: binary
    description: Various covariances for Point Source model. 66 TINYINTs.
    mysql:datatype: BLOB
  - name: bdCov
    "@id": "#Object_Extra.bdCov"
    datatype: binary
    description: Covariance matrix for the Bulge+Disk model. 168 TINYINTs. [((8x9/2)-8)*6].
    mysql:datatype: BLOB
  - name: bdSamples
    "@id": "#Object_Extra.bdSamples"
    datatype: binary
    description: Independent samples of Bulge+Disk likelihood surface. All sampled
      quantities will be stored with at lease ~3 significant digits of precision.
      The number of samples will vary from object to object, depending on how well
      the object’s likelihood function is approximated by a Gaussian. We are assuming
      on average [9x200x4 FLOAT16].
    mysql:datatype: BLOB
  - name: photoZ
    "@id": "#Object_Extra.photoZ"
    datatype: binary
    description: Photometric redshift likelihood samples (pairs of {z, logL}) computed
      using a to-be-determined published and widely accepted algorithm at the time
      of LSST Commissioning. [2x100 FLOAT].
    mysql:datatype: BLOB
  primaryKey: "#Object_Extra.objectId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: Object_APMean
  "@id": "#Object_APMean"
  description: Aperture mean (per bin) for the Object table. We expect ~8 bins on
    average per object.
  columns:
  - name: objectId
    "@id": "#Object_APMean.objectId"
    datatype: long
    description: Unique id.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: filterName
    "@id": "#Object_APMean.filterName"
    datatype: char
    description: Name of the filter.
    length: 1
    mysql:datatype: CHAR(1)
  - name: binN
    "@id": "#Object_APMean.binN"
    datatype: byte
    description: A bin in radius at which the aperture measurement is being performed.
    mysql:datatype: TINYINT
  - name: sbMean
    "@id": "#Object_APMean.sbMean"
    datatype: float
    description: Mean surface brightness at which the aperture measurement is being
      performed.
    mysql:datatype: FLOAT
    fits:tunit: nmgy/arcsec^2
  - name: sbSigma
    "@id": "#Object_APMean.sbSigma"
    datatype: float
    description: Standard deviation of pixel surface brightness in annulus.
    mysql:datatype: FLOAT
  indexes:
  - name: IDX_ObjectAPMean_objectId
    "@id": "#IDX_ObjectAPMean_objectId"
    columns:
    - "#Object_APMean.objectId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: Object_Periodic
  "@id": "#Object_Periodic"
  description: Definition of periodic features for Object table. We expect about 32
    per object.
  columns:
  - name: objectId
    "@id": "#Object_Periodic.objectId"
    datatype: long
    description: Unique id.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: filterName
    "@id": "#Object_Periodic.filterName"
    datatype: char
    description: Name of the filter.
    length: 1
    mysql:datatype: CHAR(1)
  - name: theFeature
    "@id": "#Object_Periodic.theFeature"
    datatype: byte
    description: Feature/metric identifier.
    mysql:datatype: TINYINT
  - name: theValue
    "@id": "#Object_Periodic.theValue"
    datatype: float
    description: Feature/metric value.
    mysql:datatype: FLOAT
  indexes:
  - name: IDX_ObjectPeriodic_objectId
    "@id": "#IDX_ObjectPeriodic_objectId"
    columns:
    - "#Object_Periodic.objectId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: Object_NonPeriodic
  "@id": "#Object_NonPeriodic"
  description: Definition of non-periodic features for Object table. We expect about
    20 per object.
  columns:
  - name: objectId
    "@id": "#Object_NonPeriodic.objectId"
    datatype: long
    description: Unique id.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: filterName
    "@id": "#Object_NonPeriodic.filterName"
    datatype: char
    description: Name of the filter.
    length: 1
    mysql:datatype: CHAR(1)
  - name: theFeature
    "@id": "#Object_NonPeriodic.theFeature"
    datatype: byte
    description: Feature/metric identifier.
    mysql:datatype: TINYINT
  - name: theValue
    "@id": "#Object_NonPeriodic.theValue"
    datatype: float
    description: Feature/metric value.
    mysql:datatype: FLOAT
  indexes:
  - name: IDX_ObjectNonPeriodic_objectId
    "@id": "#IDX_ObjectNonPeriodic_objectId"
    columns:
    - "#Object_NonPeriodic.objectId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: Source
  "@id": "#Source"
  description: Table to store high signal-to-noise &quot;sources&quot;. A source is
    a measurement of Object's properties from a single image that contains its footprint
    on the sky.
  columns:
  - name: sourceId
    "@id": "#Source.sourceId"
    datatype: long
    description: Unique id.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: ccdVisitId
    "@id": "#Source.ccdVisitId"
    datatype: long
    description: Id of the ccdVisit where this source was measured. Note that we are
      allowing a source to belong to multiple amplifiers, but it may not span multiple
      ccds.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: filterName
    "@id": "#Source.filterName"
    datatype: char
    description: Name of the filter used to take the two exposures where this source
      was measured.
    length: 1
    mysql:datatype: CHAR(1)
    ivoa:ucd: meta.id;instr.filter
  - name: objectId
    "@id": "#Source.objectId"
    datatype: long
    description: Id of the corresponding object. Note that this might be NULL (each
      source will point to either object or ssObject).
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: ssObjectId
    "@id": "#Source.ssObjectId"
    datatype: long
    description: Id of the corresponding ssObject. Note that this might be NULL (each
      source will point to either object or ssObject).
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: parentSourceId
    "@id": "#Source.parentSourceId"
    datatype: long
    description: Id of the parent source this source has been deblended from, if any.
    mysql:datatype: BIGINT
  - name: htmId20
    "@id": "#Source.htmId20"
    datatype: long
    description: HTM index.
    mysql:datatype: BIGINT
  - name: sky
    "@id": "#Source.sky"
    datatype: float
    description: Estimated sky background at the position (centroid) of the source.
    mysql:datatype: FLOAT
    fits:tunit: nmgy/asec^2
  - name: skyErr
    "@id": "#Source.skyErr"
    datatype: float
    description: Uncertainty of sky.
    mysql:datatype: FLOAT
    fits:tunit: nmgy/asec^2
  - name: psFlux
    "@id": "#Source.psFlux"
    datatype: float
    description: Calibrated flux for Point Source model.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: psFluxErr
    "@id": "#Source.psFluxErr"
    datatype: float
    description: Uncertainty of psFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
  - name: psX
    "@id": "#Source.psX"
    datatype: float
    description: Point source model (x) position of the object on the CCD.
    mysql:datatype: FLOAT
    fits:tunit: pixels
  - name: psXErr
    "@id": "#Source.psXErr"
    datatype: float
    description: Uncertainty of psX.
    mysql:datatype: FLOAT
    fits:tunit: pixels
  - name: psY
    "@id": "#Source.psY"
    datatype: float
    description: Point source model (y) position of the object on the CCD.
    mysql:datatype: FLOAT
  - name: psYErr
    "@id": "#Source.psYErr"
    datatype: float
    description: Uncertainty of psY.
    mysql:datatype: FLOAT
    fits:tunit: pixels
  - name: psFlux_psX_Cov
    "@id": "#Source.psFlux_psX_Cov"
    datatype: float
    description: Covariance of psFlux and psX.
    mysql:datatype: FLOAT
  - name: psFlux_psY_Cov
    "@id": "#Source.psFlux_psY_Cov"
    datatype: float
    description: Covariance of psFlux and psY.
    mysql:datatype: FLOAT
  - name: psX_Y_Cov
    "@id": "#Source.psX_Y_Cov"
    datatype: float
    description: Covariance of psX and psY.
    mysql:datatype: FLOAT
  - name: psLnL
    "@id": "#Source.psLnL"
    datatype: float
    description: Natural log likelihood of the observed data given the Point Source
      model.
    mysql:datatype: FLOAT
  - name: psChi2
    "@id": "#Source.psChi2"
    datatype: float
    description: Chi^2 static of the model fit.
    mysql:datatype: FLOAT
  - name: psN
    "@id": "#Source.psN"
    datatype: int
    description: The number of data points (pixels) used to fit the model.
    mysql:datatype: INT
  - name: psRa
    "@id": "#Source.psRa"
    datatype: double
    description: RA-coordinate of the center of the object for the Point Source model
      at time radecTai.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: psRaErr
    "@id": "#Source.psRaErr"
    datatype: float
    description: Uncertainty of psRa.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.ra
  - name: psDecl
    "@id": "#Source.psDecl"
    datatype: double
    description: Decl-coordinate of the center of the object for the Point Source
      model at time radecTai.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: psDeclErr
    "@id": "#Source.psDeclErr"
    datatype: float
    description: Uncertainty of psDecl.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: stat.error;pos.eq.dec
  - name: psFlux_psRa_Cov
    "@id": "#Source.psFlux_psRa_Cov"
    datatype: float
    description: Covariance of psFlux and psRa.
    mysql:datatype: FLOAT
  - name: psFlux_psDecl_Cov
    "@id": "#Source.psFlux_psDecl_Cov"
    datatype: float
    description: Covariance of psFlux and psRa.
    mysql:datatype: FLOAT
  - name: x
    "@id": "#Source.x"
    datatype: float
    description: x position computed using an algorithm similar to that used by SDSS.
    mysql:datatype: FLOAT
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.x
  - name: xErr
    "@id": "#Source.xErr"
    datatype: float
    description: Uncertainty of x.
    mysql:datatype: FLOAT
    fits:tunit: pixel
    ivoa:ucd: stat.error:pos.cartesian.x
  - name: y
    "@id": "#Source.y"
    datatype: float
    description: y position computed using an algorithm similar to that used by SDSS.
    mysql:datatype: FLOAT
    fits:tunit: pixel
    ivoa:ucd: pos.cartesian.y
  - name: yErr
    "@id": "#Source.yErr"
    datatype: float
    description: Uncertainty of y.
    mysql:datatype: FLOAT
    fits:tunit: pixel
    ivoa:ucd: stat.error:pos.cartesian.y
  - name: x_y_Cov
    "@id": "#Source.x_y_Cov"
    datatype: float
    description: Covariance between x and y.
    mysql:datatype: FLOAT
    fits:tunit: pixel^2
  - name: ra
    "@id": "#Source.ra"
    datatype: double
    description: Calibrated RA-coordinate of the center of the source transformed
      from xy.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.ra
  - name: raErr
    "@id": "#Source.raErr"
    datatype: float
    description: Uncertainty of ra.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.ra
  - name: decl
    "@id": "#Source.decl"
    datatype: double
    description: Calibated Decl-coordinate of the center of the source transformed
      from xy.
    mysql:datatype: DOUBLE
    fits:tunit: arcsec
    ivoa:ucd: pos.eq.dec
  - name: declErr
    "@id": "#Source.declErr"
    datatype: float
    description: Uncertainty of decl.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
    ivoa:ucd: stat.error;pos.eq.dec
  - name: ra_decl_Cov
    "@id": "#Source.ra_decl_Cov"
    datatype: float
    description: Covariance of ra and decl.
    mysql:datatype: FLOAT
    fits:tunit: arcsec^2
  - name: E1
    "@id": "#Source.E1"
    datatype: float
    description: Adaptive e1 shape measure of the source as measured on the difference
      image.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: E1Err
    "@id": "#Source.E1Err"
    datatype: float
    description: Uncertainty of E1.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error:phys.size.axisRatio
  - name: E2
    "@id": "#Source.E2"
    datatype: float
    description: Adaptive e2 shape measure of the source as measured on the difference
      image.
    mysql:datatype: FLOAT
    ivoa:ucd: phys.size.axisRatio
  - name: E2Err
    "@id": "#Source.E2Err"
    datatype: float
    description: Uncertainty of E2.
    mysql:datatype: FLOAT
    ivoa:ucd: stat.error:phys.size.axisRatio
  - name: E1_E2_Cov
    "@id": "#Source.E1_E2_Cov"
    datatype: float
    description: Covariance of E1 and E2
    mysql:datatype: FLOAT
  - name: mSum
    "@id": "#Source.mSum"
    datatype: float
    description: Sum of second adaptive moments.
    mysql:datatype: FLOAT
  - name: mSumErr
    "@id": "#Source.mSumErr"
    datatype: float
    description: Uncertainty of mSum.
    mysql:datatype: FLOAT
  - name: m4
    "@id": "#Source.m4"
    datatype: float
    description: Fourth order adaptive moment.
    mysql:datatype: FLOAT
  - name: apN
    "@id": "#Source.apN"
    datatype: byte
    description: Number of elliptical annuli.
    mysql:datatype: TINYINT
  - name: flags
    "@id": "#Source.flags"
    datatype: long
    description: Flags. Tbd.
    mysql:datatype: BIGINT
  primaryKey: "#Source.sourceId"
  indexes:
  - name: IDX_Source_ccdVisitId
    "@id": "#IDX_Source_ccdVisitId"
    columns:
    - "#Source.ccdVisitId"
  - name: IDX_Source_objectId
    "@id": "#IDX_Source_objectId"
    columns:
    - "#Source.objectId"
  - name: IDX_Source_ssObjectId
    "@id": "#IDX_Source_ssObjectId"
    columns:
    - "#Source.ssObjectId"
  - name: IDX_Source_htmId20
    "@id": "#IDX_Source_htmId20"
    columns:
    - "#Source.htmId20"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: Source_APMean
  "@id": "#Source_APMean"
  description: Aperture mean (per bin) for the Source table. We expect ~8 bins on
    average per source.
  columns:
  - name: sourceId
    "@id": "#Source_APMean.sourceId"
    datatype: long
    description: Unique id.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: binN
    "@id": "#Source_APMean.binN"
    datatype: byte
    description: A bin in radius at which the aperture measurement is being performed.
    mysql:datatype: TINYINT
  - name: sbMean
    "@id": "#Source_APMean.sbMean"
    datatype: float
    description: Mean surface brightness at which the aperture measurement is being
      performed.
    mysql:datatype: FLOAT
    fits:tunit: nmgy/arcsec^2
  - name: sbSigma
    "@id": "#Source_APMean.sbSigma"
    datatype: float
    description: Standard deviation of pixel surface brightness in annulus.
    mysql:datatype: FLOAT
  indexes:
  - name: IDX_SourceAPMean_sourceId
    "@id": "#IDX_SourceAPMean_sourceId"
    columns:
    - "#Source_APMean.sourceId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: ForcedSource
  "@id": "#ForcedSource"
  description: Forced-photometry source measurement on an individual Exposure based
    on a Multifit shape model derived from a deep detection.
  columns:
  - name: objectId
    "@id": "#ForcedSource.objectId"
    datatype: long
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: ccdVisitId
    "@id": "#ForcedSource.ccdVisitId"
    datatype: long
    description: Id of the ccd visit where this forcedSource was measured. Note that
      we are allowing a forcedSource to belong to multiple amplifiers, but it may
      not span multiple ccds.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: psFlux
    "@id": "#ForcedSource.psFlux"
    datatype: float
    description: Point Source model flux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: phot.count
  - name: psFlux_Err
    "@id": "#ForcedSource.psFlux_Err"
    datatype: float
    description: Uncertainty of psFlux.
    mysql:datatype: FLOAT
    fits:tunit: nmgy
    ivoa:ucd: stat.error;phot.count
  - name: flags
    "@id": "#ForcedSource.flags"
    datatype: byte
    description: Flags, bitwise OR tbd
    defaultValue: '0'
    mysql:datatype: TINYINT
    ivoa:ucd: meta.code
  primaryKey:
  - "#ForcedSource.objectId"
  - "#ForcedSource.ccdVisitId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: RawAmpExposure
  "@id": "#RawAmpExposure"
  description: Exposure for one amplifier (raw image).
  columns:
  - name: rawAmpExposureId
    "@id": "#RawAmpExposure.rawAmpExposureId"
    datatype: long
    description: Primary key (unique identifier).
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: rawCcdExposureId
    "@id": "#RawAmpExposure.rawCcdExposureId"
    datatype: long
    description: Pointer to RawCcdExposure containing this amp exposure.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: ampName
    "@id": "#RawAmpExposure.ampName"
    datatype: char
    description: Amplifier name.
    length: 3
    mysql:datatype: CHAR(3)
    ivoa:ucd: meta.id;instr.det
  - name: ccdName
    "@id": "#RawAmpExposure.ccdName"
    datatype: char
    description: Ccd name.
    length: 3
    mysql:datatype: CHAR(3)
    ivoa:ucd: meta.id;instr.det
  - name: raftName
    "@id": "#RawAmpExposure.raftName"
    datatype: char
    description: Raft name.
    length: 3
    mysql:datatype: CHAR(3)
    ivoa:ucd: meta.id;instr.det
  - name: filterName
    "@id": "#RawAmpExposure.filterName"
    datatype: char
    description: Filter name.
    length: 1
    mysql:datatype: CHAR(1)
    ivoa:ucd: meta.id;instr.filter
  - name: ra
    "@id": "#RawAmpExposure.ra"
    datatype: double
    description: Ra of amp center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: decl
    "@id": "#RawAmpExposure.decl"
    datatype: double
    description: Decl of amp center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: skyRotation
    "@id": "#RawAmpExposure.skyRotation"
    datatype: double
    description: Sky rotation angle.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: bias
    "@id": "#RawAmpExposure.bias"
    datatype: float
    description: Bias as measured from overscan columns.
    mysql:datatype: FLOAT
    fits:tunit: DN
  - name: biasNom
    "@id": "#RawAmpExposure.biasNom"
    datatype: float
    description: Preset bias.
    mysql:datatype: FLOAT
    fits:tunit: DN
  - name: gain
    "@id": "#RawAmpExposure.gain"
    datatype: float
    description: Measured gain value.
    mysql:datatype: FLOAT
    fits:tunit: electrons/DN
  - name: gainNom
    "@id": "#RawAmpExposure.gainNom"
    datatype: float
    description: Preset gain.
    mysql:datatype: FLOAT
    fits:tunit: DN
  - name: rdNoise
    "@id": "#RawAmpExposure.rdNoise"
    datatype: float
    description: Read noise for detector/amplifier.
    mysql:datatype: FLOAT
    fits:tunit: DN
  - name: saturation
    "@id": "#RawAmpExposure.saturation"
    datatype: int
    description: Maximum data value for A/D converter.
    mysql:datatype: INTEGER
    fits:tunit: DN
  - name: llcx
    "@id": "#RawAmpExposure.llcx"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: llcy
    "@id": "#RawAmpExposure.llcy"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: ulcx
    "@id": "#RawAmpExposure.ulcx"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5+NAXIS2).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: ulcy
    "@id": "#RawAmpExposure.ulcy"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5+NAXIS2).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: urcx
    "@id": "#RawAmpExposure.urcx"
    datatype: int
    description: FITS pixel coordinates (0.5+NAXIS1, 0.5+NAXIS2).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: urcy
    "@id": "#RawAmpExposure.urcy"
    datatype: int
    description: FITS pixel coordinates (0.5+NAXIS1, 0.5+NAXIS2).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: lrcx
    "@id": "#RawAmpExposure.lrcx"
    datatype: int
    description: FITS pixel coordinates (0.5+NAXIS1, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: lrcy
    "@id": "#RawAmpExposure.lrcy"
    datatype: int
    description: FITS pixel coordinates (0.5+NAXIS1, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: xSize
    "@id": "#RawAmpExposure.xSize"
    datatype: int
    description: Number of columns in the image.
    mysql:datatype: INTEGER
  - name: ySize
    "@id": "#RawAmpExposure.ySize"
    datatype: int
    description: Number of rows in the image.
    mysql:datatype: INTEGER
  - name: obsStart
    "@id": "#RawAmpExposure.obsStart"
    datatype: timestamp
    description: Start of the exposure, TAI, accurate to 10ms.
    defaultValue: CURRENT_TIMESTAMP
    mysql:datatype: TIMESTAMP
    ivoa:ucd: time.start
  - name: expMidpt
    "@id": "#RawAmpExposure.expMidpt"
    datatype: double
    description: Midpoint for exposure. TAI, accurate to 10ms.
    mysql:datatype: DOUBLE
    ivoa:ucd: time.epoch
  - name: expTime
    "@id": "#RawAmpExposure.expTime"
    datatype: double
    description: Duration of exposure, accurate to 10ms.
    mysql:datatype: DOUBLE
    fits:tunit: s
    ivoa:ucd: time.duration
  - name: darkTime
    "@id": "#RawAmpExposure.darkTime"
    datatype: double
    description: Dark current accumulation time, accurate to 10ms.
    mysql:datatype: DOUBLE
    fits:tunit: s
    ivoa:ucd: time.duration
  - name: flags
    "@id": "#RawAmpExposure.flags"
    datatype: int
    defaultValue: '0'
    mysql:datatype: INTEGER
    ivoa:ucd: meta.code
  primaryKey: "#RawAmpExposure.rawAmpExposureId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: RawAmpExposureMetadata
  "@id": "#RawAmpExposureMetadata"
  description: Generic key-value pair metadata for RawAmpExposure.
  columns:
  - name: rawAmpExposureId
    "@id": "#RawAmpExposureMetadata.rawAmpExposureId"
    datatype: long
    description: Id of the corresponding RawAmpExposure.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: metadataKey
    "@id": "#RawAmpExposureMetadata.metadataKey"
    datatype: string
    length: 255
    mysql:datatype: VARCHAR(255)
  - name: intValue
    "@id": "#RawAmpExposureMetadata.intValue"
    datatype: int
    mysql:datatype: INTEGER
  - name: doubleValue
    "@id": "#RawAmpExposureMetadata.doubleValue"
    datatype: double
    mysql:datatype: DOUBLE
  - name: stringValue
    "@id": "#RawAmpExposureMetadata.stringValue"
    datatype: string
    length: 255
    mysql:datatype: VARCHAR(255)
  primaryKey:
  - "#RawAmpExposureMetadata.rawAmpExposureId"
  - "#RawAmpExposureMetadata.metadataKey"
  indexes:
  - name: IDX_rawAmpExposureMetadata_metadataKey
    "@id": "#IDX_rawAmpExposureMetadata_metadataKey"
    columns:
    - "#RawAmpExposureMetadata.metadataKey"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: RawCcdExposure
  "@id": "#RawCcdExposure"
  columns:
  - name: rawCcdExposureId
    "@id": "#RawCcdExposure.rawCcdExposureId"
    datatype: long
    description: Primary key (unique identifier).
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: rawExposureId
    "@id": "#RawCcdExposure.rawExposureId"
    datatype: long
    description: Point to the RawExposure containing this ccd exposure.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: ccdName
    "@id": "#RawCcdExposure.ccdName"
    datatype: char
    description: Ccd name.
    length: 3
    mysql:datatype: CHAR(3)
    ivoa:ucd: meta.id;instr.det
  - name: raftName
    "@id": "#RawCcdExposure.raftName"
    datatype: char
    description: Raft name.
    length: 3
    mysql:datatype: CHAR(3)
    ivoa:ucd: meta.id;instr.det
  - name: filterName
    "@id": "#RawCcdExposure.filterName"
    datatype: char
    description: Filter name.
    length: 1
    mysql:datatype: CHAR(1)
    ivoa:ucd: meta.id;instr.filter
  - name: ra
    "@id": "#RawCcdExposure.ra"
    datatype: double
    description: RA of field of view center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: decl
    "@id": "#RawCcdExposure.decl"
    datatype: double
    description: Declination of field of view center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: skyRotation
    "@id": "#RawCcdExposure.skyRotation"
    datatype: double
    description: Sky rotation angle.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: zenithDistance
    "@id": "#RawCcdExposure.zenithDistance"
    datatype: float
    description: Zenith distance at observation mid-point.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: pos.az.zd
  - name: airmass
    "@id": "#RawCcdExposure.airmass"
    datatype: float
    description: Airmass at the observed line of sight.
    mysql:datatype: FLOAT
  - name: llcx
    "@id": "#RawCcdExposure.llcx"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: llcy
    "@id": "#RawCcdExposure.llcy"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: ulcx
    "@id": "#RawCcdExposure.ulcx"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5+ySize).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: ulcy
    "@id": "#RawCcdExposure.ulcy"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5+ySize).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: urcx
    "@id": "#RawCcdExposure.urcx"
    datatype: int
    description: FITS pixel coordinates (0.5+xSize, 0.5+ySize).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: urcy
    "@id": "#RawCcdExposure.urcy"
    datatype: int
    description: FITS pixel coordinates (0.5+xSize, 0.5+ySize).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: lrcx
    "@id": "#RawCcdExposure.lrcx"
    datatype: int
    description: FITS pixel coordinates (0.5+xSize, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: lrcy
    "@id": "#RawCcdExposure.lrcy"
    datatype: int
    description: FITS pixel coordinates (0.5+xSize, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: xSize
    "@id": "#RawCcdExposure.xSize"
    datatype: int
    description: Number of rows in the image.
    mysql:datatype: INTEGER
  - name: ySize
    "@id": "#RawCcdExposure.ySize"
    datatype: int
    description: Number of columns in the image.
    mysql:datatype: INTEGER
  - name: obsStart
    "@id": "#RawCcdExposure.obsStart"
    datatype: timestamp
    description: Start of the exposure, TAI, accurate to 10ms.
    defaultValue: CURRENT_TIMESTAMP
    mysql:datatype: TIMESTAMP
    ivoa:ucd: time.start
  - name: expMidpt
    "@id": "#RawCcdExposure.expMidpt"
    datatype: double
    description: Midpoint for exposure. TAI, accurate to 10ms.
    mysql:datatype: DOUBLE
    ivoa:ucd: time.epoch
  - name: expTime
    "@id": "#RawCcdExposure.expTime"
    datatype: double
    description: Duration of exposure, accurate to 10ms.
    mysql:datatype: DOUBLE
    fits:tunit: s
    ivoa:ucd: time.duration
  - name: darkTime
    "@id": "#RawCcdExposure.darkTime"
    datatype: double
    description: Dark current accumulation time, accurate to 10ms.
    mysql:datatype: DOUBLE
    fits:tunit: s
    ivoa:ucd: time.duration
  - name: ccdTemp
    "@id": "#RawCcdExposure.ccdTemp"
    datatype: float
    description: Temperature measured on the Ccd.
    mysql:datatype: FLOAT
  - name: binX
    "@id": "#RawCcdExposure.binX"
    datatype: int
    description: Binning of the ccd in x (row) direction.
    mysql:datatype: INTEGER
    fits:tunit: pixel
    ivoa:ucd: meta.number
  - name: binY
    "@id": "#RawCcdExposure.binY"
    datatype: int
    description: Binning of the ccd in y (column) direction.
    mysql:datatype: INTEGER
    fits:tunit: pixel
    ivoa:ucd: meta.number
  - name: WCS
    "@id": "#RawCcdExposure.WCS"
    datatype: binary
    description: A nominal WCS derives from telescope pointing information (not fitted).
      [10x8 BYTES].
    mysql:datatype: BLOB
  - name: flags
    "@id": "#RawCcdExposure.flags"
    datatype: int
    description: Flags, bitwise OR tbd
    defaultValue: '0'
    mysql:datatype: INTEGER
    ivoa:ucd: meta.code
  primaryKey: "#RawCcdExposure.rawCcdExposureId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: RawCcdExposureMetadata
  "@id": "#RawCcdExposureMetadata"
  description: Generic key-value pair metadata for RawCcdExposure.
  columns:
  - name: rawCcdExposureId
    "@id": "#RawCcdExposureMetadata.rawCcdExposureId"
    datatype: long
    description: Id of the corresponding RawCcdExposure.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: metadataKey
    "@id": "#RawCcdExposureMetadata.metadataKey"
    datatype: string
    length: 255
    mysql:datatype: VARCHAR(255)
  - name: metadataValue
    "@id": "#RawCcdExposureMetadata.metadataValue"
    datatype: string
    length: 255
    mysql:datatype: VARCHAR(255)
  primaryKey: "#RawCcdExposureMetadata.rawCcdExposureId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: RawExposure
  "@id": "#RawExposure"
  description: Raw exposure (entire exposure, all ccds).
  columns:
  - name: rawExposureId
    "@id": "#RawExposure.rawExposureId"
    datatype: long
    description: Primary key (unique identifier.)
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: filterName
    "@id": "#RawExposure.filterName"
    datatype: char
    description: Filter name.
    length: 1
    mysql:datatype: CHAR(1)
    ivoa:ucd: meta.id;instr.filter
  - name: ra
    "@id": "#RawExposure.ra"
    datatype: double
    description: Right Ascension of focal plane center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: decl
    "@id": "#RawExposure.decl"
    datatype: double
    description: Declination of focal plane center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: skyRotation
    "@id": "#RawExposure.skyRotation"
    datatype: double
    description: Sky rotation angle.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: altitude
    "@id": "#RawExposure.altitude"
    datatype: double
    description: Altitude of focal plane center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: azimuth
    "@id": "#RawExposure.azimuth"
    datatype: double
    description: Azimuth of focal plane center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: programId
    "@id": "#RawExposure.programId"
    datatype: int
    description: Observing program id (e.g., universal cadence, or one of the deep
      drilling programs, etc.).
    mysql:datatype: INT
  - name: exposureType
    "@id": "#RawExposure.exposureType"
    datatype: byte
    description: Type of exposure (science exposure, dark, flat, etc.).
    mysql:datatype: TINYINT
  - name: zenithDistance
    "@id": "#RawExposure.zenithDistance"
    datatype: float
    description: Zenith distance at observation mid-point.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: pos.az.zd
  - name: airmass
    "@id": "#RawExposure.airmass"
    datatype: float
    description: Airmass of the observed line of sight.
    mysql:datatype: FLOAT
  - name: obsStart
    "@id": "#RawExposure.obsStart"
    datatype: timestamp
    description: Start of the exposure, TAI, accurate to 10ms.
    defaultValue: CURRENT_TIMESTAMP
    mysql:datatype: TIMESTAMP
    ivoa:ucd: time.start
  - name: expMidpt
    "@id": "#RawExposure.expMidpt"
    datatype: double
    description: Midpoint for exposure. TAI, accurate to 10ms.
    mysql:datatype: DOUBLE
    ivoa:ucd: time.epoch
  - name: expTime
    "@id": "#RawExposure.expTime"
    datatype: double
    description: Duration of exposure, accurate to 10ms.
    mysql:datatype: DOUBLE
    fits:tunit: s
    ivoa:ucd: time.duration
  - name: cameraTemp
    "@id": "#RawExposure.cameraTemp"
    datatype: float
    description: Temperature measured of the camera.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: mirror1Temp
    "@id": "#RawExposure.mirror1Temp"
    datatype: float
    description: Primary mirror temperature.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: mirror2Temp
    "@id": "#RawExposure.mirror2Temp"
    datatype: float
    description: Secondary mirror temperature.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: mirror3Temp
    "@id": "#RawExposure.mirror3Temp"
    datatype: float
    description: Tertiary mirror temperature.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: domeTemp
    "@id": "#RawExposure.domeTemp"
    datatype: float
    description: Dome temperature.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: externalTemp
    "@id": "#RawExposure.externalTemp"
    datatype: float
    description: Temperature outside the dome.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: dimmSeeing
    "@id": "#RawExposure.dimmSeeing"
    datatype: float
    description: Seeing measured by the differential image motion monitor.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: pwvGPS
    "@id": "#RawExposure.pwvGPS"
    datatype: float
    description: " GPS-based measurement of precipitable water vapor (PVW)."
    mysql:datatype: FLOAT
    fits:tunit: mm
  - name: pwvMW
    "@id": "#RawExposure.pwvMW"
    datatype: float
    description: Microwave radiometer measurement of PVW.
    mysql:datatype: FLOAT
    fits:tunit: mm
  - name: flags
    "@id": "#RawExposure.flags"
    datatype: int
    description: Flags, bitwise OR tbd
    defaultValue: '0'
    mysql:datatype: INTEGER
    ivoa:ucd: meta.code
  primaryKey: "#RawExposure.rawExposureId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: CcdVisit
  "@id": "#CcdVisit"
  columns:
  - name: ccdVisitId
    "@id": "#CcdVisit.ccdVisitId"
    datatype: long
    description: Primary key (unique identifier).
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: visitId
    "@id": "#CcdVisit.visitId"
    datatype: int
    description: Reference to the corresponding entry in the Visit table.
    mysql:datatype: INTEGER
    ivoa:ucd: meta.id;obs.exposure
  - name: ccdName
    "@id": "#CcdVisit.ccdName"
    datatype: char
    description: Ccd name.
    length: 3
    mysql:datatype: CHAR(3)
    ivoa:ucd: meta.id;instr.det
  - name: raftName
    "@id": "#CcdVisit.raftName"
    datatype: char
    description: Raft name.
    length: 3
    mysql:datatype: CHAR(3)
    ivoa:ucd: meta.id;instr.det
  - name: filterName
    "@id": "#CcdVisit.filterName"
    datatype: char
    description: Filter name used for this exposure.
    length: 1
    mysql:datatype: CHAR(1)
    ivoa:ucd: meta.id;instr.filter
  - name: nExposures
    "@id": "#CcdVisit.nExposures"
    datatype: int
    description: Number of exposures combined to produce this visit.
    mysql:datatype: INT
  - name: ra
    "@id": "#CcdVisit.ra"
    datatype: double
    description: RA of Ccd center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: decl
    "@id": "#CcdVisit.decl"
    datatype: double
    description: Decl of Ccd center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: skyRotation
    "@id": "#CcdVisit.skyRotation"
    datatype: double
    description: Sky rotation angle.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: zenithDistance
    "@id": "#CcdVisit.zenithDistance"
    datatype: float
    description: Zenith distance at observation mid-point.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: pos.az.zd
  - name: llcx
    "@id": "#CcdVisit.llcx"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: llcy
    "@id": "#CcdVisit.llcy"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: ulcx
    "@id": "#CcdVisit.ulcx"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5+ySize).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: ulcy
    "@id": "#CcdVisit.ulcy"
    datatype: int
    description: FITS pixel coordinates (0.5, 0.5+ySize).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: urcx
    "@id": "#CcdVisit.urcx"
    datatype: int
    description: FITS pixel coordinates (0.5+xSize, 0.5+ySize).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: urcy
    "@id": "#CcdVisit.urcy"
    datatype: int
    description: FITS pixel coordinates (0.5+xSize, 0.5+ySize).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: lrcx
    "@id": "#CcdVisit.lrcx"
    datatype: int
    description: FITS pixel coordinates (0.5+xSize, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: lrcy
    "@id": "#CcdVisit.lrcy"
    datatype: int
    description: FITS pixel coordinates (0.5+xSize, 0.5).
    mysql:datatype: INTEGER
    fits:tunit: pixels
  - name: xSize
    "@id": "#CcdVisit.xSize"
    datatype: int
    description: Number of columns in the image.
    mysql:datatype: INTEGER
  - name: ySize
    "@id": "#CcdVisit.ySize"
    datatype: int
    description: Number of rows in the image.
    mysql:datatype: INTEGER
  - name: obsStart
    "@id": "#CcdVisit.obsStart"
    datatype: timestamp
    description: Start of the exposure, TAI, accurate to 10ms.
    defaultValue: CURRENT_TIMESTAMP
    mysql:datatype: TIMESTAMP
    ivoa:ucd: time.start
  - name: expMidpt
    "@id": "#CcdVisit.expMidpt"
    datatype: double
    description: Midpoint for exposure. TAI, accurate to 10ms.
    mysql:datatype: DOUBLE
    ivoa:ucd: time.epoch
  - name: expTime
    "@id": "#CcdVisit.expTime"
    datatype: double
    description: Average duration of exposure, accurate to 10ms.
    mysql:datatype: DOUBLE
    fits:tunit: s
    ivoa:ucd: time.duration
  - name: darkTime
    "@id": "#CcdVisit.darkTime"
    datatype: double
    description: Average dark current accumulation time, accurate to 10ms.
    mysql:datatype: DOUBLE
    fits:tunit: s
    ivoa:ucd: time.duration
  - name: ccdTemp
    "@id": "#CcdVisit.ccdTemp"
    datatype: float
    description: Temperature measured on the Ccd.
    mysql:datatype: FLOAT
  - name: binX
    "@id": "#CcdVisit.binX"
    datatype: int
    description: Binning of the ccd in x (row) direction.
    mysql:datatype: INTEGER
    fits:tunit: pixel
    ivoa:ucd: meta.number
  - name: binY
    "@id": "#CcdVisit.binY"
    datatype: int
    description: Binning of the ccd in y (column) direction.
    mysql:datatype: INTEGER
    fits:tunit: pixel
    ivoa:ucd: meta.number
  - name: WCS
    "@id": "#CcdVisit.WCS"
    datatype: binary
    description: Precise WCS solution for the Ccd. [100x4 BYTES].
    mysql:datatype: BLOB
  - name: zeroPoint
    "@id": "#CcdVisit.zeroPoint"
    datatype: float
    description: Zero-point for the Ccd, estimated at Ccd center.
    mysql:datatype: FLOAT
  - name: seeing
    "@id": "#CcdVisit.seeing"
    datatype: float
    description: Mean measured FWHM of the PSF.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: skyBg
    "@id": "#CcdVisit.skyBg"
    datatype: float
    description: Average sky background.
    mysql:datatype: FLOAT
    fits:tunit: DN
  - name: skyNoise
    "@id": "#CcdVisit.skyNoise"
    datatype: float
    description: RMS noise of the sky background.
    mysql:datatype: FLOAT
    fits:tunit: DN
  - name: flags
    "@id": "#CcdVisit.flags"
    datatype: int
    description: Flags, bitwise OR tbd
    defaultValue: '0'
    mysql:datatype: INTEGER
    ivoa:ucd: meta.code
  primaryKey: "#CcdVisit.ccdVisitId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: CcdVisitMetadata
  "@id": "#CcdVisitMetadata"
  description: Generic key-value pair metadata for CcdVisit.
  columns:
  - name: ccdVisitId
    "@id": "#CcdVisitMetadata.ccdVisitId"
    datatype: long
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: metadataKey
    "@id": "#CcdVisitMetadata.metadataKey"
    datatype: string
    length: 255
    mysql:datatype: VARCHAR(255)
  - name: intValue
    "@id": "#CcdVisitMetadata.intValue"
    datatype: int
    mysql:datatype: INTEGER
  - name: doubleValue
    "@id": "#CcdVisitMetadata.doubleValue"
    datatype: double
    mysql:datatype: DOUBLE
  - name: stringValue
    "@id": "#CcdVisitMetadata.stringValue"
    datatype: string
    length: 255
    mysql:datatype: VARCHAR(255)
  primaryKey:
  - "#CcdVisitMetadata.ccdVisitId"
  - "#CcdVisitMetadata.metadataKey"
  indexes:
  - name: IDX_CcdVisitMetadata_metadataKey
    "@id": "#IDX_CcdVisitMetadata_metadataKey"
    columns:
    - "#CcdVisitMetadata.metadataKey"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: Visit
  "@id": "#Visit"
  description: Defines a single Visit.
  columns:
  - name: visitId
    "@id": "#Visit.visitId"
    datatype: int
    description: Unique identifier.
    mysql:datatype: INTEGER
    ivoa:ucd: meta.id;obs.image
  - name: filterName
    "@id": "#Visit.filterName"
    datatype: char
    description: Filter name.
    length: 1
    mysql:datatype: CHAR(1)
    ivoa:ucd: meta.id;instr.filter
  - name: nExposures
    "@id": "#Visit.nExposures"
    datatype: int
    description: Number of exposures combined to produce this visit.
    mysql:datatype: INT
  - name: ra
    "@id": "#Visit.ra"
    datatype: double
    description: RA of focal plane center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.ra
  - name: decl
    "@id": "#Visit.decl"
    datatype: double
    description: Decl of focal plane center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
    ivoa:ucd: pos.eq.dec
  - name: skyRotation
    "@id": "#Visit.skyRotation"
    datatype: double
    description: Sky rotation angle.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: altitude
    "@id": "#Visit.altitude"
    datatype: double
    description: Altitude of focal plane center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: azimuth
    "@id": "#Visit.azimuth"
    datatype: double
    description: Azimuth of focal plane center.
    mysql:datatype: DOUBLE
    fits:tunit: deg
  - name: programId
    "@id": "#Visit.programId"
    datatype: int
    description: Observing program id (e.g., universal cadence, or one of the deep
      drilling programs, etc.).
    mysql:datatype: INT
  - name: exposureType
    "@id": "#Visit.exposureType"
    datatype: byte
    description: Type of exposure (science exposure, dark, flat, etc.).
    mysql:datatype: TINYINT
  - name: zenithDistance
    "@id": "#Visit.zenithDistance"
    datatype: float
    description: Zenith distance at observation mid-point.
    mysql:datatype: FLOAT
    fits:tunit: deg
    ivoa:ucd: pos.az.zd
  - name: airmass
    "@id": "#Visit.airmass"
    datatype: float
    description: Airmass of the observed line of sight.
    mysql:datatype: FLOAT
  - name: obsStart
    "@id": "#Visit.obsStart"
    datatype: timestamp
    description: Start of the exposure at the fiducial center of the focal plane array,
      TAI, accurate to 10ms.
    defaultValue: CURRENT_TIMESTAMP
    mysql:datatype: TIMESTAMP
    ivoa:ucd: time.start
  - name: expMidpt
    "@id": "#Visit.expMidpt"
    datatype: double
    description: Midpoint for exposure at the fiducial center of the focal plane array.
      TAI, accurate to 10ms.
    mysql:datatype: DOUBLE
    ivoa:ucd: time.epoch
  - name: expTime
    "@id": "#Visit.expTime"
    datatype: double
    description: Average duration of exposure, accurate to 10ms.
    mysql:datatype: DOUBLE
    fits:tunit: s
    ivoa:ucd: time.duration
  - name: cameraTemp
    "@id": "#Visit.cameraTemp"
    datatype: float
    description: Temperature measured of the camera.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: mirror1Temp
    "@id": "#Visit.mirror1Temp"
    datatype: float
    description: Primary mirror temperature.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: mirror2Temp
    "@id": "#Visit.mirror2Temp"
    datatype: float
    description: Secondary mirror temperature.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: mirror3Temp
    "@id": "#Visit.mirror3Temp"
    datatype: float
    description: Tertiary mirror temperature.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: domeTemp
    "@id": "#Visit.domeTemp"
    datatype: float
    description: Dome temperature.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: externalTemp
    "@id": "#Visit.externalTemp"
    datatype: float
    description: Temperature outside the dome.
    mysql:datatype: FLOAT
    fits:tunit: K
  - name: dimmSeeing
    "@id": "#Visit.dimmSeeing"
    datatype: float
    description: Seeing measured by the differential image motion monitor.
    mysql:datatype: FLOAT
    fits:tunit: arcsec
  - name: pwvGPS
    "@id": "#Visit.pwvGPS"
    datatype: float
    description: " GPS-based measurement of precipitable water vapor (PVW)."
    mysql:datatype: FLOAT
    fits:tunit: mm
  - name: pwvMW
    "@id": "#Visit.pwvMW"
    datatype: float
    description: Microwave radiometer measurement of PVW.
    mysql:datatype: FLOAT
    fits:tunit: mm
  - name: flags
    "@id": "#Visit.flags"
    datatype: int
    description: Flags, bitwise OR tbd
    defaultValue: '0'
    mysql:datatype: INTEGER
    ivoa:ucd: meta.code
  primaryKey: "#Visit.visitId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: VisitMetadata
  "@id": "#VisitMetadata"
  description: Visit-related generic key-value pair metadata.
  columns:
  - name: visitId
    "@id": "#VisitMetadata.visitId"
    datatype: int
    description: Id of the corresponding Visit.
    mysql:datatype: INTEGER
    ivoa:ucd: meta.id;obs.image
  - name: metadataKey
    "@id": "#VisitMetadata.metadataKey"
    datatype: string
    length: 255
    mysql:datatype: VARCHAR(255)
  - name: metadataValue
    "@id": "#VisitMetadata.metadataValue"
    datatype: string
    length: 255
    mysql:datatype: VARCHAR(255)
  primaryKey: "#VisitMetadata.visitId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: Visit_To_RawExposure
  "@id": "#Visit_To_RawExposure"
  description: 'Mapping table: Visit to raw Exposure.'
  columns:
  - name: visitId
    "@id": "#Visit_To_RawExposure.visitId"
    datatype: int
    description: Pointer to entry in Visit table.
    mysql:datatype: INTEGER
    ivoa:ucd: meta.id;obs.image
  - name: rawExposureId
    "@id": "#Visit_To_RawExposure.rawExposureId"
    datatype: long
    description: Pointer to entry in RawExposure table.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  indexes:
  - name: IDX_VisitToRawExposure_visitId
    "@id": "#IDX_VisitToRawExposure_visitId"
    columns:
    - "#Visit_To_RawExposure.visitId"
  - name: IDX_VisitToRawExposure_rawExposureId
    "@id": "#IDX_VisitToRawExposure_rawExposureId"
    columns:
    - "#Visit_To_RawExposure.rawExposureId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: prv_ProcHistory
  "@id": "#prv_ProcHistory"
  description: This table produces unique procHistoryIds. The id changes each time
    something changes in the provenance. It is not linked to any other table. Because
    it is recording the time, it can serve as a 'snapshot'. E.g., based on the time
    we can find out which configurations were valid at that time, what was executed
    at that time etc. It also serves as a 'flag' that something has changed.
  columns:
  - name: procHistoryId
    "@id": "#prv_ProcHistory.procHistoryId"
    datatype: long
    description: Unique id
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: theTime
    "@id": "#prv_ProcHistory.theTime"
    datatype: timestamp
    description: Time when this procHistory id was created.
    defaultValue: CURRENT_TIMESTAMP
    mysql:datatype: TIMESTAMP
  - name: description
    "@id": "#prv_ProcHistory.description"
    datatype: text
    description: Description what has changed. This is optional.
    mysql:datatype: TEXT
  primaryKey: "#prv_ProcHistory.procHistoryId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_Pipeline
  "@id": "#prv_Pipeline"
  description: " This table defines all LSST Pipelines. One row per pipeline."
  columns:
  - name: pipelineId
    "@id": "#prv_Pipeline.pipelineId"
    datatype: int
    description: Unique id
    mysql:datatype: INT
    ivoa:ucd: meta.id;src
  - name: pipelineName
    "@id": "#prv_Pipeline.pipelineName"
    datatype: string
    description: Pipeline name.
    length: 64
    mysql:datatype: VARCHAR(64)
    ivoa:ucd: meta.id;src
  primaryKey: "#prv_Pipeline.pipelineId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_cnf_Pipeline
  "@id": "#prv_cnf_Pipeline"
  description: This table defines all configurations for all pipelines.
  columns:
  - name: pipelineCnfId
    "@id": "#prv_cnf_Pipeline.pipelineCnfId"
    datatype: int
    description: Unique id
    mysql:datatype: INT
    ivoa:ucd: meta.id;src
  - name: pipelineId
    "@id": "#prv_cnf_Pipeline.pipelineId"
    datatype: int
    description: Id of the pipeline this configuration is for.
    mysql:datatype: INT
  - name: validityBegin
    "@id": "#prv_cnf_Pipeline.validityBegin"
    datatype: timestamp
    description: Time when this configuration started to be valid.
    mysql:datatype: DATETIME
  - name: validityEnd
    "@id": "#prv_cnf_Pipeline.validityEnd"
    datatype: timestamp
    description: Time when this configuration stoped being valid.
    mysql:datatype: DATETIME
  - name: notes
    "@id": "#prv_cnf_Pipeline.notes"
    datatype: string
    description: Notes/description useful to keep with this configuration.
    length: 256
    mysql:datatype: VARCHAR(256)
  primaryKey: "#prv_cnf_Pipeline.pipelineCnfId"
  constraints:
  - name: FK_cnfPipeline_prv_Pipeline
    "@id": "#FK_cnfPipeline_prv_Pipeline"
    columns:
    - "#prv_cnf_Pipeline.pipelineId"
    referencedColumns:
    - "#prv_Pipeline.pipelineId"
  indexes:
  - name: IDX_cnfPipeline_pipeId
    "@id": "#IDX_cnfPipeline_pipeId"
    columns:
    - "#prv_cnf_Pipeline.pipelineId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_Task
  "@id": "#prv_Task"
  description: This table defines all tasks for all pipelines.
  columns:
  - name: taskId
    "@id": "#prv_Task.taskId"
    datatype: int
    description: Unique id
    mysql:datatype: INT
    ivoa:ucd: meta.id;src
  - name: taskName
    "@id": "#prv_Task.taskName"
    datatype: string
    description: Name of the task.
    length: 64
    mysql:datatype: VARCHAR(64)
  primaryKey: "#prv_Task.taskId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_cnf_Pipeline_Tasks
  "@id": "#prv_cnf_Pipeline_Tasks"
  description: This is a helper table for prv_cnf_Pipeline, it defines what tasks
    a given configuration of a pipeline consists of, and what the order is. If tasks
    are arranged hierarchically, parentTaskId determines which parent task given task
    belongs to. For tasks that do not have a parent task, parentTaskId is set to NULL.
    Positions should be numbered starting with 1, and are relative to its parent task.
  columns:
  - name: pipelineCnfId
    "@id": "#prv_cnf_Pipeline_Tasks.pipelineCnfId"
    datatype: int
    mysql:datatype: INT
  - name: taskId
    "@id": "#prv_cnf_Pipeline_Tasks.taskId"
    datatype: int
    description: Id of the corresponding task.
    mysql:datatype: INT
  - name: parentTaskId
    "@id": "#prv_cnf_Pipeline_Tasks.parentTaskId"
    datatype: int
    description: Id of the parent task, or NULL if there is no parent task.
    mysql:datatype: INT
  - name: taskPosition
    "@id": "#prv_cnf_Pipeline_Tasks.taskPosition"
    datatype: int
    description: Position of the task in the pipeline. Starts with 1.
    mysql:datatype: INT
  constraints:
  - name: FK_cnfPipeTasks_taskId
    "@id": "#FK_cnfPipeTasks_taskId"
    columns:
    - "#prv_cnf_Pipeline_Tasks.taskId"
    referencedColumns:
    - "#prv_Task.taskId"
  - name: FK_cnfPipeTasks_pipeCnfId
    "@id": "#FK_cnfPipeTasks_pipeCnfId"
    columns:
    - "#prv_cnf_Pipeline_Tasks.pipelineCnfId"
    referencedColumns:
    - "#prv_cnf_Pipeline.pipelineCnfId"
  indexes:
  - name: IDX_pipelineCnfId
    "@id": "#IDX_pipelineCnfId"
    columns:
    - "#prv_cnf_Pipeline_Tasks.pipelineCnfId"
  - name: IDX_taskId
    "@id": "#IDX_taskId"
    columns:
    - "#prv_cnf_Pipeline_Tasks.taskId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_cnf_Task
  "@id": "#prv_cnf_Task"
  description: This table defines all configurations for all tasks. Note that occasionally
    manual patching will be required, leading to more than one configuration (the
    default one, and the patch). This is achieved through taskCnfVersion column.
  columns:
  - name: taskCnfId
    "@id": "#prv_cnf_Task.taskCnfId"
    datatype: int
    description: Unique id
    mysql:datatype: INT
    ivoa:ucd: meta.id;src
  - name: taskId
    "@id": "#prv_cnf_Task.taskId"
    datatype: int
    description: Id of the corresponding task.
    mysql:datatype: INT
  - name: validityBegin
    "@id": "#prv_cnf_Task.validityBegin"
    datatype: timestamp
    description: Time when this configuration started to be valid.
    mysql:datatype: DATETIME
  - name: validityEnd
    "@id": "#prv_cnf_Task.validityEnd"
    datatype: timestamp
    description: Time when this configuration stoped being valid.
    mysql:datatype: DATETIME
  - name: taskCnfVersion
    "@id": "#prv_cnf_Task.taskCnfVersion"
    datatype: int
    description: Version of the config (in case there is more than one configuration
      that is valid for a given validity range.
    defaultValue: '1'
    mysql:datatype: INT
  - name: gitSHA
    "@id": "#prv_cnf_Task.gitSHA"
    datatype: string
    description: We need to capture version of the software used by this task. For
      now we are assuming it is just one SHA of one commit in git. In practice this
      can be more complicated, it can span multiple repos etc.
    length: 256
    mysql:datatype: VARCHAR(256)
  primaryKey: "#prv_cnf_Task.taskCnfId"
  constraints:
  - name: FK_cnfTask_taskId
    "@id": "#FK_cnfTask_taskId"
    columns:
    - "#prv_cnf_Task.taskId"
    referencedColumns:
    - "#prv_Task.taskId"
  indexes:
  - name: IDX_cnfTask_taskId
    "@id": "#IDX_cnfTask_taskId"
    columns:
    - "#prv_cnf_Task.taskId"
  - name: IDX_cnfTask_cnfVer
    "@id": "#IDX_cnfTask_cnfVer"
    columns:
    - "#prv_cnf_Task.taskCnfVersion"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_cnf_Task_Columns
  "@id": "#prv_cnf_Task_Columns"
  description: This table defines which tables+columns are altered by a given task.
    One row per table+column.
  columns:
  - name: taskCnfId
    "@id": "#prv_cnf_Task_Columns.taskCnfId"
    datatype: int
    description: If of the corresponding task configuration.
    mysql:datatype: INT
  - name: tcName
    "@id": "#prv_cnf_Task_Columns.tcName"
    datatype: text
    description: 'Table and column pair. Format: ''<table>.<column>''. ''<table>.*''
      is allowed to indicate all columns in a table.'
    mysql:datatype: TEXT
  constraints:
  - name: FK_cnfTaskCols_taskCnfId
    "@id": "#FK_cnfTaskCols_taskCnfId"
    columns:
    - "#prv_cnf_Task_Columns.taskCnfId"
    referencedColumns:
    - "#prv_cnf_Task.taskCnfId"
  indexes:
  - name: IDX_cnfTaskColumns_taskCnfId
    "@id": "#IDX_cnfTaskColumns_taskCnfId"
    columns:
    - "#prv_cnf_Task_Columns.taskCnfId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_cnf_Task_Files
  "@id": "#prv_cnf_Task_Files"
  description: This table defines which files are altered by a given task. One row
    per file. This table can be trivially extended should we capture which sections
    of files are altered.
  columns:
  - name: taskCnfId
    "@id": "#prv_cnf_Task_Files.taskCnfId"
    datatype: int
    description: If of the corresponding task configuration.
    mysql:datatype: INT
  - name: fileUrl
    "@id": "#prv_cnf_Task_Files.fileUrl"
    datatype: text
    description: url that uniquely locates the file.
    mysql:datatype: TEXT
  constraints:
  - name: FK_cnfTaskFiles_taskCnfId
    "@id": "#FK_cnfTaskFiles_taskCnfId"
    columns:
    - "#prv_cnf_Task_Files.taskCnfId"
    referencedColumns:
    - "#prv_cnf_Task.taskCnfId"
  indexes:
  - name: IDX_cnfTaskFiles_taskCnfId
    "@id": "#IDX_cnfTaskFiles_taskCnfId"
    columns:
    - "#prv_cnf_Task_Files.taskCnfId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_cnf_Task_KVParams
  "@id": "#prv_cnf_Task_KVParams"
  description: This table keeps parameter values for tasks. One row per parameter.
    For now everything is kept as strings (not efficient).
  columns:
  - name: taskCnfId
    "@id": "#prv_cnf_Task_KVParams.taskCnfId"
    datatype: int
    description: If of the corresponding task configuration.
    mysql:datatype: INT
  - name: theKey
    "@id": "#prv_cnf_Task_KVParams.theKey"
    datatype: string
    description: Unique key.
    length: 255
    mysql:datatype: VARCHAR(255)
  - name: theValue
    "@id": "#prv_cnf_Task_KVParams.theValue"
    datatype: string
    description: Value for the given key.
    length: 255
    mysql:datatype: VARCHAR(255)
  constraints:
  - name: FK_cnfTaskKVParams_tcId
    "@id": "#FK_cnfTaskKVParams_tcId"
    columns:
    - "#prv_cnf_Task_KVParams.taskCnfId"
    referencedColumns:
    - "#prv_cnf_Task.taskCnfId"
  indexes:
  - name: IDX_cnfTaskKVParams_taskCnfId
    "@id": "#IDX_cnfTaskKVParams_taskCnfId"
    columns:
    - "#prv_cnf_Task_KVParams.taskCnfId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_Node
  "@id": "#prv_Node"
  description: This table defines nodes. One row per node.
  columns:
  - name: nodeId
    "@id": "#prv_Node.nodeId"
    datatype: int
    description: Unique id
    mysql:datatype: INT
    ivoa:ucd: meta.id;src
  - name: nodeName
    "@id": "#prv_Node.nodeName"
    datatype: string
    description: Name of the node.
    length: 64
    mysql:datatype: VARCHAR(64)
  primaryKey: "#prv_Node.nodeId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_cnf_Node
  "@id": "#prv_cnf_Node"
  description: This table defines all configurations for all nodes.
  columns:
  - name: nodeId
    "@id": "#prv_cnf_Node.nodeId"
    datatype: int
    description: Id of the node this configuration is for.
    mysql:datatype: INT
  - name: validityBegin
    "@id": "#prv_cnf_Node.validityBegin"
    datatype: timestamp
    description: Time when this configuration started to be valid.
    mysql:datatype: DATETIME
  - name: validityEnd
    "@id": "#prv_cnf_Node.validityEnd"
    datatype: timestamp
    description: Time when this configuration stoped being valid.
    mysql:datatype: DATETIME
  - name: ip
    "@id": "#prv_cnf_Node.ip"
    datatype: string
    description: IP address (just a silly varchar for now)
    length: 64
    mysql:datatype: VARCHAR(64)
  - name: os
    "@id": "#prv_cnf_Node.os"
    datatype: string
    description: Operating system name and version.
    length: 64
    mysql:datatype: VARCHAR(64)
  - name: cores
    "@id": "#prv_cnf_Node.cores"
    datatype: int
    description: Number of cores.
    mysql:datatype: INT
  - name: ram
    "@id": "#prv_cnf_Node.ram"
    datatype: int
    description: Size of memory [GB].
    mysql:datatype: INT
  constraints:
  - name: FK_cnfNode_nodeId
    "@id": "#FK_cnfNode_nodeId"
    columns:
    - "#prv_cnf_Node.nodeId"
    referencedColumns:
    - "#prv_Node.nodeId"
  indexes:
  - name: IDX_cnfNode_nodeId
    "@id": "#IDX_cnfNode_nodeId"
    columns:
    - "#prv_cnf_Node.nodeId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_DataBlock
  "@id": "#prv_DataBlock"
  description: This table defines blocks of data. A block of data is a group of ids
    from the same table that are processed together using the same configuration.
  columns:
  - name: blockId
    "@id": "#prv_DataBlock.blockId"
    datatype: long
    description: Unique id
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: tableName
    "@id": "#prv_DataBlock.tableName"
    datatype: string
    description: Name of the table this data block is part of.
    length: 64
    mysql:datatype: VARCHAR(64)
  primaryKey: "#prv_DataBlock.blockId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_RowIdToDataBlock
  "@id": "#prv_RowIdToDataBlock"
  description: This table defines which rows belong to a given data block.
  columns:
  - name: theId
    "@id": "#prv_RowIdToDataBlock.theId"
    datatype: long
    description: The id of one data element. Note that we are not enforcing strict
      foreign key constraint because this will point to different tables.
    mysql:datatype: BIGINT
  - name: blockId
    "@id": "#prv_RowIdToDataBlock.blockId"
    datatype: long
    description: Id of the block a given row id corresponds to.
    mysql:datatype: BIGINT
  constraints:
  - name: FK_rowIdTodataBlock_blockId
    "@id": "#FK_rowIdTodataBlock_blockId"
    columns:
    - "#prv_RowIdToDataBlock.blockId"
    referencedColumns:
    - "#prv_DataBlock.blockId"
  indexes:
  - name: IDX_rowIdToDataBlock_theId
    "@id": "#IDX_rowIdToDataBlock_theId"
    columns:
    - "#prv_RowIdToDataBlock.theId"
  - name: IDX_rowIdToDataBlock_blockId
    "@id": "#IDX_rowIdToDataBlock_blockId"
    columns:
    - "#prv_RowIdToDataBlock.blockId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_TaskExecution
  "@id": "#prv_TaskExecution"
  description: 'This table keeps information about all tasks ever executed. Since
    the configuration of the system is not allowed to change while a tasks is running,
    we are not keeping a time range here, but instead we just keep the time of when
    the task started. It might be a good idea to keep the time of the middle of task
    execution: endTime-startTime/2 to reduce changes of running into an issue with
    time synchronization between different machines. This table is one of the most
    important parts of provenance - it links tasks executions with nodes and processed
    groups. Occasionally manual patching will be required, which will lead to more
    than one valid configuration of a given task. TaskCnfVersion indicates which version
    should be used for a given task execution.'
  columns:
  - name: taskExecId
    "@id": "#prv_TaskExecution.taskExecId"
    datatype: long
    description: Unique id
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;src
  - name: taskId
    "@id": "#prv_TaskExecution.taskId"
    datatype: int
    description: Id of the task that is executed.
    mysql:datatype: INT
  - name: nodeId
    "@id": "#prv_TaskExecution.nodeId"
    datatype: int
    description: Id of the node where the task is executed.
    mysql:datatype: INT
  - name: theTime
    "@id": "#prv_TaskExecution.theTime"
    datatype: timestamp
    description: The time when the task execution was started.
    mysql:datatype: DATETIME
  - name: taskCnfVersion
    "@id": "#prv_TaskExecution.taskCnfVersion"
    datatype: int
    description: Version of the task configuration. Typically there is only one, in
      some rare cases when manual patching in required, we can end up with more than
      one valid config version.
    defaultValue: '1'
    mysql:datatype: INT
  primaryKey: "#prv_TaskExecution.taskExecId"
  constraints:
  - name: FK_taskExec_taskId
    "@id": "#FK_taskExec_taskId"
    columns:
    - "#prv_TaskExecution.taskId"
    referencedColumns:
    - "#prv_Task.taskId"
  - name: FK_taskExec_nodeId
    "@id": "#FK_taskExec_nodeId"
    columns:
    - "#prv_TaskExecution.nodeId"
    referencedColumns:
    - "#prv_Node.nodeId"
  - name: FK_taskExec_cnfVersion
    "@id": "#FK_taskExec_cnfVersion"
    columns:
    - "#prv_TaskExecution.taskCnfVersion"
    referencedColumns:
    - "#prv_cnf_Task.taskCnfVersion"
  indexes:
  - name: IDX_taskExec_taskId
    "@id": "#IDX_taskExec_taskId"
    columns:
    - "#prv_TaskExecution.taskId"
  - name: IDX_taskExec_nodeId
    "@id": "#IDX_taskExec_nodeId"
    columns:
    - "#prv_TaskExecution.nodeId"
  - name: IDX_taskExec_cnfVer
    "@id": "#IDX_taskExec_cnfVer"
    columns:
    - "#prv_TaskExecution.taskCnfVersion"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_TaskExecutionToInputDataBlock
  "@id": "#prv_TaskExecutionToInputDataBlock"
  description: This table maps tasks executions to input DataBlocks. Each block is
    typically processed by multiple task executions, and each task execution may process
    multiple data blocks, so it is many-to-many.
  columns:
  - name: taskExecId
    "@id": "#prv_TaskExecutionToInputDataBlock.taskExecId"
    datatype: long
    description: Id of the task execution.
    mysql:datatype: BIGINT
  - name: blockId
    "@id": "#prv_TaskExecutionToInputDataBlock.blockId"
    datatype: long
    description: Id of the block a given task execution uses an input or NULL.
    mysql:datatype: BIGINT
  constraints:
  - name: FK_te2IDB_taskExecId
    "@id": "#FK_te2IDB_taskExecId"
    columns:
    - "#prv_TaskExecutionToInputDataBlock.taskExecId"
    referencedColumns:
    - "#prv_TaskExecution.taskExecId"
  - name: FK_te2IDB_blockId
    "@id": "#FK_te2IDB_blockId"
    columns:
    - "#prv_TaskExecutionToInputDataBlock.blockId"
    referencedColumns:
    - "#prv_DataBlock.blockId"
  indexes:
  - name: IDX_te2IDB_taskExecId
    "@id": "#IDX_te2IDB_taskExecId"
    columns:
    - "#prv_TaskExecutionToInputDataBlock.taskExecId"
  - name: IDX_ta2IDB_blockIdId
    "@id": "#IDX_ta2IDB_blockIdId"
    columns:
    - "#prv_TaskExecutionToInputDataBlock.blockId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: prv_TaskExecutionToOutputDataBlock
  "@id": "#prv_TaskExecutionToOutputDataBlock"
  description: This table maps tasks executions to output DataBlocks. Note that each
    task execution may output multiple data blocks. There is one entry here for each
    task execution - output block pair.
  columns:
  - name: taskExecId
    "@id": "#prv_TaskExecutionToOutputDataBlock.taskExecId"
    datatype: long
    description: Id of the task execution.
    mysql:datatype: BIGINT
  - name: blockId
    "@id": "#prv_TaskExecutionToOutputDataBlock.blockId"
    datatype: long
    description: Id of the block produced by a given task execution or NULL.
    mysql:datatype: BIGINT
  constraints:
  - name: FK_te2ODB_taskExecId
    "@id": "#FK_te2ODB_taskExecId"
    columns:
    - "#prv_TaskExecutionToOutputDataBlock.taskExecId"
    referencedColumns:
    - "#prv_TaskExecution.taskExecId"
  - name: FK_te2ODB_blockId
    "@id": "#FK_te2ODB_blockId"
    columns:
    - "#prv_TaskExecutionToOutputDataBlock.blockId"
    referencedColumns:
    - "#prv_DataBlock.blockId"
  indexes:
  - name: IDX_te2ODB_taskExecId
    "@id": "#IDX_te2ODB_taskExecId"
    columns:
    - "#prv_TaskExecutionToOutputDataBlock.taskExecId"
  - name: IDX_ta2ODB_blockId
    "@id": "#IDX_ta2ODB_blockId"
    columns:
    - "#prv_TaskExecutionToOutputDataBlock.blockId"
  mysql:engine: InnoDB
  mysql:charset: latin1
- name: sdqa_ImageStatus
  "@id": "#sdqa_ImageStatus"
  description: Unique set of status names and their definitions, e.g. 'passed', 'failed',
    etc.
  columns:
  - name: sdqa_imageStatusId
    "@id": "#sdqa_ImageStatus.sdqa_imageStatusId"
    datatype: short
    description: Primary key
    mysql:datatype: SMALLINT
  - name: statusName
    "@id": "#sdqa_ImageStatus.statusName"
    datatype: string
    description: One-word, camel-case, descriptive name of a possible image status
      (e.g., passedAuto, marginallyPassedManual, etc.)
    length: 30
    mysql:datatype: VARCHAR(30)
  - name: definition
    "@id": "#sdqa_ImageStatus.definition"
    datatype: string
    description: Detailed Definition of the image status
    length: 255
    mysql:datatype: VARCHAR(255)
  primaryKey: "#sdqa_ImageStatus.sdqa_imageStatusId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: sdqa_Metric
  "@id": "#sdqa_Metric"
  description: Unique set of metric names and associated metadata (e.g., 'nDeadPix';,
    'median';, etc.). There will be approximately 30 records total in this table.
  columns:
  - name: sdqa_metricId
    "@id": "#sdqa_Metric.sdqa_metricId"
    datatype: short
    description: Primary key.
    mysql:datatype: SMALLINT
  - name: metricName
    "@id": "#sdqa_Metric.metricName"
    datatype: string
    description: One-word, camel-case, descriptive name of a possible metric (e.g.,
      mSatPix, median, etc).
    length: 30
    mysql:datatype: VARCHAR(30)
  - name: physicalUnits
    "@id": "#sdqa_Metric.physicalUnits"
    datatype: string
    description: Physical units of metric.
    length: 30
    mysql:datatype: VARCHAR(30)
  - name: dataType
    "@id": "#sdqa_Metric.dataType"
    datatype: char
    description: Flag indicating whether data type of the metric value is integer
      (0) or float (1).
    length: 1
    mysql:datatype: CHAR(1)
  - name: definition
    "@id": "#sdqa_Metric.definition"
    datatype: string
    length: 255
    mysql:datatype: VARCHAR(255)
  primaryKey: "#sdqa_Metric.sdqa_metricId"
  constraints:
  - name: UQ_sdqaMetric_metricName
    "@id": "#UQ_sdqaMetric_metricName"
    columns:
    - "#sdqa_Metric.metricName"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: sdqa_Rating_ForAmpVisit
  "@id": "#sdqa_Rating_ForAmpVisit"
  description: Various SDQA ratings for a given amplifier image. There will approximately
    30 of these records per image record.
  columns:
  - name: sdqa_ratingId
    "@id": "#sdqa_Rating_ForAmpVisit.sdqa_ratingId"
    datatype: long
    description: Primary key. Auto-increment is used, we define a composite unique
      key, so potential duplicates will be captured.
    mysql:datatype: BIGINT
  - name: sdqa_metricId
    "@id": "#sdqa_Rating_ForAmpVisit.sdqa_metricId"
    datatype: short
    description: Pointer to sdqa_Metric.
    mysql:datatype: SMALLINT
  - name: sdqa_thresholdId
    "@id": "#sdqa_Rating_ForAmpVisit.sdqa_thresholdId"
    datatype: short
    description: Pointer to sdqa_Threshold.
    mysql:datatype: SMALLINT
  - name: ampVisitId
    "@id": "#sdqa_Rating_ForAmpVisit.ampVisitId"
    datatype: long
    description: Pointer to AmpVisit.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: metricValue
    "@id": "#sdqa_Rating_ForAmpVisit.metricValue"
    datatype: double
    description: Value of this SDQA metric.
    mysql:datatype: DOUBLE
  - name: metricErr
    "@id": "#sdqa_Rating_ForAmpVisit.metricErr"
    datatype: double
    description: Uncertainty of the value of this metric.
    mysql:datatype: DOUBLE
  primaryKey: "#sdqa_Rating_ForAmpVisit.sdqa_ratingId"
  constraints:
  - name: UQ_sdqaRatingForAmpVisit_metricId_ampVisitId
    "@id": "#UQ_sdqaRatingForAmpVisit_metricId_ampVisitId"
    columns:
    - "#sdqa_Rating_ForAmpVisit.sdqa_metricId"
    - "#sdqa_Rating_ForAmpVisit.ampVisitId"
  indexes:
  - name: IDX_sdqaRatingForAmpVisit_metricId
    "@id": "#IDX_sdqaRatingForAmpVisit_metricId"
    columns:
    - "#sdqa_Rating_ForAmpVisit.sdqa_metricId"
  - name: IDX_sdqaRatingForAmpVisit_thresholdId
    "@id": "#IDX_sdqaRatingForAmpVisit_thresholdId"
    columns:
    - "#sdqa_Rating_ForAmpVisit.sdqa_thresholdId"
  - name: IDX_sdqaRatingForAmpVisit_ampVisitId
    "@id": "#IDX_sdqaRatingForAmpVisit_ampVisitId"
    columns:
    - "#sdqa_Rating_ForAmpVisit.ampVisitId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: sdqa_Rating_CcdVisit
  "@id": "#sdqa_Rating_CcdVisit"
  description: Various SDQA ratings for a given CcdVisit.
  columns:
  - name: sdqa_ratingId
    "@id": "#sdqa_Rating_CcdVisit.sdqa_ratingId"
    datatype: long
    description: Primary key. Auto-increment is used, we define a composite unique
      key, so potential duplicates will be captured.
    mysql:datatype: BIGINT
  - name: sdqa_metricId
    "@id": "#sdqa_Rating_CcdVisit.sdqa_metricId"
    datatype: short
    description: Pointer to sdqa_Metric.
    mysql:datatype: SMALLINT
  - name: sdqa_thresholdId
    "@id": "#sdqa_Rating_CcdVisit.sdqa_thresholdId"
    datatype: short
    description: Pointer to sdqa_Threshold.
    mysql:datatype: SMALLINT
  - name: ccdVisitId
    "@id": "#sdqa_Rating_CcdVisit.ccdVisitId"
    datatype: long
    description: Pointer to CcdVisit.
    mysql:datatype: BIGINT
    ivoa:ucd: meta.id;obs.image
  - name: metricValue
    "@id": "#sdqa_Rating_CcdVisit.metricValue"
    datatype: double
    description: Value of this SDQA metric.
    mysql:datatype: DOUBLE
  - name: metricErr
    "@id": "#sdqa_Rating_CcdVisit.metricErr"
    datatype: double
    description: Uncertainty of the value of this metric.
    mysql:datatype: DOUBLE
  primaryKey: "#sdqa_Rating_CcdVisit.sdqa_ratingId"
  constraints:
  - name: UQ_sdqaRatingCcdVisit_metricId_ccdVisitId
    "@id": "#UQ_sdqaRatingCcdVisit_metricId_ccdVisitId"
    columns:
    - "#sdqa_Rating_CcdVisit.sdqa_metricId"
    - "#sdqa_Rating_CcdVisit.ccdVisitId"
  indexes:
  - name: IDX_sdqaRatingCcdVisit_metricId
    "@id": "#IDX_sdqaRatingCcdVisit_metricId"
    columns:
    - "#sdqa_Rating_CcdVisit.sdqa_metricId"
  - name: IDX_sdqaRatingCcdVisit_thresholdId
    "@id": "#IDX_sdqaRatingCcdVisit_thresholdId"
    columns:
    - "#sdqa_Rating_CcdVisit.sdqa_thresholdId"
  - name: IDX_sdqaRatingCcdVisit_ccdVisitId
    "@id": "#IDX_sdqaRatingCcdVisit_ccdVisitId"
    columns:
    - "#sdqa_Rating_CcdVisit.ccdVisitId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: sdqa_Threshold
  "@id": "#sdqa_Threshold"
  description: Version-controlled metric thresholds. Total number of these records
    is approximately equal to 30 x the number of times the thresholds will be changed
    over the entire period of LSST operations (of ordre of 100), with most of the
    changes occuring in the first year of operations.
  columns:
  - name: sdqa_thresholdId
    "@id": "#sdqa_Threshold.sdqa_thresholdId"
    datatype: short
    description: Primary key.
    mysql:datatype: SMALLINT
  - name: sdqa_metricId
    "@id": "#sdqa_Threshold.sdqa_metricId"
    datatype: short
    description: Pointer to sdqa_Metric table.
    mysql:datatype: SMALLINT
  - name: upperThreshold
    "@id": "#sdqa_Threshold.upperThreshold"
    datatype: double
    description: Threshold for which a metric value is tested to be greater than.
    mysql:datatype: DOUBLE
  - name: lowerThreshold
    "@id": "#sdqa_Threshold.lowerThreshold"
    datatype: double
    description: Threshold for which a metric value is tested to be less than.
    mysql:datatype: DOUBLE
  - name: createdDate
    "@id": "#sdqa_Threshold.createdDate"
    datatype: timestamp
    description: Database timestamp when the record is inserted.
    defaultValue: CURRENT_TIMESTAMP
    mysql:datatype: TIMESTAMP
  primaryKey: "#sdqa_Threshold.sdqa_thresholdId"
  indexes:
  - name: IDX_sdqaThreshold_metricId
    "@id": "#IDX_sdqaThreshold_metricId"
    columns:
    - "#sdqa_Threshold.sdqa_metricId"
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: LeapSeconds
  "@id": "#LeapSeconds"
  description: Based on <a href='http://maia.usno.navy.mil/ser7/tai-utc.dat'> http://maia.usno.navy.mil/ser7/tai-utc.dat</a>.
  columns:
  - name: whenJd
    "@id": "#LeapSeconds.whenJd"
    datatype: float
    description: JD of change in TAI-UTC difference (leap second).
    mysql:datatype: FLOAT
    fits:tunit: d
    ivoa:ucd: time.epoch
  - name: offset
    "@id": "#LeapSeconds.offset"
    datatype: float
    description: New number of leap seconds.
    mysql:datatype: FLOAT
    fits:tunit: s
    ivoa:ucd: time.interval
  - name: mjdRef
    "@id": "#LeapSeconds.mjdRef"
    datatype: float
    description: Reference MJD for drift (prior to 1972-Jan-1).
    mysql:datatype: FLOAT
    fits:tunit: d
    ivoa:ucd: time.epoch
  - name: drift
    "@id": "#LeapSeconds.drift"
    datatype: float
    description: Drift in seconds per day (prior to 1972-Jan-1).
    mysql:datatype: FLOAT
    fits:tunit: s/d
    ivoa:ucd: arith.rate
  - name: whenMjdUtc
    "@id": "#LeapSeconds.whenMjdUtc"
    datatype: float
    description: MJD in UTC system of change (computed).
    mysql:datatype: FLOAT
    fits:tunit: d
    ivoa:ucd: time.epoch
  - name: whenUtc
    "@id": "#LeapSeconds.whenUtc"
    datatype: long
    description: Nanoseconds from epoch in UTC system of change (computed).
    mysql:datatype: BIGINT
    fits:tunit: ns
    ivoa:ucd: time
  - name: whenTai
    "@id": "#LeapSeconds.whenTai"
    datatype: long
    description: Nanoseconds from epoch in TAI system of change (computed).
    mysql:datatype: BIGINT
    fits:tunit: ns
    ivoa:ucd: time
  mysql:engine: MyISAM
  mysql:charset: latin1
- name: ApertureBins
  "@id": "#ApertureBins"
  description: Definition of aperture bins (for both the Object and Source tables.)
  columns:
  - name: binN
    "@id": "#ApertureBins.binN"
    datatype: byte
    description: A bin in radius at which the aperture measurement is being performed.
    mysql:datatype: TINYINT
  - name: radiusMin
    "@id": "#ApertureBins.radiusMin"
    datatype: float
    description: Minimum aperture radii of bin.
    mysql:datatype: FLOAT
  - name: radiusMax
    "@id": "#ApertureBins.radiusMax"
    datatype: float
    description: Maximum aperture radii of bin.
    mysql:datatype: FLOAT
  primaryKey: "#ApertureBins.binN"
  mysql:engine: MyISAM
  mysql:charset: latin1
