Database ER (core entities)

Used in: §9.x reference for backend devs, §14.5 Migrations Audience: Backend Developer, DevOps IA ID: extra (required by user inst.)

Reading guide: The schema is illustrative — column names match repository code conventions but exact migrations should be confirmed against migrations/*.sql (see open question 4).

---