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