-
Type:
Bug
-
Status: Closed
-
Priority:
Should
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Adding patient_id to the orders table makes it more symmetrical with the obs table. It should not only increase DB performance (less joining required), but also, since encounter_id is nullable, allow you to associate an order directly with a patient. This in turn should reduce the likelihood of an order that has no relationship with a patient (as would be the case otherwise, if encounter_id is null).