CREATE TABLE "recipes" (
created_at DATETIME,
update_at DATETIME,
id CHAR(32) NOT NULL,
slug VARCHAR,
group_id CHAR(32) NOT NULL,
user_id CHAR(32),
name VARCHAR NOT NULL,
description VARCHAR,
image VARCHAR,
total_time VARCHAR,
prep_time VARCHAR,
perform_time VARCHAR,
cook_time VARCHAR,
recipe_yield VARCHAR,
"recipeCuisine" VARCHAR,
rating FLOAT,
org_url VARCHAR,
date_added DATE,
date_updated DATETIME,
is_ocr_recipe BOOLEAN,
last_made DATETIME,
name_normalized VARCHAR NOT NULL,
description_normalized VARCHAR,
recipe_yield_quantity FLOAT DEFAULT '0' NOT NULL,
recipe_servings FLOAT DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
CONSTRAINT recipe_slug_group_id_key UNIQUE (slug, group_id),
FOREIGN KEY(group_id) REFERENCES groups (id),
FOREIGN KEY(user_id) REFERENCES users (id)
)