Relations defined for all FK tables

Query API used for nested data

Operator helpers for all conditions

desc/asc helpers for ordering

Indexes on FK columns

Indexes on filtered columns

drizzle.config.ts uses dialect

defineConfig import

Generate command is current

Migrate command is current

Schema passed to drizzle

Enum for post status

Migrations committed note

Indexes on FK columns

Indexes on filtered columns

References with onDelete

Money as integer cents

Enum via text with enum option

createdAt on all tables

updatedAt on all mutable tables

Relations defined

Schema passed to drizzle

SQLite foreign_keys pragma

SQLite WAL mode

notNull on required columns

Upsert with onConflictDoUpdate

No check-then-insert pattern

Transaction wraps the entire sync

Uses tx inside transaction

updatedAt uses SQL expression

Batch processing for efficiency

excluded reference in set clause

Money stored as integer cents

Return value from transaction

Type inference or explicit types

postgres.js pool configuration

DATABASE_URL from environment

Schema passed to drizzle

drizzle.config.ts uses dialect

defineConfig used

Generate command current syntax

Migrate command present

Indexes on FK columns

Money as integer cents

Relations defined

Enum for status fields

Timestamps with defaultNow

Operator helpers for conditions

References with onDelete

Transaction for billing cycle

Transaction for cancel+invoice

Uses tx not db inside transaction

Returning destructured as array

Batch insert for invoices

updatedAt SQL expression on updates

InferSelectModel or InferInsertModel used

Money as integer cents

Indexes on FK columns

References with onDelete

Enum for status fields

Operator helpers for conditions