Archive for the 'HealthTracker' Category

25
Oct

Initial DB Design

I have build an intial domain model.  I am just covering the very basics of what I want to track, and expect to get into tracking foods a little later.

HealthTracker DB Design

I decided to separate out blood sugar & pressure readings due to the nature of the beast.  Everything in Stats is measured at most once a day.  You would never think of taking hemoglobin A1C levels more than once every three months.  However, blood sugar levels are measured multiple times a day.  Also, it’s important to note what type of blood sugar reading it is: morning fasting, before a meal, after a meal, before bed, etc.

Also, the business intelligence guy in me started thinking about how I’d do reporting, and I whipped up a sample blood pressure chart.

Sample Blood Pressure Chart

Next on the agenda I’ll begin looking at actually writing code for these parts of the domain model, and I’ll try to get a working health tracker going.