Game Player and Inventory Schema

erDiagram
  PLAYER ||--o{ CHARACTER : owns
  PLAYER ||--|| WALLET : has
  CHARACTER ||--o{ INVENTORY_ITEM : holds
  ITEM ||--o{ INVENTORY_ITEM : "instance of"
  PLAYER ||--o{ PURCHASE : makes
  CHARACTER ||--o{ MATCH_RESULT : "plays in"
  MATCH ||--|{ MATCH_RESULT : records
  PLAYER {
    int id PK
    string username
    string region
  }
  WALLET {
    int id PK
    int player_id FK
    int coins
    int gems
  }
  CHARACTER {
    int id PK
    int player_id FK
    string class
    int level
  }
  ITEM {
    int id PK
    string name
    string rarity
  }
  INVENTORY_ITEM {
    int id PK
    int character_id FK
    int item_id FK
    int quantity
  }
  PURCHASE {
    int id PK
    int player_id FK
    string store_txn_id
    decimal amount
  }
  MATCH {
    int id PK
    string mode
    datetime started_at
  }
  MATCH_RESULT {
    int id PK
    int match_id FK
    int character_id FK
    int score
    string outcome
  }