Is my shopping list database schema good enough? I'm wondering if my schema is correct? It's intended to hold shopping list items for each user, a user belongs to a household. Items will be added to the household.

The stocklist will to hold the quantity of an iID (item ID) and that iID is belongs to a hhID .

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.
Your schema has a circular reference and redundant columns/foreign keys.

Consider the following normalization of your data structure:


Put itens as a reference table, no Foreign Keys.
Stocklist references Items
Users have a FK to Household, no use on including the reverse relation because you can always find the User records for a given Household with a table Inner Join.