Home
it-helpdesk
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (4)
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)
×
Comments for it-helpdesk
babeman123 . 25 July 2014
If someones viewing this, I created this schema, and it needs some large reworking. If you're planning on using it, I'd recommend forking it, and change it where necessary.
huglester . 08 February 2015
Thanks. if you have some code to share somewe - I would be grateful!
123123123 . 08 April 2015
github?
[email protected]
. 19 December 2018
It is not clear what workers are and how their table is related to tickets logs and comments. Can someone explain?
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01