Schema Overview

Tonnex uses Drizzle ORM for type-safe database access. All schemas live in packages/db/src/schema/.

Schema Files

File	Entities
`auth.ts`	profiles, organizations, org_memberships
`locations.ts`	regions, locations, godowns, warehouse_tenancy
`vehicles.ts`	vehicles, vehicle_leases, vehicle_loans, vehicle_transfers
`trips.ts`	trips, trip_crew, sub_contracted_trips
`clients.ts`	clients, client_delivery_points, client_pricing
`hr.ts`	persons, person_designations, attendance
`payroll.ts`	pay_structures, payroll_entries
`invoicing.ts`	invoices, invoice_line_items, credit_notes
`rbac.ts`	permissions, roles, role_permissions, user_role_assignments
`audit.ts`	audit_logs

Conventions

Table names: snake_case (plural)
Column names: snake_case in DB, camelCase in TypeScript
Every table has org_id (except system tables)
Primary keys: UUID with defaultRandom()
Timestamps: created_at and updated_at with timezone

Running Migrations

pnpm db:generate   # Generate SQL from schema changes
pnpm db:push       # Push schema directly (development)
pnpm db:migrate    # Apply migrations (production)
pnpm db:studio     # Open Drizzle Studio