Domain Model

This page explains the domain model used in the WorkflowMax Reporting Database.

The domain model describes how data is grouped and related conceptually, rather than listing individual tables or fields.

Understanding this model will help you:

• Know where different concepts “live”
• Choose the correct starting point for queries
• Avoid incorrect joins
• Build stable and maintainable BI models

What is a domain?

A domain is a logical grouping of tables that represent a single business concept or workflow.

In this database:

• Domains are deliberate and opinionated
• Each domain has a clear responsibility
• Relationships between domains are explicit

This mirrors how WorkflowMax actually operates as a business system, while removing API-level complexity.

High-level domain overview

The WorkflowMax Reporting Database is organised into the following core domains:

• Clients
• Jobs
• Time
• Invoicing
• Quoting
• Purchasing

These domains are not independent — they form a structured hierarchy.

Domain hierarchy

At a high level, the model looks like this: