Skip to content

Product Wish List Application ER Diagram

erDiagram
    User {
        INTEGER id PK
        STRING email
        STRING phone
        BOOLEAN has_initial_profile
        STRING photo
        TEXT address
        INTEGER gender_id FK
        INTEGER country_id FK
        DATE birthday
        DATETIME created_at
        DATETIME updated_at
    }

    Product {
        INTEGER id PK
        STRING name
        STRING description
        DECIMAL price
        DATETIME created_at
        DATETIME updated_at
    }

    ProductWhishList {
        INTEGER id PK
        INTEGER user_id FK
        INTEGER product_id FK
        BOOLEAN is_wished
        DATETIME created_at
    }

    User ||--o{ ProductWhishList : "has"
    Product ||--o{ ProductWhishList : "has"