web

Tables (6)

Untitled (recipe_process)

  • Key (processNumber) — Primary key — NOT NULL
  • Key (recipeNumber) — Foreign key → recipe.Key — NOT NULL
  • Field (process)

Untitled (myFridge)

  • Key (email) — Foreign key → rProcess.Key — NOT NULL
  • Key (ingredientName2) — Foreign key → Untitled.Key — NOT NULL

Untitled (ingredient)

  • Key (ingredientName) — Primary key — NOT NULL
  • Field (ingredientNum)

rProcess (users)

  • Key (email) — Primary key — NOT NULL
  • Field (password)
  • Field (name)
  • Field (role)

recipe

  • Key (recipeNumber) — Primary key — NOT NULL
  • Field (recipeName)
  • Field (nation)
  • Field (kcal)
  • Field (level)
  • Field (image)

users (recipe_ingredient)

  • Key (recipeNumber) — Foreign key → recipe.Key — NOT NULL
  • Key (ingredientName) — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity)