Ticket #513 (closed enhancement: fixed)

Opened 10 years ago

Last modified 7 years ago

Revisit exposure metadata tables

Reported by: jbecla Owned by: jbecla
Priority: normal Milestone:
Component: dbSchema Keywords:
Cc: smm Blocked By:
Blocking: #460 Project: LSST
Version Number:
How to repeat:

not applicable

Description

Current version of DC3 schema contains exposure metadata tables transfered from the baseline schema, while we really need tables similar to these we had in DC2. Need to update these tables in DC3 schema without loosing the extra information that is in these tables now.

Change History

comment:1 Changed 10 years ago by jbecla

  • Status changed from new to assigned

comment:2 Changed 10 years ago by jbecla

  • Status changed from assigned to inTicketWork

comment:3 Changed 10 years ago by jbecla

This is mostly done (schema split into DC3a and DC3b). Still need to remove unused columns. To do that, I need access to lsst10 machine to check which columns DC2 was using

comment:4 Changed 10 years ago by jbecla

  • Status changed from inTicketWork to inStandardsReview
  • Owner changed from jbecla to smm

comment:5 follow-up: ↓ 6 Changed 10 years ago by smm

  • reviewstatus changed from notReady to reviewed

Looks good, though without unit tests for exposure persistence I can't be sure it'll work. One thing I noticed is that the DC2 schema contains a _Science_FPA_Exposure_Group table that isn't in DC3a - was this unused in DC2?

comment:6 in reply to: ↑ 5 Changed 10 years ago by jbecla

  • Owner changed from smm to jbecla
  • Status changed from inStandardsReview to inTrunkMerge

Replying to smm:

One thing I noticed is that the DC2 schema contains a _Science_FPA_Exposure_Group table that isn't in DC3a - was this unused in DC2?

Correct, it was unused.

comment:7 Changed 10 years ago by robyn

  • Status changed from inTrunkMerge to inQaReview
  • Owner changed from jbecla to robyn

Jacek says this ticket is ready to close.

comment:8 Changed 10 years ago by robyn

  • Status changed from inQaReview to closed
  • Resolution set to fixed

comment:9 Changed 10 years ago by robyn

  • Owner changed from robyn to jbecla

comment:10 Changed 7 years ago by robyn

  • Milestone DC3a Apps DB Schema deleted

Milestone DC3a Apps DB Schema deleted

Note: See TracTickets for help on using tickets.