---
title: Pantry
---
erDiagram
    PRODUCT ||--o{ CATEGORY : ""
    PRODUCT ||--o{ UNITY : ""
    FLOW ||--o{ PRODUCT : ""
    FLOW ||--o{ USER : ""
    PRODUCT {
        uuid id PK
        string title
        string barCode UK
        string brand
        string boughtAt
        string expirationDate
        string status
        CATEGORY category FK
        UNITY unity FK
    }

    CATEGORY {
        uuid id PK
        string title
    }


    UNITY {
        uuid id PK
        int unity 
        int subUnity "e.g.: 1 egg-carton (unity) has 10 eggs (subUnity)"
    }

    USER {
        uuid id PK
        string name
        string login
        string password
    }

    FLOW {
        uuid id PK
        PRODUCT product FK
        string consume
        USER author PK
        string createdAt
    }