personalized recipe
Tables (6)
Ingredient
- ingredient_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- required_amount — FLOAT
- unit — VARCHAR(20)
Recipe
- recipe_id — INT — Primary key — NOT NULL
- title — VARCHAR(15) — NOT NULL
- description — TEXT
- category — VARCHAR(50)
- image — BLOB
- cooking_time — INT
- difficulty — VARCHAR(5)
Recipe_Ingredient
- recipe_id — INT — Primary key — NOT NULL
- ingredient_id — INT — Primary key — NOT NULL
User
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(10) — NOT NULL
- age — INT
- gender — VARCHAR(2)
- is_pregnant — BOOLEAN
- health_status — VARCHAR(50)
- allergy — VARCHAR(50)
- preference — VARCHAR(100)
- nickname — VARCHAR(10)
User_Ingredient
- ingredient_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- weight_in_grams — FLOAT
- user_id — INT — NOT NULL
User_Recipe
- user_id — INT — Primary key — NOT NULL
- recipe_id — INT — Primary key — NOT NULL