Database Schema

File Location

packages/db/src/
├── index.ts          # Database client (createDb) and exports
├── schema/
│   ├── index.ts      # Barrel re-exports (export * from "./{entity}")
│   └── [entity].ts   # Table + all derived schemas (insert, select, update, form)
└── migrations/       # Auto-generated — never hand-write

7 Schemas Per Entity

Every entity file defines exactly 7 schemas:

1. Table definition -- pgTable(...) with text("id").primaryKey()
2. Insert schema -- createInsertSchema(table, overrides) with callback overrides for nullable columns