Knowledge base

Data Model Explorer

Our **Data Model Explorer** provides an _Entity Relationship Diagram_ (ERD) of your WorkflowMax data, allowing you to see the relationships between your different tables. ### Navigating 1. Drag tables around the workspace, by clicking and dragging anywhere on a table 1. Drag the entire workspace around by clicking and dragging the background 1. Minimize/maximize your workspace to take up your entire browser screen ### Relationships Relationships are depicted by the arrows running between table properties. For a tidier view, you may select the _Relationships Only_ checkbox, which will hide all the other columns which are not part of a relationship ### Endpoints - Account - Client - Client contact - Client group - Cost - Custom field - Invoice - Job - Job category - Job status - Job task - Lead - Lead category - Purchase order - Purchase order bill - Purchase order stock receipt - Quote - Role - Staff - Supplier - Supplier contact - Task - Timesheet - Client address - Client billing custom rate - Client billing tax number - Client linked group - Client relationship - Client custom field - Client note - Client document - Client contact custom field - Client group client - Cost sale tax - Cost purchase tax - Custom field option - Invoice job - Invoice note - Invoice payment - Job custom field - Job cost - Job note - Job document - Job staff assigned - Job phase - Job milestone - Job quote - Job invoice - Job purchase order - Job task to do - Job task staff - Job task custom field - Job task note - Job task timesheet - Lead custom field - Lead note - Lead document - Lead activity - Lead quote - Purchase order job - Purchase order cost - Purchase order note - Purchase order document - Purchase order bill tax - Purchase order bill cost - Purchase order stock receipt tax - Purchase order stock receipt cost - Quote phase - Quote task - Quote cost - Quote custom field - Quote note - Quote document - Staff custom task rate - Staff historic rate - Supplier address - Supplier custom field - Supplier note - Supplier document - Supplier contact custom field - Task custom client rate - Task custom staff rate - Task historic rate - Task tax - Timesheet custom field - Job task note comment - Purchase order bill cost tax - Purchase order stock receipt cost tax