hi boss..
i see you have knowledge on programming, thats great :-)
so, some of my tought on that is..
- table for tickets data should have new field for tags selected
- and since it is will be able to have multiple tags, it need another table for holding tags selected, so the tickets can be queried with tag name (but this search will be slower, so will need to create some function to separate from searching on tags and tickets table)
- i think u mean that it is category, tickets with multiple category. not a tags. tags is meant to created by user, any words, not pre defined on databse. just like hashtags on common social media.
i can work that for 1-2 days. hope you will choose me :-)
best regards, Fal.