| Issue 26: | Data in dbDay table is incorrect |
‹ Prev
26 of 26
|
| 1 person starred this issue and may be notified of changes. | Back to list |
The test data entered into the dbDay table in revision116 represents the relationship with dbshifts incorrectly. The shift column contains the key of one shift. But a given day will have lots of shifts. The relationship is one to many, not one to one. Normally, we would put a foreign key in the shifts table pointing back to dbday. But the Homebase code did it differently, and it is safest to follow their lead. They put a *list* of shift ids into their dbdate table, and then use that list whenever retrieving shifts. A screenshot of the RMHHomebase dbDates table is attached. Please modify the data in the shift column of dbday to refer to shift records in the same way. Note - since the key of a shift will contain the clinician, we may need to retrieve by date instead.
Apr 30, 2014
Project Member
#1
ntrif...@gmail.com
Apr 30, 2014
pulling the discussion to Piazza because this affects a lot of code |