EER Diagram - Leonhest/Smartmat GitHub Wiki

Screenshot_2023-05-08_at_12.35.06

There are three main tables that provide the basis for many of the other table and linking tables in this ER-diagram:

  • Items
  • Fridge
  • Users
    These three provide foreign keys for many of the other tables and as such stand at the core of this model. Recipes could also be considered another major table as it consists of several subtables and linking tables.

The solid and dotted lines between tables defines whether the relationship is identifying or non-identifying. In other words whether the entity can be uniquely identified without a parent entity(Non-identifying).

  • Solid line - Identifying
  • Dotted line - Non-identifying

1: one
1..*: one to many

⚠️ **GitHub.com Fallback** ⚠️