SQLite Web: mealie.db

Insert row into recipes

created_at

DATETIME

update_at

DATETIME

id

Primary key. 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 NOT NULL (default '0')

recipe_servings

FLOAT NOT NULL (default '0')

Cancel