HelpDesk - Laravel Schema Designer

ticket_departments

id increments
title string (20)

tickets

id increments
ticketmask string (20)
departmentid integer
ticketstatusid integer
priorityid integer
userid integer
creationtime integer
lastreplier integer
subject string (255)
laststaffreplytime integer
lastuserreplytime integer

ticket_status

id increments
title string (100)
frcolorcode string (6)
bgcolorcode string (6)

ticket_priorities

id increments
title string (100)
displayorder integer
frcolorcode string (6)
bgcolorcode string (6)

ticket_messages

id increments
timestamp integer
content text
hasattachment enum

ticket_attachments

id increments
filename text
filehash string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01