osticket - Laravel Schema Designer

ticket

id increments
name string
description text
duedate timestamp
last_update timestamp
priority string
created timestamp
dept_id ^FK integer
team_id ^FK integer
user_id ^FK integer
status_id ^FK integer
project_id ^FK integer

User

id increments
role integer
username string
passwd string
status integer
created timestamp
last_update timestamp

Project

id increments
name string
description text
created timestamp
dept_id ^FK integer
team_id ^FK integer

Department

id increments
name string
created timestamp
org_id ^FK integer

Team

id increments
name string
description string
dept_id ^FK integer
team_lead_id ^FK integer
users_id ^FK integer

Organization

id increments
name string
description text
created timestamp

Topic

id increments
Description text
created timestamp
updated timestamp
project_id ^FK integer

Status

id increments
name string
sort integer

Comment

id increments
Title string
comment text
created timestamp
ticket_id ^FK integer
user_id ^FK integer

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