FridgeMaster

Tables (6)

Fridge Item (fridge)

  • ID (fr_id) — INTEGER — Primary key — NOT NULL
  • ID (it_id) — INTEGER — Foreign key → Items.ID — NOT NULL
  • Fridge (user_fridge) — INTEGER — Foreign key → Users.Fridge — NOT NULL
  • Amount (fr_amount) — INTEGER
  • Item Id (item_id) — INTEGER

Items (items)

  • ID (it_id) — INTEGER — Primary key — NOT NULL
  • Name (it_name) — VARCHAR(100)

Publish (publish)

  • ID (pub_id) — INTEGER — Primary key — NOT NULL
  • ID (re_id) — INTEGER — Foreign key → Recipes.ID — NOT NULL
  • Email (user_mail) — VARCHAR(60) — Foreign key → Users.Email — NOT NULL
  • Key — Foreign key → Users.Fridge — NOT NULL
  • Date (pub_date) — DATE
  • Publisher (pub_publisher) — VARCHAR(60)

Recipe Ingredients (recipe_ingredients)

  • ID (re_id2) — INTEGER — Foreign key → Recipes.ID — NOT NULL
  • ID (it_id2) — INTEGER — Foreign key → Items.ID — NOT NULL
  • Recipe ID (re_id) — INTEGER
  • Item ID (it_id) — INTEGER

Recipes (recipes)

  • ID (re_id) — INTEGER — Primary key — NOT NULL
  • Name (re_name) — VARCHAR(120)
  • Steps (re_step) — TEXT[]
  • Minutes (re_minute) — INTEGER

Users (users)

  • Email (user_mail) — VARCHAR(60) — Primary key — NOT NULL
  • Fridge (user_fridge) — INTEGER — Primary key — NOT NULL
  • Password (user_password) — VARCHAR(120)
  • Name (user_name) — VARCHAR(60)