TMO - Laravel Schema Designer

users

id increments
timestamps timestamps
companyID ^FK integer

roles

id increments
timestamps timestamps

tickets

id increments
softDeletes softDeletes
timestamps timestamps
statusID integer
roleID ^FK integer
onCallTechID ^FK integer
userID ^FK integer
technologyID ^FK integer
affectedPartID ^FK integer
configID ^FK integer
requiredDate datetime
outage boolean
priority integer
replacementPartNum string
alarmDescription string
beforeGC string
sow string
restrictAccess boolean

technologies

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string

affected

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string

ticketLife

id increments
timestamps timestamps
softDeletes softDeletes
ticketID ^FK integer
statusID integer
userID ^FK integer
comment string

bidQuotes

id increments
timestamps timestamps
ticketID ^FK integer
userID ^FK integer
softDeletes softDeletes
partAvailable boolean
crewAvailble boolean
crewNamesPhones string
etaOnSite datetime
manLift integer
quote float (10,2)
comment string

workOrders

id increments
softDeletes softDeletes
timestamps timestamps
onCallTechID ^FK integer
bidQuoteID ^FK integer
arrivalOnsite datetime
nocLoginName string
nocLogoutName string
troubleShootingCompleted datetime
manLiftSize string
actualRestoralDate datetime
closeOutComments string
accesChanges string
techContactDate datetime

companies

id increments
timestamps timestamps
softDeletes softDeletes
name string
typeOfwork string
disclaimer string
email string
operatingHours string
contactInformation string

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