Entity-Relationship Diagram
Derived from server/app/models/ via scripts/generate_db_docs.py. For per-table column
details see tables.md. Do not hand-edit the diagram below — run
python3 scripts/generate_db_docs.py instead.
Notes
callparticipant.call_idis a FK toconversation.id, notcall.id— see schema-overview.md for details.- Router metric tables (
routerhealth,interfacetraffic) andguest_sessionshave no FK touserand appear above with no edges. mobile app(WatermelonDB) tables are not part of this diagram — see tables.md.