osticket - Laravel Schema Designer

ticket

id increments
name string
description text
user_id ^FK integer
status_id integer
dept_id integer
topic_id integer
staff_id integer
team_id integer
duedate datetime
created datetime
last_update datetime

User

id increments
status integer
username string
passwd string
dept_id integer
staff_id integer
team_id integer
created datetime
last_update datetime

Project

id increments
description text
dept_id integer
ticket_id ^FK integer

Department

id increments
user_id string

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