db

Database

This service contains the data of the project (except the file resources). It is a dockerized PostgreSQL database.

It is not open to the public, only the server can access it. The setup service is used to initialize the database.

ER Diagram:

erDiagram
    product {
        id id
        str name
        str description
        img_id icon
        float price
    }

    allergy {
        id id
        str name
    }

    product-allergy {
        id product_id
        id allergy_id
    }

    product ||--o{ product-allergy : contains
    product-allergy }o--|| allergy: present_in

    product-category {
        id product_id
        id category_id
    }

    product ||--|| product-category : categorized

    category {
        id id
        str name
    }

    product-category }o--|| category: categorized

    orders {
        id id
        id session
    }

    orders-product {
        id order_id
        id product_id
        int quantity
    }

    session {
        id id
        str table_id
        boolean in_progress
    }

    map_session_uuid {
        str simple_id
        id session_id
    }

    orders-product }|--|| orders : generate
    product ||--|{ orders-product : is_ordered
    session ||--o{ orders: registers
    map_session_uuid ||--|| session : translates

Loading