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)