ttsgeb / Designated-Adult

An overly complex grocery and chore list generator.
GNU General Public License v3.0
0 stars 0 forks source link

Determine initial database structure #1

Open ttsgeb opened 9 months ago

ttsgeb commented 9 months ago

The plan is to start simply by tracking groceries, and then expand into insanity, so we need a structure that allows scope creep to be a true problem.

So, grocery tracking. We need to know a few things

Item Name Brand Variant Use rate Consumable? Perishable? Expected Usable Life Date last purchased QTY on hand QTY per pack QTY purchased

Naturally, there's more you can track, but I think this would be a pretty solid start.

ttsgeb commented 9 months ago

Should probably include the User from the start, too

User Name

Probably a Household as well

Household Name

And oh, oh no now I'm having to think about normalization to some degree

Lists will need their own stuff too, I imagine

List Name

This might take some more planning.