Knowledge base

Data Model Explorer

Our Data Model Explorer provides an Entity Relationship Diagram (ERD) of your Tanda data, allowing you to see the relationships between your different tables.

  1. Drag tables around the workspace, by clicking and dragging anywhere on a table
  2. Drag the entire workspace around by clicking and dragging the background
  3. 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

  • Allowance
  • Award tag
  • Award template
  • Break
  • Clock in
  • Custom event
  • Leave balance
  • Leave request
  • Location
  • Location sales target
  • Organisation
  • Qualification
  • Roster
  • Sales target
  • Schedule
  • Shift
  • Shift detail
  • Team
  • Team sales target
  • Timeclock question
  • Timesheet
  • User
  • Custom event team
  • Leave request daily breakdown
  • Schedule break
  • Schedule award interpretation
  • Shift award interpretation
  • Shift note
  • Timesheet note
  • User qualification
  • User award tag
  • Timesheet award interpretation