erDiagram
    accounts ||--o{ user : "user_id"
    cartItems ||--o{ cart : "cart_id"
    cartItems ||--o{ product : "product_id"
    carts ||--o{ user : "user_id"
    categories ||--o{ category : "parent_id"
    creditLimitHistory ||--o{ user : "user_id"
    creditLimitHistory ||--o{ user : "changed_by"
    debtRepayments ||--o{ user : "user_id"
    debtRepayments ||--o{ user : "verified_by"
    orderItems ||--o{ order : "order_id"
    orderItems ||--o{ product : "product_id"
    orders ||--o{ user : "user_id"
    paymentTransactions ||--o{ order : "order_id"
    paymentTransactions ||--o{ user : "verified_by"
    payments ||--o{ order : "order_id"
    products ||--o{ brand : "brand_id"
    products ||--o{ category : "category_id"
    quoteItems ||--o{ quote : "quote_id"
    quoteItems ||--o{ product : "product_id"
    quoteMessages ||--o{ quote : "quote_id"
    quoteMessages ||--o{ user : "sender_id"
    quotes ||--o{ user : "user_id"
    quotes ||--o{ order : "order_id"
    sessions ||--o{ user : "user_id"
    shippingBids ||--o{ order : "order_id"
    userAddresses ||--o{ user : "user_id"
    users ||--o{ dealer_tier : "dealer_tier_id"
    warehouseStocks ||--o{ warehouse : "warehouse_id"
    warehouseStocks ||--o{ product : "product_id"

    accounts {
        text id PK
        uuid user_id FK
        text account_id
        text provider_id
        text access_token
        text refresh_token
    }
    brands {
        uuid id PK
        timestamptz created_at
        timestamptz updated_at
        text name
        text slug
    }
    cartItems {
        uuid id PK
        uuid cart_id FK
        uuid product_id FK
        timestamptz created_at
        timestamptz updated_at
        int quantity
    }
    carts {
        uuid id PK
        uuid user_id FK
        timestamptz created_at
        timestamptz updated_at
    }
    categories {
        uuid id PK
        uuid parent_id FK
        timestamptz created_at
        timestamptz updated_at
        text name_vi
        text name_en
    }
    creditLimitHistory {
        uuid id PK
        uuid user_id FK
        uuid changed_by FK
        timestamptz created_at
        timestamptz updated_at
        timestamptz deleted_at
        numeric old_limit
    }
    dealerTiers {
        uuid id PK
        timestamptz created_at
        timestamptz updated_at
        text name_vi
        text name_en
    }
    debtRepayments {
        uuid id PK
        uuid user_id FK
        uuid verified_by FK
        timestamptz created_at
        timestamptz updated_at
        timestamptz deleted_at
        numeric amount
    }
    orderItems {
        uuid id PK
        uuid order_id FK
        uuid product_id FK
        timestamptz created_at
        timestamptz updated_at
        text product_name
        text product_sku
    }
    orders {
        uuid id PK
        uuid user_id FK
        timestamptz created_at
        timestamptz updated_at
        enum status
        numeric shipping_fee
    }
    outboxEvents {
        uuid id PK
        timestamptz created_at
        timestamptz updated_at
        enum event_type
        jsonb payload
    }
    paymentTransactions {
        uuid id PK
        uuid order_id FK
        uuid verified_by FK
        timestamptz created_at
        timestamptz updated_at
        timestamptz deleted_at
        numeric amount
    }
    payments {
        uuid id PK
        uuid order_id FK
        timestamptz created_at
        timestamptz updated_at
        timestamptz deleted_at
        numeric amount
    }
    products {
        uuid id PK
        uuid brand_id FK
        uuid category_id FK
        timestamptz created_at
        timestamptz updated_at
        timestamptz deleted_at
        text name_vi
    }
    quoteItems {
        uuid id PK
        uuid quote_id FK
        uuid product_id FK
        timestamptz created_at
        timestamptz updated_at
        int quantity
        numeric requested_price
    }
    quoteMessages {
        uuid id PK
        uuid quote_id FK
        uuid sender_id FK
        timestamptz created_at
        timestamptz updated_at
        text message
    }
    quotes {
        uuid id PK
        uuid user_id FK
        uuid order_id FK
        timestamptz created_at
        timestamptz updated_at
        enum status
        numeric total_quoted_price
    }
    sessions {
        text id PK
        uuid user_id FK
        timestamptz expires_at
        text token
        timestamptz created_at
        timestamptz updated_at
    }
    shippingBids {
        uuid id PK
        uuid order_id FK
        timestamptz created_at
        timestamptz updated_at
        text vendor_name
        numeric quoted_price
    }
    userAddresses {
        uuid id PK
        uuid user_id FK
        timestamptz created_at
        timestamptz updated_at
        text receiver_name
        text phone_number
    }
    users {
        uuid id PK
        uuid dealer_tier_id FK
        timestamptz created_at
        timestamptz updated_at
        timestamptz deleted_at
        text name
    }
    verifications {
        text id PK
        text identifier
        text value
        timestamptz expires_at
        timestamptz created_at
    }
    warehouseStocks {
        uuid warehouse_id FK
        uuid product_id FK
        int stock
        int min_stock_warning
        timestamptz created_at
        timestamptz updated_at
    }
    warehouses {
        uuid id PK
        timestamptz created_at
        timestamptz updated_at
        text name_vi
        text name_en
    }