PostgreSQL Game Schema

Purpose

Genre-agnostic database schema design for games using Drizzle ORM + PostgreSQL.

When to Use

Trigger: database schema, game database, Drizzle schema, players table, inventory, leaderboards, sessions, events, entity system, game data model

Prerequisites

None — this is a foundational skill.

Core Principles

Sid Meier: "A game is a series of interesting decisions." Richard Garfield: "The best game systems are elegant rule systems — minimal components that compose into complex behaviors."