You have a system design problem. Ticket type is a process. Incident, Request, Problem, RFS
It is highly recommended to use ticket types strictly as intended.
New is Status.
Legal and Access are Services.
You can create 2 GA jobs for both of cases.
Code: Select all
CREATE TABLE queue ( id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR (200) NOT NULL,
It sounds strange