exigo_support - Laravel Schema Designer

tickets

id increments
user_id ^FK integer
project_id ^FK integer
title string
public tinyInteger
open tinyInteger
timestamps timestamps
softDeletes softDeletes

users

id increments
full_name string
username string (32)
email string
password string
avatar string
remember_token string (100)
timestamps timestamps
softDeletes softDeletes

faq

id increments
project_id ^FK integer
question string
answer text
timestamps timestamps

licenses

id increments
user_id ^FK integer
project_id ^FK integer
key string
timestamps timestamps

projects

id increments
item_id integer
author string
title string
url string
timestamps timestamps
softDeletes softDeletes

comments

id increments
user_id ^FK integer
ticket_id ^FK integer
content text
private_content text
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string
permission string
timestamps timestamps

role_user

id increments
user_id ^FK integer
role_id ^FK integer

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