Query
CREATE TABLE households_to_recipes (
id CHAR(32) NOT NULL,
household_id CHAR(32) NOT NULL,
recipe_id CHAR(32) NOT NULL,
last_made DATETIME,
created_at DATETIME,
update_at DATETIME,
PRIMARY KEY (id, household_id, recipe_id),
FOREIGN KEY(household_id) REFERENCES households (id),
FOREIGN KEY(recipe_id) REFERENCES recipes (id),
CONSTRAINT household_id_recipe_id_key UNIQUE (household_id, recipe_id)
)