010117-drizzle-orm-patternslisted

# Drizzle ORM Patterns ## When to use When building PostgreSQL schemas with Drizzle ORM. Covers table conventions, constraints, vector search, and domain factories. ## References | Topic | File | |---|---| | Table naming, prefixes, timestamps | `references/table-conventions.md` | | FK constraints and cascade rules | `references/foreign-keys.md` | | Vector columns and HNSW indexes | `references/vector-columns.md` | | JSONB columns and GIN indexes | `references/jsonb-gin.md` | | Raw SQL with `sql\`\`` | `references/raw-sql.md` | | Domain factory pattern | `references/domain-factories.md` | ## Quick checklist - [ ] Prefix tables: `prd_` (prod), `sys_` (system), `tst_` (test) - [ ] Use `id()` from `_cuid.ts` for UUID PKs - [ ] Use `.references(()=>Table.id, {onDelete: "cascade"|"set null"})` for FKs - [ ] Declare all `xxxId` columns as `.references()` — never leave implicit - [ ] Wrap domain logic in factory functions: `createXxxRepo(table)` - [ ] Use `as any` to bridge Drizzle's complex types in factories - [ ] For vector search: `vector({ dimensions: 384 })` + HNSW index - [ ] For JSONB search: `jsonb()` + GIN `@>` index - [ ] For timestamps: use the `timestamps` spread (`createdAt`, `updatedAt`, `deletedAt`)