Ticket #406 (closed enhancement: worksforme)
Merging MOPS schema into EA
Reported by: | jbecla | Owned by: | fpierfed |
---|---|---|---|
Priority: | normal | Milestone: | |
Component: | dbSchema | Keywords: | |
Cc: | Blocked By: | ||
Blocking: | #499, #500 | Project: | LSST |
Version Number: | |||
How to repeat: |
not applicable |
Description (last modified by fpierfed) (diff)
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.
Change History
comment:1 in reply to: ↑ description Changed 11 years ago by fpierfed
- Owner changed from fpierfed to jbecla
- Status changed from new to assigned
comment:2 Changed 11 years ago by jbecla
- Owner changed from jbecla to smm
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.
comment:3 Changed 11 years ago by jbecla
- Milestone changed from DC3b Apps DB Schema to DC3a Apps DB Schema
comment:4 Changed 11 years ago by 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?
comment:5 Changed 11 years ago by jbecla
- Owner changed from smm to jbecla
The template tables (plus few others) were transfered from dc2 schema to dc3 schema.
comment:6 Changed 11 years ago by jbecla
- Owner changed from jbecla to fpierfed
Francesco, please check the schema and make appropriate adjustments in your code. The schema is in DMS/cat/trunk/sql/lsstSchema4mysql.sql
comment:9 Changed 11 years ago by fpierfed
- Status changed from assigned to closed
- Resolution set to worksforme
- Description modified (diff)
- reviewstatus changed from notReady to reviewed
comment:10 Changed 8 years ago by robyn
- Milestone DC3a Apps DB Schema deleted
Milestone DC3a Apps DB Schema deleted
Replying to jbecla:
Done
Done
Done
Done
Done
Done
Done