The Data Model Decision

Declare your ServiceDesk data model as one object model with: table (the tickets table name you chose), columns (array of your actual column names for: id, author, title, description, priority, status, created, closed — in your naming), priorities (array of allowed priority values), closedByDefault (status value a ticket starts with).

Difficulty: advanced