Query
CREATE TABLE "shopping_list_item_recipe_reference" (
created_at DATETIME,
update_at DATETIME,
id CHAR(32) NOT NULL,
shopping_list_item_id CHAR(32) NOT NULL,
recipe_id CHAR(32),
recipe_quantity FLOAT NOT NULL,
recipe_scale FLOAT NOT NULL,
recipe_note VARCHAR,
PRIMARY KEY (id, shopping_list_item_id),
FOREIGN KEY(recipe_id) REFERENCES recipes (id),
FOREIGN KEY(shopping_list_item_id) REFERENCES shopping_list_items (id)
)