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 Projectworks 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 - Billing contact - Client - Country - Currency - Custom field - Expense claim - Leave - Location - Module - Module custom field value - Office - Project - Project custom field value - Project status - Project type - Task - Task custom field value - Tax type - Team - Timesheet - User - User custom field value - Client project - Client billing contact - Client type - Custom field project type - Custom field project status - Custom field option - Expense claim file - Module task - Module custom field option value - Project module - Project custom field option value - Task user - Task custom field option value - User custom field option value