Implementing Dynamic Ticket Management
You have put a lot of work into creating a shielded, multi-tenant application. Now it’s time to pivot to its core functionality, breathing life into the application: the ticket management itself.
In this chapter, we will implement the creation and deletion of tickets, as well as showing the ticket details and their related data.
You’ll also enhance the ticket list to show tickets from the database and implement paging, sorting, and searching features, as well as learn how to create enums, how to cache values with triggers, and why and when caching within the database values can be useful.
In this chapter, you will dive into the following topics:
- Creating the tickets table in the database
- Creating tickets and using triggers
- Viewing the ticket details
- Listing and filtering tickets
- Deleting tickets
