Currently, we have quite a bit of redundancy in the swag database - all 3 tables: studies, image_uris, and reports contain the same keys: 'PatientID', 'StudyInstanceUID', and 'AccessionNumber', additionally table annotations contains both 'StudyInstanceUID' and 'AccessionNumber' keys.
It seems for our purposes, 'AccessionNumber' is the key that joins all those tables together.
The proposed solution:
remove 'PatientID' and 'StudyInstanceUID' keys from reports
remove 'PatientID' and 'StudyInstanceUID' (or 'AccessionNumber', then one more join would be required) keys from image_uris
Feature Request
Currently, we have quite a bit of redundancy in the swag database - all 3 tables: studies, image_uris, and reports contain the same keys: 'PatientID', 'StudyInstanceUID', and 'AccessionNumber', additionally table annotations contains both 'StudyInstanceUID' and 'AccessionNumber' keys.
It seems for our purposes, 'AccessionNumber' is the key that joins all those tables together.
The proposed solution: