Defining data structures
For our help desk solution, we will use related tables as our data source. We will design a base column template to keep track of all the information needed. You can customize it to your own needs.
Getting ready
The following tables will make up our solution’s data structure with the main focus on the Ticket table, to which all the tables will be related. Let’s start with this one and then move on to the rest.
Ticket
This table will hold the base information of the help desk ticket and will be our data model’s primary object. The column structure is as follows:
|
Display name |
Data type |
Format |
|
Title |
Single line of text |
Text |
|
Description ... |
