hdtest - Laravel Schema Designer

ticketit

id increments
subject string
content string
html string
status_id string
priority_id string
user_id string
agent_id string
category_id string
completed_at datetime
closed_by string
project_id string
department_id string
frontendgroup_id string
change string

users

id increments
timestamps timestamps
name string
email string
pawword string
remember_token string
ticketit_admin tinyInteger
ticketit_agent tinyInteger
ticketit_managment tinyInteger
ticketit_referente tinyInteger
department_id integer
frontendgroup integer

departments

id increments
timestamps timestamps
deleted_at softDeletes
name string

ticketit_category_details

id increments
timestamps timestamps
ticketit_id ^FK integer
category_detail_id integer
risposta string

ticketit_categories

id increments
name string
color string
da_approvare enum
attivo_frontend enum
deleted_at timestamp

projects

id increments
timestamps timestamps

ticketit_comments

id increments
timestamps timestamps
content string
html string
user_id string
ticket_id string
allegato_id string

allegati

id increments
timestamps timestamps
ticket_id string
filename string
comment_id string

frontend_groups

id increments
name string
franchising enum
deleted_at timestamp

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