it-helpdesk - Laravel Schema Designer

machines

id increments
timestamps timestamps
softDeletes softDeletes
type_id integer
user_id integer
location_id integer
machine_name string (30)

machine_types

id increments
timestamps timestamps
softDeletes softDeletes
type_name string (30)

tickets

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
status_id integer
ticket_content text
ticket_read tinyInteger

machine_log

id increments
timestamps timestamps
softDeletes softDeletes
machine_id integer
user_id integer
log_content text

ticket_log

id increments
timestamps timestamps
softDeletes softDeletes
ticket_id integer
user_id integer
log_content text

ticket_comments

id increments
timestamps timestamps
softDeletes softDeletes
ticket_id integer
user_id integer
comment_content text

users

id bigIncrements
timestamps timestamps
username string (30)
email string (100)
password string (100)
salt string (30)
register_ip string (15)
forget_token string (100)
active_token string (100)

ticket_workers

id increments
timestamps timestamps
softDeletes softDeletes
ticket_id integer
user_id integer

software

id increments
timestamps timestamps
softDeletes softDeletes
software_name string (80)
software_key string (50)

software_category

id increments
timestamps timestamps
softDeletes softDeletes
category_name string (80)

software_installed

id increments
timestamps timestamps
softDeletes softDeletes
software_id integer
machine_id integer

machine_notes

id increments
timestamps timestamps
softDeletes softDeletes
machine_id integer
note_content text

machine_note_attachments

id increments
timestamps timestamps
note_id integer
file_name string (70)

ticket_attachments

id increments
timestamps timestamps
ticket_id integer
file_name string (70)

ticket_comment_attachments

id increments
timestamps timestamps
comment_id integer
file_name string (70)

ticket_status

id increments
timestamps timestamps
status_name string (40)
status_color string (30)

locations

id increments
timestamps timestamps
softDeletes softDeletes
group_id integer
location_name string (255)
location_description string (255)

location_groups

id increments
timestamps timestamps
softDeletes softDeletes
group_name string (255)
group_description string (255)

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