2024 is the year of the connector - vote here

Knowledge base

Data Model Explorer

Our **Data Model Explorer** provides an _Entity Relationship Diagram_ (ERD) of your AroFlo 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 - Asset - Bill - Business unit - Client - Custom field - Invoice - Item - Location - Organisation - Project - Purchase order - Quote - Schedule - Substatus - Supplier - Task - Task sales person - Task assigned history - Task asset - Task expense - Task labour - Task material - Task type - Timesheet - Tracking centre - User - Asset custom field - Bill line item - Bill note - Bill task - Client organisation - Client custom field - Invoice line - Location custom field - Purchase order line - Purchase order project - Quote line - Supplier organisation - Task custom field - Task type business unit - User custom field