FOREIGN KEY([user_id]) REFERENCES [User]([id]) ON DELETE SET NULL
);
+CREATE TABLE [RecipeTag] (
+ [id] INTEGER PRIMARY KEY,
+
+ [recipe_id] INTEGER NOT NULL,
+ [tag_id] INTEGER NO NULL,
+
+ FOREIGN KEY([recipe_id]) REFERENCES [Recipe]([id]) ON DELETE CASCADE,
+ FOREIGN KEY([tag_id]) REFERENCES [Tag]([id]) ON DELETE CASCADE
+);
+
+CREATE TABLE [Tag] (
+ [id] INTEGER PRIMARY KEY,
+ [recipe_tag_id] INTEGER,
+ [name] TEXT NOT NULL,
+
+ FOREIGN KEY([recipe_tag_id]) REFERENCES [RecipeTag]([id]) ON DELETE SET NULL
+);
+
+CREATE UNIQUE INDEX [Tag_name_index] ON [Tag] ([name]);
+
CREATE TABLE [Quantity] (
[id] INTEGER PRIMARY KEY,
[value] REAL,