Just a separate table since a user can have many goals
added a day score for each day
CalculateHealthScore() would take the average of all user day scores
CalculateDayScore() would compare the user totals for cals/water/sleep/weights against the goal totals and give a 1-5 on how under/meets/over it is (literally a compareTo() function with some extra steps)
We have basic CRUD, but we don't have an app. We need to make use of the information they are giving us by having:
This will be interesting because right now I don't know where the best place to put these goals are, maybe in a separate table?