Database Tables

Jump to bottom

Motohiko Makino edited this page Feb 11, 2019 · 1 revision

Database Name: recipes_db

Recipes

Field	Type
id	integer
name	string
description	text
image	string
gluten_free	boolean
dairy_free	boolean
vegetarian	boolean
vegan	boolean
prep_time	integer
cook_time	integer
instructions	text
rating	integer

Products

Field	Type
id	integer
name	string
image	string
calories	integer
gluten_free	boolean
vegetarian	boolean

Ingredients

Field	Type
id	integer
amount	integer
ProductId	integer
RecipeId	integer

User

Field	Type
id	integer
name	string
email	string
password	string

UserProfile

Field	Type
id	integer
favorite	boolean
posted	boolean
RecipeId	integer
UserId	integer