# Generated from /home/salnikov/cat/sql/baselineSchema.sql
# by ./bin/parse_cat script
table: DiaObject
description: The DiaObject table contains descriptions of the astronomical objects
  detected on one or more difference images.
columns:
- name: diaObjectId
  type: BIGINT
  nullable: false
  description: Unique id.
  ucd: meta.id;src
- name: validityStart
  type: DATETIME
  nullable: false
  description: Time when validity of this diaObject starts.
- name: validityEnd
  type: DATETIME
  nullable: true
  description: Time when validity of this diaObject ends.
- name: ra
  type: DOUBLE
  nullable: false
  description: RA-coordinate of the position of the object at time radecTai.
  ucd: pos.eq.ra
  unit: deg
- name: raErr
  type: FLOAT
  nullable: true
  description: Uncertainty of ra.
  ucd: stat.error;pos.eq.ra
  unit: deg
- name: decl
  type: DOUBLE
  nullable: false
  description: Decl-coordinate of the position of the object at time radecTai.
  ucd: pos.eq.dec
  unit: deg
- name: declErr
  type: FLOAT
  nullable: true
  description: Uncertainty of decl.
  ucd: stat.error;pos.eq.dec
  unit: deg
- name: ra_decl_Cov
  type: FLOAT
  nullable: true
  description: Covariance between ra and decl.
  unit: deg^2
- name: radecTai
  type: DOUBLE
  nullable: true
  description: Time at which the object was at a position ra/decl.
  ucd: time.epoch
- name: pmRa
  type: FLOAT
  nullable: true
  description: Proper motion (ra).
  ucd: pos.pm
  unit: mas/yr
- name: pmRaErr
  type: FLOAT
  nullable: true
  description: Uncertainty of pmRa.
  ucd: stat.error;pos.pm
  unit: mas/yr
- name: pmDecl
  type: FLOAT
  nullable: true
  description: Proper motion (decl).
  ucd: pos.pm
  unit: mas/yr
- name: pmDeclErr
  type: FLOAT
  nullable: true
  description: Uncertainty of pmDecl.
  ucd: stat.error;pos.pm
  unit: mas/yr
- name: parallax
  type: FLOAT
  nullable: true
  description: Parallax.
  ucd: pos.parallax
  unit: mas
- name: parallaxErr
  type: FLOAT
  nullable: true
  description: Uncertainty of parallax.
  ucd: stat.error;pos.parallax
  unit: mas
- name: pmRa_pmDecl_Cov
  type: FLOAT
  nullable: true
  description: Covariance of pmRa and pmDecl.
  ucd: stat.covariance;pos.eq
  unit: (mas/yr)^2
- name: pmRa_parallax_Cov
  type: FLOAT
  nullable: true
  description: Covariance of pmRa and parallax.
  ucd: stat.covariance
  unit: mas^2/yr
- name: pmDecl_parallax_Cov
  type: FLOAT
  nullable: true
  description: Covariance of pmDecl and parallax.
  ucd: stat.covariance
  unit: mas^2/yr
- name: pmParallaxLnL
  type: FLOAT
  nullable: true
  description: Natural log of the likelihood of the linear proper motion parallax
    fit.
  ucd: stat.likelihood
- name: pmParallaxChi2
  type: FLOAT
  nullable: true
  description: Chi^2 static of the model fit.
  ucd: stat.fit.chi2
- name: pmParallaxNdata
  type: INT
  nullable: false
  description: The number of data points used to fit the model.
- name: uPSFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean point-source model magnitude for u filter.
  ucd: phot.count
  unit: nJy
- name: uPSFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of uPSFluxMean.
  ucd: stat.error
  unit: nJy
- name: uPSFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of uPSFlux.
  ucd: stat.stdev
  unit: nJy
- name: uPSFluxChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic for the scatter of uPSFlux around uPSFluxMean.
  ucd: stat.fit.chi2
- name: uPSFluxNdata
  type: INT
  nullable: false
  description: The number of data points used to compute uPSFluxChi2.
- name: uFPFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean forced photometry flux for u filter.
  ucd: phot.count
  unit: nJy
- name: uFPFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of uFPFluxMean.
  ucd: stat.error
  unit: nJy
- name: uFPFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of uFPFlux.
  ucd: stat.stdev
  unit: nJy
- name: gPSFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean point-source model magnitude for g filter.
  ucd: phot.count
  unit: nJy
- name: gPSFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of gPSFluxMean.
  ucd: stat.error
  unit: nJy
- name: gPSFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of gPSFlux.
  ucd: stat.stdev
  unit: nJy
- name: gPSFluxChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic for the scatter of gPSFlux around gPSFluxMean.
  ucd: stat.fit.chi2
- name: gPSFluxNdata
  type: INT
  nullable: false
  description: The number of data points used to compute gPSFluxChi2.
- name: gFPFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean forced photometry flux for g filter.
  ucd: phot.count
  unit: nJy
- name: gFPFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of gFPFluxMean.
  ucd: stat.error
  unit: nJy
- name: gFPFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of gFPFlux.
  ucd: stat.stdev
  unit: nJy
- name: rPSFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean point-source model magnitude for r filter.
  ucd: phot.count
  unit: nJy
- name: rPSFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of rPSFluxMean.
  ucd: stat.error
  unit: nJy
- name: rPSFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of rPSFlux.
  ucd: stat.stdev
  unit: nJy
- name: rPSFluxChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic for the scatter of rPSFlux around rPSFluxMean.
  ucd: stat.fit.chi2
- name: rPSFluxNdata
  type: INT
  nullable: false
  description: The number of data points used to compute rPSFluxChi2.
- name: rFPFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean forced photometry flux for r filter.
  ucd: phot.count
  unit: nJy
- name: rFPFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of rFPFluxMean.
  ucd: stat.error
  unit: nJy
- name: rFPFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of rFPFlux.
  ucd: stat.stdev
  unit: nJy
- name: iPSFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean point-source model magnitude for i filter.
  ucd: phot.count
  unit: nJy
- name: iPSFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of iPSFluxMean.
  ucd: stat.error
  unit: nJy
- name: iPSFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of iPSFlux.
  ucd: stat.stdev
  unit: nJy
- name: iPSFluxChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic for the scatter of iPSFlux around iPSFluxMean.
  ucd: stat.fit.chi2
- name: iPSFluxNdata
  type: INT
  nullable: false
  description: The number of data points used to compute iPSFluxChi2.
- name: iFPFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean forced photometry flux for i filter.
  ucd: phot.count
  unit: nJy
- name: iFPFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of iFPFluxMean.
  ucd: stat.error
  unit: nJy
- name: iFPFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of iFPFlux.
  ucd: stat.stdev
  unit: nJy
- name: zPSFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean point-source model magnitude for z filter.
  ucd: phot.count
  unit: nJy
- name: zPSFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of zPSFluxMean.
  ucd: stat.error
  unit: nJy
- name: zPSFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of zPSFlux.
  ucd: stat.stdev
  unit: nJy
- name: zPSFluxChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic for the scatter of zPSFlux around zPSFluxMean.
  ucd: stat.fit.chi2
- name: zPSFluxNdata
  type: INT
  nullable: false
  description: The number of data points used to compute zPSFluxChi2.
- name: zFPFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean forced photometry flux for z filter.
  ucd: phot.count
  unit: nJy
- name: zFPFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of zFPFluxMean.
  ucd: stat.error
  unit: nJy
- name: zFPFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of zFPFlux.
  ucd: stat.stdev
  unit: nJy
- name: yPSFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean point-source model magnitude for y filter.
  ucd: phot.count
  unit: nJy
- name: yPSFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of yPSFluxMean.
  ucd: stat.error
  unit: nJy
- name: yPSFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of yPSFlux.
  ucd: stat.error
  unit: nJy
- name: yPSFluxChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic for the scatter of yPSFlux around yPSFluxMean.
  ucd: stat.fit.chi2
- name: yPSFluxNdata
  type: INT
  nullable: false
  description: The number of data points used to compute yPSFluxChi2.
- name: yFPFluxMean
  type: FLOAT
  nullable: true
  description: Weighted mean forced photometry flux for y filter.
  ucd: phot.count
  unit: nJy
- name: yFPFluxMeanErr
  type: FLOAT
  nullable: true
  description: Standard error of yFPFluxMean.
  ucd: stat.error
  unit: nJy
- name: yFPFluxSigma
  type: FLOAT
  nullable: true
  description: Standard deviation of the distribution of yFPFlux.
  ucd: stat.stdev
  unit: nJy
- name: uLcPeriodic
  type: BLOB
  nullable: true
  description: Periodic features extracted from light-curves using generalized Lomb-Scargle
    periodogram for u filter. [32 FLOAT].
- name: gLcPeriodic
  type: BLOB
  nullable: true
  description: Periodic features extracted from light-curves using generalized Lomb-Scargle
    periodogram for g filter. [32 FLOAT].
- name: rLcPeriodic
  type: BLOB
  nullable: true
  description: Periodic features extracted from light-curves using generalized Lomb-Scargle
    periodogram for r filter. [32 FLOAT].
- name: iLcPeriodic
  type: BLOB
  nullable: true
  description: Periodic features extracted from light-curves using generalized Lomb-Scargle
    periodogram for i filter. [32 FLOAT].
- name: zLcPeriodic
  type: BLOB
  nullable: true
  description: Periodic features extracted from light-curves using generalized Lomb-Scargle
    periodogram for z filter. [32 FLOAT].
- name: yLcPeriodic
  type: BLOB
  nullable: true
  description: Periodic features extracted from light-curves using generalized Lomb-Scargle
    periodogram for y filter. [32 FLOAT].
- name: uLcNonPeriodic
  type: BLOB
  nullable: true
  description: Non-periodic features extracted from light-curves using generalized
    Lomb-Scargle periodogram for u filter. [20 FLOAT].
- name: gLcNonPeriodic
  type: BLOB
  nullable: true
  description: Non-periodic features extracted from light-curves using generalized
    Lomb-Scargle periodogram for g filter. [20 FLOAT].
- name: rLcNonPeriodic
  type: BLOB
  nullable: true
  description: Non-periodic features extracted from light-curves using generalized
    Lomb-Scargle periodogram for r filter. [20 FLOAT].
- name: iLcNonPeriodic
  type: BLOB
  nullable: true
  description: Non-periodic features extracted from light-curves using generalized
    Lomb-Scargle periodogram for i filter. [20 FLOAT].
- name: zLcNonPeriodic
  type: BLOB
  nullable: true
  description: Non-periodic features extracted from light-curves using generalized
    Lomb-Scargle periodogram for z filter. [20 FLOAT].
- name: yLcNonPeriodic
  type: BLOB
  nullable: true
  description: Non-periodic features extracted from light-curves using generalized
    Lomb-Scargle periodogram for y filter. [20 FLOAT].
- name: nearbyObj1
  type: BIGINT
  nullable: false
  description: Id of the closest nearby object.
  ucd: meta.id;src
- name: nearbyObj1Dist
  type: FLOAT
  nullable: true
  description: Distance to nearbyObj1.
  unit: arcsec
- name: nearbyObj1LnP
  type: FLOAT
  nullable: true
  description: Natural log of the probability that the observed diaObject is the same
    as the nearbyObj1.
- name: nearbyObj2
  type: BIGINT
  nullable: false
  description: Id of the second-closest nearby object.
  ucd: meta.id;src
- name: nearbyObj2Dist
  type: FLOAT
  nullable: true
  description: Distance to nearbyObj2.
  unit: arcsec
- name: nearbyObj2LnP
  type: FLOAT
  nullable: true
  description: Natural log of the probability that the observed diaObject is the same
    as the nearbyObj2.
- name: nearbyObj3
  type: BIGINT
  nullable: false
  description: Id of the third-closest nearby object.
  ucd: meta.id;src
- name: nearbyObj3Dist
  type: FLOAT
  nullable: true
  description: Distance to nearbyObj3.
  unit: arcsec
- name: nearbyObj3LnP
  type: FLOAT
  nullable: true
  description: Natural log of the probability that the observed diaObject is the same
    as the nearbyObj3.
- name: flags
  type: BIGINT
  nullable: false
  default: '0'
  description: Flags, bitwise OR tbd.
  ucd: meta.code
- name: pixelId
  type: BIGINT
  nullable: false
  description: HTM index.
indices:
- name: PK_DiaObject
  columns:
  - diaObjectId
  - validityStart
  type: PRIMARY
- name: IDX_DiaObject_valStart
  columns:
  - validityStart
  type: INDEX
- name: IDX_DiaObject_htmId20
  columns:
  - pixelId
  type: INDEX
---
table: SSObject
description: The SSObject table contains description of the Solar System (moving)
  Objects.
columns:
- name: ssObjectId
  type: BIGINT
  nullable: false
  description: Unique identifier.
  ucd: meta.id;src
- name: q
  type: DOUBLE
  nullable: true
  description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
- name: qErr
  type: DOUBLE
  nullable: true
  description: Uncertainty of q.
  ucd: stat.error
- name: e
  type: DOUBLE
  nullable: true
  description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
- name: eErr
  type: DOUBLE
  nullable: true
  description: Uncertainty of e.
  ucd: stat.error
- name: i
  type: DOUBLE
  nullable: true
  description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
- name: iErr
  type: DOUBLE
  nullable: true
  description: Uncertainty of i.
  ucd: stat.error
- name: lan
  type: DOUBLE
  nullable: true
  description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
- name: lanErr
  type: DOUBLE
  nullable: true
  description: Uncertainty of lan.
  ucd: stat.error
- name: aop
  type: DOUBLE
  nullable: true
  description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
- name: aopErr
  type: DOUBLE
  nullable: true
  description: Uncertainty of aop.
  ucd: stat.error
- name: M
  type: DOUBLE
  nullable: true
  description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
- name: MErr
  type: DOUBLE
  nullable: true
  description: Uncertainty of M.
  ucd: stat.error
- name: epoch
  type: DOUBLE
  nullable: true
  description: Osculating orbital elements at epoch (q, e, i, lan, aop, M, epoch).
- name: epochErr
  type: DOUBLE
  nullable: true
  description: Uncertainty of epoch.
  ucd: stat.error
- name: q_e_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of q and e.
  ucd: stat.covariance
- name: q_i_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of q and i.
  ucd: stat.covariance
- name: q_lan_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of q and lan.
  ucd: stat.covariance
- name: q_aop_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of q and aop.
  ucd: stat.covariance
- name: q_M_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of q and M.
  ucd: stat.covariance
- name: q_epoch_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of q and epoch.
  ucd: stat.covariance
- name: e_i_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of e and i.
  ucd: stat.covariance
- name: e_lan_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of e and lan.
  ucd: stat.covariance
- name: e_aop_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of e and aop.
  ucd: stat.covariance
- name: e_M_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of e and M.
  ucd: stat.covariance
- name: e_epoch_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of e and epoch.
  ucd: stat.covariance
- name: i_lan_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of i and lan.
  ucd: stat.covariance
- name: i_aop_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of i and aop.
  ucd: stat.covariance
- name: i_M_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of i and M.
  ucd: stat.covariance
- name: i_epoch_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of i and epoch.
  ucd: stat.covariance
- name: lan_aop_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of lan and aop.
  ucd: stat.covariance
- name: lan_M_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of lan and M.
  ucd: stat.covariance
- name: lan_epoch_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of lan and epoch.
  ucd: stat.covariance
- name: aop_M_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of aop and M.
  ucd: stat.covariance
- name: aop_epoch_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of aop and epoch.
  ucd: stat.covariance
- name: M_epoch_Cov
  type: DOUBLE
  nullable: true
  description: Covariance of M and epoch.
  ucd: stat.covariance
- name: arc
  type: FLOAT
  nullable: true
  description: Arc of observation.
  unit: days
- name: orbFitLnL
  type: FLOAT
  nullable: true
  description: Natural log of the likelihood of the orbital elements fit.
  ucd: stat.likelihood
- name: orbFitChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic of the orbital elements fit.
  ucd: stat.fit.chi2
- name: orbFitNdata
  type: INTEGER
  nullable: false
  description: Number of observations used in the fit.
- name: MOID1
  type: FLOAT
  nullable: true
  description: Minimum orbit intersection distance.
  unit: AU
- name: MOID2
  type: FLOAT
  nullable: true
  description: Minimum orbit intersection distance.
  unit: AU
- name: moidLon1
  type: DOUBLE
  nullable: true
  description: MOID longitudes.
  unit: deg
- name: moidLon2
  type: DOUBLE
  nullable: true
  description: MOID longitudes.
  unit: deg
- name: uH
  type: FLOAT
  nullable: true
  description: Mean absolute magnitude for u filter.
  unit: mag
- name: uHErr
  type: FLOAT
  nullable: true
  description: Uncertainty of uH estimate.
  ucd: stat.error
  unit: mag
- name: uG1
  type: FLOAT
  nullable: true
  description: Fitted G1 slope parameter for u filter.
  unit: mag
- name: uG1Err
  type: FLOAT
  nullable: true
  description: Uncertainty of uG1 estimate.
  ucd: stat.error
  unit: mag
- name: uG2
  type: FLOAT
  nullable: true
  description: Fitted G2 slope parameter for u filter.
  unit: mag
- name: uG2Err
  type: FLOAT
  nullable: true
  description: Uncertainty of uG2 estimate.
  ucd: stat.error
  unit: mag
- name: gH
  type: FLOAT
  nullable: true
  description: Mean absolute magnitude for g filter.
  unit: mag
- name: gHErr
  type: FLOAT
  nullable: true
  description: Uncertainty of gH estimate.
  ucd: stat.error
  unit: mag
- name: gG1
  type: FLOAT
  nullable: true
  description: Fitted G1 slope parameter for g filter.
  unit: mag
- name: gG1Err
  type: FLOAT
  nullable: true
  description: Uncertainty of gG1 estimate.
  ucd: stat.error
  unit: mag
- name: gG2
  type: FLOAT
  nullable: true
  description: Fitted G2 slope parameter for g filter.
  unit: mag
- name: gG2Err
  type: FLOAT
  nullable: true
  description: Uncertainty of gG2 estimate.
  ucd: stat.error
  unit: mag
- name: rH
  type: FLOAT
  nullable: true
  description: Mean absolute magnitude for r filter.
  unit: mag
- name: rHErr
  type: FLOAT
  nullable: true
  description: Uncertainty of rH estimate.
  ucd: stat.error
  unit: mag
- name: rG1
  type: FLOAT
  nullable: true
  description: Fitted G1 slope parameter for r filter.
  unit: mag
- name: rG1Err
  type: FLOAT
  nullable: true
  description: Uncertainty of rG1 estimate.
  ucd: stat.error
  unit: mag
- name: rG2
  type: FLOAT
  nullable: true
  description: Fitted G2 slope parameter for r filter.
  unit: mag
- name: rG2Err
  type: FLOAT
  nullable: true
  description: Uncertainty of rG2 estimate.
  ucd: stat.error
  unit: mag
- name: iH
  type: FLOAT
  nullable: true
  description: Mean absolute magnitude for i filter.
  unit: mag
- name: iHErr
  type: FLOAT
  nullable: true
  description: Uncertainty of iH estimate.
  ucd: stat.error
  unit: mag
- name: iG1
  type: FLOAT
  nullable: true
  description: Fitted G1 slope parameter for i filter.
  unit: mag
- name: iG1Err
  type: FLOAT
  nullable: true
  description: Uncertainty of iG1 estimate.
  ucd: stat.error
  unit: mag
- name: iG2
  type: FLOAT
  nullable: true
  description: Fitted G2 slope parameter for i filter.
  unit: mag
- name: iG2Err
  type: FLOAT
  nullable: true
  description: Uncertainty of iG2 estimate.
  ucd: stat.error
  unit: mag
- name: zH
  type: FLOAT
  nullable: true
  description: Mean absolute magnitude for z filter.
  unit: mag
- name: zHErr
  type: FLOAT
  nullable: true
  description: Uncertainty of zH estimate.
  ucd: stat.error
  unit: mag
- name: zG1
  type: FLOAT
  nullable: true
  description: Fitted G1 slope parameter for z filter.
  unit: mag
- name: zG1Err
  type: FLOAT
  nullable: true
  description: Uncertainty of zG1 estimate.
  ucd: stat.error
  unit: mag
- name: zG2
  type: FLOAT
  nullable: true
  description: Fitted G2 slope parameter for z filter.
  unit: mag
- name: zG2Err
  type: FLOAT
  nullable: true
  description: Uncertainty of zG2 estimate.
  ucd: stat.error
  unit: mag
- name: yH
  type: FLOAT
  nullable: true
  description: Mean absolute magnitude for y filter.
  unit: mag
- name: yHErr
  type: FLOAT
  nullable: true
  description: Uncertainty of yH estimate.
  ucd: stat.error
  unit: mag
- name: yG1
  type: FLOAT
  nullable: true
  description: Fitted G1 slope parameter for y filter.
  unit: mag
- name: yG1Err
  type: FLOAT
  nullable: true
  description: Uncertainty of yG1 estimate.
  ucd: stat.error
  unit: mag
- name: yG2
  type: FLOAT
  nullable: true
  description: Fitted G2 slope parameter for y filter.
  unit: mag
- name: yG2Err
  type: FLOAT
  nullable: true
  description: Uncertainty of yG2 estimate.
  ucd: stat.error
  unit: mag
- name: flags
  type: BIGINT
  nullable: false
  default: '0'
  description: Flags, bitwise OR tbd.
  ucd: meta.code
indices:
- name: PK_SSObject
  columns:
  - ssObjectId
  type: PRIMARY
---
table: DiaSource
description: Table to store 'difference image sources'; - sources detected at SNR
  >=5 on difference images.
columns:
- name: diaSourceId
  type: BIGINT
  nullable: false
  description: Unique id.
  ucd: meta.id;obs.image
- name: ccdVisitId
  type: BIGINT
  nullable: false
  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.
  ucd: meta.id;obs.image
- name: diaObjectId
  type: BIGINT
  nullable: false
  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).
  ucd: meta.id;src
- name: ssObjectId
  type: BIGINT
  nullable: false
  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).
  ucd: meta.id;src
- name: parentDiaSourceId
  type: BIGINT
  nullable: false
  description: Id of the parent diaSource this diaSource has been deblended from,
    if any.
  ucd: meta.id;src
- name: prv_procOrder
  type: INT
  nullable: false
  description: Position of this diaSource in the processing order relative to other
    diaSources within a given diaObjectId or ssObjectId.
- name: ssObjectReassocTime
  type: DATETIME
  nullable: true
  description: Time when this diaSource was reassociated from diaObject to ssObject
    (if such reassociation happens, otherwise NULL).
- name: midPointTai
  type: DOUBLE
  nullable: false
  description: Effective mid-exposure time for this diaSource.
  ucd: time.epoch
  unit: d
- name: ra
  type: DOUBLE
  nullable: false
  description: RA-coordinate of the center of this diaSource.
  ucd: pos.eq.ra
  unit: deg
- name: raErr
  type: FLOAT
  nullable: true
  description: Uncertainty of ra.
  ucd: stat.error;pos.eq.ra
  unit: deg
- name: decl
  type: DOUBLE
  nullable: false
  description: ' Decl-coordinate of the center of this diaSource.'
  ucd: pos.eq.dec
  unit: deg
- name: declErr
  type: FLOAT
  nullable: true
  description: Uncertainty of decl.
  ucd: stat.error;pos.eq.dec
  unit: deg
- name: ra_decl_Cov
  type: FLOAT
  nullable: true
  description: Covariance between ra and decl.
  ucd: stat.covariance
  unit: deg^2
- name: x
  type: FLOAT
  nullable: false
  description: x position computed by a centroiding algorithm.
  ucd: pos.cartesian.x
  unit: pixel
- name: xErr
  type: FLOAT
  nullable: true
  description: Uncertainty of x.
  ucd: stat.error:pos.cartesian.x
  unit: pixel
- name: y
  type: FLOAT
  nullable: false
  description: y position computed by a centroiding algorithm.
  ucd: pos.cartesian.y
  unit: pixel
- name: yErr
  type: FLOAT
  nullable: true
  description: Uncertainty of y.
  ucd: stat.error:pos.cartesian.y
  unit: pixel
- name: x_y_Cov
  type: FLOAT
  nullable: true
  description: Covariance between x and y.
  ucd: stat.covariance
  unit: pixel^2
- name: apFlux
  type: FLOAT
  nullable: true
  description: Calibrated aperture flux. Note that this actually measures the difference
    between the template and the visit image.
  ucd: phot.count
  unit: nJy
- name: apFluxErr
  type: FLOAT
  nullable: true
  description: Estimated uncertainty of apFlux.
  ucd: stat.error;phot.count
  unit: nJy
- name: snr
  type: FLOAT
  nullable: true
  description: The signal-to-noise ratio at which this source was detected in the
    difference image.
  ucd: stat.snr
- name: psFlux
  type: FLOAT
  nullable: true
  description: Calibrated flux for Point Source model. Note this actually measures
    the flux difference between the template and the visit image.
  ucd: phot.count
  unit: nJy
- name: psFluxErr
  type: FLOAT
  nullable: true
  description: Uncertainty of psFlux.
  unit: nJy
- name: psRa
  type: DOUBLE
  nullable: true
  description: ' RA-coordinate of centroid for point source model.'
  ucd: pos.eq.ra
  unit: deg
- name: psRaErr
  type: FLOAT
  nullable: true
  description: Uncertainty of psRa.
  ucd: stat.error;pos.eq.ra
  unit: deg
- name: psDecl
  type: DOUBLE
  nullable: true
  description: ' Decl-coordinate of centroid for point source model.'
  ucd: pos.eq.dec
  unit: deg
- name: psDeclErr
  type: FLOAT
  nullable: true
  description: Uncertainty of psDecl.
  ucd: stat.error;pos.eq.dec
  unit: deg
- name: psFlux_psRa_Cov
  type: FLOAT
  nullable: true
  description: Covariance between psFlux and psRa.
  ucd: stat.covariance
  unit: ngmy*deg
- name: psFlux_psDecl_Cov
  type: FLOAT
  nullable: true
  description: Covariance between psFlux and psDecl.
  ucd: stat.covariance
  unit: ngmy*deg
- name: psRa_psDecl_Cov
  type: FLOAT
  nullable: true
  description: Covariance between psRa and psDecl.
  ucd: stat.covariance
  unit: deg^2
- name: psLnL
  type: FLOAT
  nullable: true
  description: Natural log likelihood of the observed data given the Point Source
    model.
  ucd: stat.likelihood
- name: psChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic of the model fit.
  ucd: stat.fit.chi2
- name: psNdata
  type: INT
  nullable: false
  description: The number of data points (pixels) used to fit the model.
- name: trailFlux
  type: FLOAT
  nullable: true
  description: Calibrated flux for a trailed source model. Note this actually measures
    the flux difference between the template and the visit image.
  unit: nJy
- name: trailFluxErr
  type: FLOAT
  nullable: true
  description: Uncertainty of trailFlux.
  unit: nJy
- name: trailRa
  type: DOUBLE
  nullable: true
  description: ' RA-coordinate of centroid for trailed source model.'
  ucd: pos.eq.ra
  unit: deg
- name: trailRaErr
  type: FLOAT
  nullable: true
  description: Uncertainty of trailRa.
  ucd: stat.error;pos.eq.ra
  unit: deg
- name: trailDecl
  type: DOUBLE
  nullable: true
  description: ' Decl-coordinate of centroid for trailed source model.'
  ucd: pos.eq.dec
  unit: deg
- name: trailDeclErr
  type: FLOAT
  nullable: true
  description: Uncertainty of trailDecl.
  ucd: stat.error;pos.eq.dec
  unit: deg
- name: trailLength
  type: FLOAT
  nullable: true
  description: Maximum likelihood fit of trail length.
  unit: arcsec
- name: trailLengthErr
  type: FLOAT
  nullable: true
  description: Uncertainty of trailLength.
  unit: nJy
- name: trailAngle
  type: FLOAT
  nullable: true
  description: Maximum likelihood fit of the angle between the meridian through the
    centroid and the trail direction (bearing).
  unit: deg
- name: trailAngleErr
  type: FLOAT
  nullable: true
  description: Uncertainty of trailAngle.
  unit: nJy
- name: trailFlux_trailRa_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailFlux and trailRa.
  ucd: stat.covariance
- name: trailFlux_trailDecl_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailFlux and trailDecl.
  ucd: stat.covariance
- name: trailFlux_trailLength_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailFlux and trailLength
  ucd: stat.covariance
- name: trailFlux_trailAngle_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailFlux and trailAngle
  ucd: stat.covariance
- name: trailRa_trailDecl_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailRa and trailDecl.
  ucd: stat.covariance
- name: trailRa_trailLength_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailRa and trailLength.
  ucd: stat.covariance
- name: trailRa_trailAngle_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailRa and trailAngle.
  ucd: stat.covariance
- name: trailDecl_trailLength_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailDecl and trailLength.
  ucd: stat.covariance
- name: trailDecl_trailAngle_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailDecl and trailAngle.
  ucd: stat.covariance
- name: trailLength_trailAngle_Cov
  type: FLOAT
  nullable: true
  description: Covariance of trailLength and trailAngle
  ucd: stat.covariance
- name: trailLnL
  type: FLOAT
  nullable: true
  description: Natural log likelihood of the observed data given the trailed source
    model.
  ucd: stat.likelihood
- name: trailChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic of the model fit.
  ucd: stat.fit.chi2
- name: trailNdata
  type: INT
  nullable: false
  description: The number of data points (pixels) used to fit the model.
- name: dipMeanFlux
  type: FLOAT
  nullable: true
  description: Maximum likelihood value for the mean absolute flux of the two lobes
    for a dipole model.
  unit: nJy
- name: dipMeanFluxErr
  type: FLOAT
  nullable: true
  description: Uncertainty of dipMeanFlux.
  ucd: stat.error
  unit: nJy
- name: dipFluxDiff
  type: FLOAT
  nullable: true
  description: Maximum likelihood value for the difference of absolute fluxes of the
    two lobes for a dipole model.
  unit: nJy
- name: dipFluxDiffErr
  type: FLOAT
  nullable: true
  description: Uncertainty of dipFluxDiff.
  ucd: stat.error
  unit: nJy
- name: dipRa
  type: DOUBLE
  nullable: true
  description: ' RA-coordinate of centroid for dipole model.'
  ucd: pos.eq.ra
  unit: deg
- name: dipRaErr
  type: FLOAT
  nullable: true
  description: Uncertainty of trailRa.
  ucd: stat.error;pos.eq.ra
  unit: deg
- name: dipDecl
  type: DOUBLE
  nullable: true
  description: ' Decl-coordinate of centroid for dipole model.'
  ucd: pos.eq.dec
  unit: deg
- name: dipDeclErr
  type: FLOAT
  nullable: true
  description: Uncertainty of dipDecl.
  ucd: stat.error;pos.eq.dec
  unit: deg
- name: dipLength
  type: FLOAT
  nullable: true
  description: Maximum likelihood value for the lobe separation in dipole model.
  ucd: pos.angDistance
  unit: arcsec
- name: dipLengthErr
  type: FLOAT
  nullable: true
  description: Uncertainty of dipLength.
  ucd: stat.error;pos.angDistance
  unit: arcsec
- name: dipAngle
  type: FLOAT
  nullable: true
  description: Maximum likelihood fit of the angle between the meridian through the
    centroid and the dipole direction (bearing, from negative to positive lobe).
  ucd: pos.posAng
  unit: deg
- name: dipAngleErr
  type: FLOAT
  nullable: true
  description: Uncertainty of dipAngle.
  ucd: stat.error;pos.posAng
  unit: deg
- name: dipMeanFlux_dipFluxDiff_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipMeanFlux and dipFluxDiff.
  ucd: stat.covariance
- name: dipMeanFlux_dipRa_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipMeanFlux and dipRa.
  ucd: stat.covariance
- name: dipMeanFlux_dipDecl_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipMeanFlux and dipDecl.
  ucd: stat.covariance
- name: dipMeanFlux_dipLength_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipMeanFlux and dipLength.
  ucd: stat.covariance
- name: dipMeanFlux_dipAngle_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipMeanFlux and dipAngle.
  ucd: stat.covariance
- name: dipFluxDiff_dipRa_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipFluxDiff and dipRa.
  ucd: stat.covariance
- name: dipFluxDiff_dipDecl_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipFluxDiff and dipDecl.
  ucd: stat.covariance
- name: dipFluxDiff_dipLength_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipFluxDiff and dipLength.
  ucd: stat.covariance
- name: dipFluxDiff_dipAngle_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipFluxDiff and dipAngle.
  ucd: stat.covariance
- name: dipRa_dipDecl_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipRa and dipDecl.
  ucd: stat.covariance
- name: dipRa_dipLength_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipRa and dipLength.
  ucd: stat.covariance
- name: dipRa_dipAngle_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipRa and dipAngle.
  ucd: stat.covariance
- name: dipDecl_dipLength_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipDecl and dipLength.
  ucd: stat.covariance
- name: dipDecl_dipAngle_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipDecl and dipAngle.
  ucd: stat.covariance
- name: dipLength_dipAngle_Cov
  type: FLOAT
  nullable: true
  description: Covariance of dipLength and dipAngle.
  ucd: stat.covariance
- name: dipLnL
  type: FLOAT
  nullable: true
  description: Natural log likelihood of the observed data given the dipole source
    model.
  ucd: stat.likelihood
- name: dipChi2
  type: FLOAT
  nullable: true
  description: Chi^2 statistic of the model fit.
  ucd: stat.fit.chi2
- name: dipNdata
  type: INT
  nullable: false
  description: The number of data points (pixels) used to fit the model.
- name: totFlux
  type: FLOAT
  nullable: true
  description: Calibrated flux for Point Source model measured on the visit image
    centered at the centroid measured on the difference image (forced photometry flux).
  ucd: phot.count
  unit: nJy
- name: totFluxErr
  type: FLOAT
  nullable: true
  description: Estimated uncertainty of totFlux.
  ucd: stat.error;phot.count
  unit: nJy
- name: diffFlux
  type: FLOAT
  nullable: true
  description: Calibrated flux for Point Source model centered on radec but measured
    on the difference of snaps comprising this visit.
  unit: nJy
- name: diffFluxErr
  type: FLOAT
  nullable: true
  description: Estimated uncertainty of diffFlux.
  ucd: stat.error;phot.count
  unit: nJy
- name: fpBkgd
  type: FLOAT
  nullable: true
  description: Estimated sky background at the position (centroid) of the object.
  unit: nJy/asec^2
- name: fpBkgdErr
  type: FLOAT
  nullable: true
  description: Estimated uncertainty of fpBkgd.
  unit: nJy/asec^2
- name: ixx
  type: FLOAT
  nullable: true
  description: Adaptive second moment of the source intensity.
  unit: nJy*asec^2
- name: ixxErr
  type: FLOAT
  nullable: true
  description: Uncertainty of ixx.
  ucd: stat.error
  unit: nJy*asec^2
- name: iyy
  type: FLOAT
  nullable: true
  description: Adaptive second moment of the source intensity.
  unit: nJy*asec^2
- name: iyyErr
  type: FLOAT
  nullable: true
  description: Uncertainty of iyy.
  ucd: stat.error
  unit: nJy*asec^2
- name: ixy
  type: FLOAT
  nullable: true
  description: Adaptive second moment of the source intensity.
  unit: nJy*asec^2
- name: ixyErr
  type: FLOAT
  nullable: true
  description: Uncertainty of ixy.
  ucd: stat.error
  unit: nJy*asec^2
- name: ixx_iyy_Cov
  type: FLOAT
  nullable: true
  description: Covariance of ixx and iyy.
  unit: nJy^2*asec^4
- name: ixx_ixy_Cov
  type: FLOAT
  nullable: true
  description: Covariance of ixx and ixy.
  unit: nJy^2*asec^4
- name: iyy_ixy_Cov
  type: FLOAT
  nullable: true
  description: Covariance of iyy and ixy.
  unit: nJy^2*asec^4
- name: ixxPSF
  type: FLOAT
  nullable: true
  description: Adaptive second moment for the PSF.
  unit: nJy*asec^2
- name: iyyPSF
  type: FLOAT
  nullable: true
  description: Adaptive second moment for the PSF.
  unit: nJy*asec^2
- name: ixyPSF
  type: FLOAT
  nullable: true
  description: Adaptive second moment for the PSF.
  unit: nJy*asec^2
- name: extendedness
  type: FLOAT
  nullable: true
  description: A measure of extendedness, Computed using a combination of available
    moments and model fluxes or from a likelihood ratio of point/trailed source models
    (exact algorithm TBD). extendedness = 1 implies a high degree of confidence that
    the source is extended. extendedness = 0 implies a high degree of confidence that
    the source is point-like.
- name: spuriousness
  type: FLOAT
  nullable: true
  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.).
- name: flags
  type: BIGINT
  nullable: false
  default: '0'
  description: Flags, bitwise OR tbd.
  ucd: meta.code
- name: pixelId
  type: BIGINT
  nullable: false
  description: HTM index.
indices:
- name: PK_DiaSource
  columns:
  - diaSourceId
  type: PRIMARY
- name: IDX_DiaSource_ccdVisitId
  columns:
  - ccdVisitId
  type: INDEX
- name: IDX_DiaSource_diaObjId
  columns:
  - diaObjectId
  type: INDEX
- name: IDX_DiaSource_ssObjId
  columns:
  - ssObjectId
  type: INDEX
- name: IDX_DiaSource_htmId20
  columns:
  - pixelId
  type: INDEX
---
table: 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
  type: BIGINT
  nullable: false
  ucd: meta.id;src
- name: ccdVisitId
  type: BIGINT
  nullable: false
  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.
  ucd: meta.id;obs.image
- name: psFlux
  type: FLOAT
  nullable: true
  description: Point Source model flux.
  ucd: phot.count
  unit: nJy
- name: psFluxErr
  type: FLOAT
  nullable: true
  description: Uncertainty of psFlux.
  ucd: stat.error;phot.count
  unit: nJy
- name: x
  type: FLOAT
  nullable: true
  description: x position at which psFlux has been measured.
  ucd: pos.cartesian.x
  unit: pixel
- name: y
  type: FLOAT
  nullable: true
  description: y position at which psFlux has been measured.
  ucd: pos.cartesian.y
  unit: pixel
- name: flags
  type: BIGINT
  nullable: false
  default: '0'
  description: Flags, bitwise OR tbd
  ucd: meta.code
indices:
- name: PK_DiaForcedSource
  columns:
  - diaObjectId
  - ccdVisitId
  type: PRIMARY
- name: IDX_DiaFSource_ccdVisitId
  columns:
  - ccdVisitId
  type: INDEX
---
table: DiaObject_To_Object_Match
description: The table stores mapping of diaObjects to the nearby objects.
columns:
- name: diaObjectId
  type: BIGINT
  nullable: false
  description: Id of diaObject.
  ucd: meta.id;src
- name: objectId
  type: BIGINT
  nullable: false
  description: Id of a nearby object.
  ucd: meta.id;src
- name: dist
  type: FLOAT
  nullable: true
  description: The distance between the diaObject and the object.
  unit: arcsec
- name: lnP
  type: FLOAT
  nullable: true
  description: Natural log of the probability that the observed diaObject is the same
    as the nearby object.
indices:
- name: IDX_DiaO2OMatch_diaObjId
  columns:
  - diaObjectId
  type: INDEX
- name: IDX_DiaO2OMatch_objectId
  columns:
  - objectId
  type: INDEX
