Table Relationship Diagram

Stefan McNamara Updated by Stefan McNamara

Table Relationships

The Time and Attendance database holds the employee information that supports rostering, clocking, absence and pay-related reporting. Because the data is spread across many tables, it can be hard to know where to look for a particular piece of information or how the tables relate to one another.

The diagram in this article sets out those tables and groups them by function, so you can see at a glance which tables do what and how they connect.

What the diagram shows

  • Functional groups: Tables are clustered by purpose (for example, employee details, working patterns, clocking records and absence), so related tables sit together.
  • Table purpose: Each table is labelled so you can quickly identify what kind of information it stores.

How to use it

  1. Find the right group. Start with the function you’re interested in, such as absence or clocking data.
  2. Identify the table. Look within that group for the table that holds the information you need.

You can find the table relationship diagram here

Was this article useful?

Data Share FAQ