Home
it-helpdesk
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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