Drizzle ORM Schema Style Guide

Configuration

• Config: drizzle.config.ts
• Schemas: src/database/schemas/
• Migrations: src/database/migrations/
• Dialect: postgresql with strict: true

Helper Functions

Location: src/database/schemas/_helpers.ts

• timestamptz(name): Timestamp with timezone
• createdAt(), updatedAt(), accessedAt(): Standard timestamp columns
• timestamps: Object with all three for easy spread

Naming Conventions