hmis-tools / hmis-api-server

Version 2 of OpenHMIS
Mozilla Public License 2.0
15 stars 11 forks source link

Add Foreign Key Constraints to Test Schema #33

Open steveconners opened 9 years ago

steveconners commented 9 years ago

[from @ashaar364 - a second issue from #29] We should have relationships in the system. Having foreign key constrain in the system makes the API code different and we have less code to write. What type of advantage we are getting by removing the relationship? (@steveconners response: the only benefit is that we have not had the time to add this. There is a further consideration that our goal is to move from this schema to the OpenHMIS2 schema developed for this purpose. HOWEVER, I expect that change will take long enough that we would reap some benefit from adding the relationships here.)