CREATE TABLE "recipes_ingredients" (
created_at DATETIME,
update_at DATETIME,
id INTEGER NOT NULL,
position INTEGER,
recipe_id CHAR(32),
title VARCHAR,
note VARCHAR,
unit_id CHAR(32),
food_id CHAR(32),
quantity INTEGER,
reference_id CHAR(32),
original_text VARCHAR,
note_normalized VARCHAR,
original_text_normalized VARCHAR,
referenced_recipe_id CHAR(32),
PRIMARY KEY (id),
CONSTRAINT fk_recipe_subrecipe FOREIGN KEY(referenced_recipe_id) REFERENCES recipes (id),
FOREIGN KEY(unit_id) REFERENCES ingredient_units (id),
FOREIGN KEY(food_id) REFERENCES ingredient_foods (id),
FOREIGN KEY(recipe_id) REFERENCES recipes (id)
)