DB Patterns

Structure

db/
├── drizzle.ts   ← db client; all tables + relations registered here
└── schema.ts    ← re-exports all table schemas for drizzle-kit

modules/[name]/
├── [name].schema.ts     ← pgTable definition
├── [name].relations.ts  ← Drizzle relations (required for `with`)
└── [name].repo.ts       ← all DB queries for this entity

• Never query the DB in route handlers or components
• One repo per module — all queries for an entity live in [name].repo.ts

Queries