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
- Drag tables around the workspace, by clicking and dragging anywhere on a table
- Drag the entire workspace around by clicking and dragging the background
- 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
- Inventory category
- Invoice
- Item
- Location
- Organisation
- Payment
- 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
- User position
- Work type
- Asset custom field
- Bill line item
- Bill note
- Bill task
- Client organisation
- Client custom field
- Invoice line
- Location custom field
- Purchase order task
- Purchase order line
- Purchase order project
- Quote line
- Supplier organisation
- Task custom field
- Task type business unit
- User custom field