-
Type: Task
-
Status: Done (View Workflow)
-
Priority: Normal
-
Resolution: Done
-
Component/s: spt_operational_database
-
Labels:
I'd like to suggest that someone who knows about databases look at normalizing the current schema (https://github.com/Subaru-PFS/spt_operational_database/blob/master/pfs_schema.pdf).
In particular, I think the Target-DesignFiber-CobraConfig-ConfigFiber group could be cleaned up to where, roughly,:
- only Target has the object magnitude and targeting columns
- only CobraConfig has the center/diff/motor columns
- configFiber is basically a targetId, a designFiberId, and a designId.
- etc.
- relates to
-
INSTRM-764 Reconsider FiberPosition, CobraPosition, and FiducialFiberPosition tables
- Done
-
INSTRM-844 Additional updates to operational schema
- Done