Document the existing PostgreSQL schema in this directory as a visual ERD.
Read schema.sql and queries.sql. The optional add-reviewer.sql is NOT applied.
Treat schema.sql as the source of truth for database constraints.
Create one self-contained erd.html that opens directly in a browser, offline.
Use styled table cards and inline SVG connectors; no external libraries or assets.
Include every column, exact SQL types, PK/FK/unique markers and composite keys.
Label connections with the FK column and cardinality derived from constraints.
Keep connector routes outside cards. Make the full diagram scrollable on mobile.
Include a readable relationship list with file-and-line evidence for every link.
Separate application checks from database constraints. List uncertainties.
Do not infer foreign keys from _id names or redesign the schema.
Only create erd.html; do not modify the SQL or other source files.
