Database-in-source layout

The Postgres schema is versioned as plain .sql files under a database/ folder in the repo — this folder is the source of truth for the schema. postgres-test-setup applies it to a local Docker DB for tests; a human applies the same files to production.

Layer directories

Top-level directories group tables/objects by conceptual layer — one directory per Postgres schema, or per logical grouping within one schema. Names and count are entirely per-project; a generic example: