Overview
This page describes the database model for our project. The database schema is designed to store all the necessary data for our application, using a relational database approach.
Entity Relationship Diagram
The above image shows the entity relationship diagram (ERD) for our database schema. It consists of nine main entities, with relationship between them:
- Users: This entity stores information about users of our application, such as username, password or email.
- Groups: This entity stores information about groups of users, such as level, experience or link code.
- Fridge: This entity stores information about the fridges owned by groups, such as fridge ID or group ID.
- Product: This entity stores information about products that may be stored in the fridges, such as EAN or category.
- Shopping List: this entity stores information about shopping lists connected to a fridge, such as shopping list ID and fridge ID.
- Allergy: This entity stores information about allergies of users and product, such as name or description.
- Category: This entity stores information about the possible categories of the products, such as category name or description.
- Achievement: This entity stores information about the achievement that groups may gain, such as the achievement's name or description.
- Recipe: This entity stores information about the recipes users have added, such as recipe name or description.