Appearance
SQL Server database
The operational database for Ethos Building Services: a field-service / job-management platform for building-insurance repair work. Azure SQL, hosted on sql-coredata-prod-australiaeast-001 (prod, test and per-developer databases), with a geo replica in Australia Southeast and a separate BI database. See Azure → BusinessData.
No foreign keys exist in the database; relationships are inferred from procedure/view joins and naming conventions (177 relationships on the Relationships page).
Contents: 396 tables · 177 views · 914 stored procedures · 27 functions
All application data access goes through stored procedures only (Dapper in CommonDataAccess); schema changes are applied via the DbUp project DbMigrations.
Where to look
- Domains & subsystems: what each group of tables is for, with naming conventions
- ER diagrams: Prime Ecosystem core, Booking & scheduling, WIP & KPI, Makesafe, Integrations
- Data dictionary: every table and column
- Object usage report: which objects are referenced or dead
- Used by n8n: which procedures and tables the live n8n flows touch
Agents and tooling should use the raw JSON in the
sql-ontologyrepo; this site is the human-readable view.
Size by domain
| Domain prefix | Tables | Views | Procedures |
|---|---|---|---|
| airtop | 1 | 0 | 0 |
| clicksend | 2 | 0 | 3 |
| elevenlabs | 1 | 0 | 4 |
| endata | 3 | 0 | 3 |
| eth | 234 | 95 | 422 |
| makesafe | 16 | 2 | 115 |
| mcp | 0 | 0 | 2 |
| n8n | 3 | 2 | 6 |
| optimoroute | 11 | 5 | 68 |
| other | 13 | 25 | 107 |
| pb_ | 1 | 1 | 0 |
| prime | 109 | 40 | 184 |
| wip | 2 | 7 | 0 |