Query
CREATE TABLE households_to_ingredient_foods (
household_id CHAR(32),
food_id CHAR(32),
FOREIGN KEY(food_id) REFERENCES ingredient_foods (id),
FOREIGN KEY(household_id) REFERENCES households (id),
CONSTRAINT household_id_food_id_key UNIQUE (household_id, food_id)
)