wiki:DbDC3bSchemaUpdates
Last modified 9 years ago Last modified on 02/24/2010 10:08:48 PM

Proposed DC3b schema

This schema is based on DC3bDataProducts.

Somewhat relevant, although now obsolete doc: dbSchemaUpdateApr09.

Note that we will also have SourceForMovingObject (same schema as Source table) and DiaSourceForMovingObject (same schema as DiaSource table).

We need to discuss whether to have ForcedSourceForMovingObject or ForcedDiaSourceForMovingObject. (From Lynne: "Yes, I definitely think so, since diaSources and Sources are only >5 sigma detections. For doing inverse lightcurve photometry, the user would also want to get measurements of the movingObjects where the detection was below 5 sigma (but above 3 sigma or something). The wrinkle here is that it is forced photometry on a position, where that position has some error. How exactly to implement doing this forced photometry on a position with an error I guess I would ask Robert Lupton to describe the best method. I guess this is however related to doing photometry after centroiding on the best location of the source/diaSource, so not so bad.")

CalibSource

See http://dev.lsstcorp.org/schema/index.php?sVer=DC3b&t=CalibSource


Source

See http://dev.lsstcorp.org/schema/index.php?sVer=DC3b&t=Source


DiaSource

See http://dev.lsstcorp.org/schema/index.php?sVer=DC3b&t=DiaSource


ForcedSource

See http://dev.lsstcorp.org/schema/index.php?sVer=DC3b&t=ForcedSource


ForcedDiaSource

See http://dev.lsstcorp.org/schema/index.php?sVer=DC3b&t=ForcedDiaSource


Object

Schema for Object table - see http://dev.lsstcorp.org/schema/index.php?sVer=DC3b&t=Object

  • Some queries, eg dbQuery010? need amplitude of variability (per filter), which we don't have at the moment. Tim checking with transient collaboration.
  • timescale - Tim is checking with Transient collaboration.

Exposure Related

See

    ExposureMetadata
	exposureId BIGINT,
	exposureType CHAR, -- or enum: rawAmp, postIsrAmp, postIsrCcd, scienceCcd, diffCcd, maybe more
	metadataKey VARCHAR(80) NOT NULL,
	metadataValue VARCHAR(255)

    ExecutionTrace
	pipelineName VARCHAR(20) NOT NULL,
	traceKey VARCHAR(80) NOT NULL,
	traceValue VARCHAR(255)
  • Will need non-gray extinction, special polynomials, etc,

About naming conventions

  • Make sure c++ adopts 'Sigma' naming conventions
  • What about variance (should we use 'Vrs' as proposed by TCT?)
  • moments (I think Robyn is ok with format momentIxx)
  • Amp vs Seg vs Segment
  • Rename CCD to Ccd
  • What about units in names, eg taiRange vs timeRange