Schema

erDiagram
   patches ||--o{ entities                 : "patch"
   patches ||--o{ entity_diffs             : "from / to"
   patches ||--o{ entity_resolved_current  : "current"
   patches ||--o{ entity_links             : "patch"
   patches ||--o{ locale_strings           : "patch"
   patches ||--o{ source_keys              : "first / last seen"
   patches ||--o{ imports                  : "audit"
   patches }o--o| patches                  : "parent (forks)"
   entities }o--o| assets                  : "icon_hash → hash (no FK)"

   patches {
      bigint  id PK
      text    game
      text    branch
      text    version
      text    version_raw
      bigint  parent_patch_id FK
      tstz    imported_at
   }
   entities {
      bigint  row_id PK
      text    game
      text    branch
      text    type
      text    id
      bigint  patch_id FK
      text    content_hash
      jsonb   data "NULL = tombstone"
      jsonb   tags
      jsonb   links
      text    icon_hash
      jsonb   assets "multi-asset list"
   }
   entity_resolved_current {
      text    game PK
      text    branch PK
      text    type PK
      text    id PK
      bigint  patch_id FK
      jsonb   data
   }
   entity_diffs {
      bigint  id PK
      bigint  from_patch_id FK
      bigint  to_patch_id FK
      text    op "added | removed | changed"
      jsonb   changes
   }
   entity_links {
      bigint  id PK
      text    from_id
      text    rel
      text    to_id
      bigint  patch_id FK
   }
   source_keys {
      text    game PK
      text    type PK
      text    source_key PK
      text    codex_id
   }
   assets {
      text    hash PK "SHA-256"
      text    media_type
      bigint  bytes
      text    url
   }
   locale_strings {
      bigint  row_id PK
      text    game
      text    branch
      text    locale
      text    namespace
      text    key
      text    value "NULL = tombstone"
      bigint  patch_id FK
   }