I'm wondering if my schema is correct? It's intended to hold shopping list items for each
user, a user belongs to a
Items will be added to the
The stocklist will to hold the quantity of an
iID (item ID) and that
iID is belongs to a
So at the moment
- stocklist.hhID references household.hhID
- household.adminID references users.uID
- items.hhID references household.hhID
- stocklist.iID references items.iID
I'm wondering if these relationships are viable? Even more importantly what do you think of the schema?
Posted from my unused account before.