Merging MOPS schema into EA

[jbecla]

We are not going to black-box integrate DayMOPS into DC3a but rather shoot for full integration of PS-MOPS with the LSST pipeline framework for DC3b.

For this reason, the proposed database schema is fine.

[fpierfed]

Replying to jbecla:

Need to merge MOPS schema into the baseline lsst schema.

Research and proposed changes done (by Serge). Initial merge in EA done (Jacek). Remaining tasks:

• Clarify VARCHAR BINARY (Francesco)

Done

• Clarify mops_Removals2Tracklets and mops_Attributions2Tracklets tables: do they provide one-to-one mappings? Might want to rename them (Francesco)

Done

• confirm whether renaming mops_History to mops_Event is ok (Francesco)

Done

• consider splitting mops_History into event type specific tables (Francesco)

Done

• identifications2MovingObject:childId: ok to rename to movingObjectId? (Francesco)

Done

• rename "status" columns. Suggestions: MovingObject.status --> MovingObject.mergedWithParent, DIASource.status --> DIASource.isDetected, _mops_EonQueue.status/mops_Tracklet.status --> processingStatus

Done

• ok to rename tables and change plural to singular? (Francesco)

Done

• Insert statements for mops_SSMDesc and prv_Filter: add to DC3 database initialization scripts (Serge)
• Implement in EA (Jacek)

[jbecla]

All changes done in EA, schema commited to DMS/cat/trunk/sql/lsstSchema4mysql.sql. Serge, please take care of "insert statements for mops_SSMDesc and prv_Filter: add to DC3 database initialization scripts (Serge)", then assign to Francesco for a final check.

[smm]

INSERT statements committed in [6255]. However, I notice that tables required by NightMOPS (as well as temp tables required by the association pipeline):

• are missing from the schema
• don't follow the naming conventions

In particular, there are two MOPS tables from DC2 we need to carry over: mops_pred (I suggest we rename this to mops_Prediction) and mops_ephem (-> mops_Ephemeris).

Do we want to introduce a special naming convention for tables used by pipelines to communicate to other pipelines or which are used internally?

[jbecla]

The template tables (plus few others) were transfered from dc2 schema to dc3 schema.

[jbecla]

Francesco, please check the schema and make appropriate adjustments in your code. The schema is in DMS/cat/trunk/sql/lsstSchema4mysql.sql

[robyn]

Milestone DC3a Apps DB Schema deleted