[estimate_time] INTEGER,
[description] TEXT,
[servings] INTEGER DEFAULT 4,
+ [is_published] INTEGER NOT NULL DEFAULT FALSE,
FOREIGN KEY([user_id]) REFERENCES [User]([id]) ON DELETE SET NULL
);
+CREATE TABLE [Image] (
+ [Id] INTEGER PRIMARY KEY,
+ [recipe_id] INTEGER NOT NULL,
+ [name] TEXT,
+ [description] TEXT,
+ [image] BLOB,
+
+ FOREIGN KEY([recipe_id]) REFERENCES [Recipe]([id]) ON DELETE CASCADE
+);
+
CREATE TABLE [RecipeTag] (
[id] INTEGER PRIMARY KEY,