| Table.Field | Is linked to table.field | Description |
| clients.clientid | issues.clientid | Client assigned to support issue |
| comments.issueid | issues.issueid | Comments assigned to an issue/support |
| attachments.issueid | issues.issueid | Attachments assigned to an issue/support |
| base.baseid | issues.base | Type of issue. eg 1 is issue, 2 is support, 3 is knowledge base, 4 is client |
| box.boxid | messages.box | The mailbox of a message. Eg inbox, sent, deleted |
| category.categoryid | issues.category | Category assigned to an issue/support |
| users.userid | clients.salesperson | Salesperson assigned to a client |
| users.userid | clients.managedby | Manager assigned to a client |
| users.userid | issues.originator | Originator assigned to an issue/support |
| users.userid | issues.assignedto | User assigned to an issued/support |
| users.userid | issues.owner | Owner of an issue |
| users.userid | messages.fromuser | Sender of a message |
| users.userid | messages.touser | Recipient of a message |
| issues.issueid | messages.relateditem | Issues referenced in a message |
| completion.completionid | issues.completion | Completion amount assigned to an issue/support |
| issuetype.issuetypeid | issues.type | Type of an issue |
| priority.priorityid | issues.priority | Priority of an issue/support |
| software.softwareid | issues.software | Software in an issue/support |
| software.softwareid | clients.software | Software for a client |
| status.statusid | issues.status | Status of an issue/support |
| status.statusid | clients.status | Status of a client |