Ticket Tracker - Laravel Schema Designer

Tickets

id increments
timestamps timestamps
softDeletes softDeletes
subject string (600)
closedDate datetime
statusid ^FK integer
techid ^FK integer
timeWorked time
requestorId string (600)
requestorEmail string (600)
queueId ^FK integer

Statuses

id increments
timestamps timestamps
softDeletes softDeletes
name string (600)
type string (600)

Comments

id increments
timestamps timestamps
softDeletes softDeletes
ticketid ^FK integer
value text

Techs

id increments
timestamps timestamps
softDeletes softDeletes
firstName string (600)
lastName string (600)
email string (600)

Tags

id increments
timestamps timestamps
softDeletes softDeletes
tag string (600)

Requestors

id increments
timestamps timestamps
softDeletes softDeletes
firstName string (600)
lastName string (600)
email string (600)

Queues

id increments
timestamps timestamps
softDeletes softDeletes
name string (600)
description text

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