panel_db - Laravel Schema Designer

ticket

id increments
client_id bigInteger
user_id bigInteger
technical_id bigInteger
category_id bigInteger
subject string
description string
priority enum
status enum
date_to_solution_at date
timestamps timestamps
softDeletes softDeletes

interaction

id increments
client_id bigInteger
user_id bigInteger
ticket_id ^FK bigInteger
type enum
description string
timestamps timestamps
softDeletes softDeletes

history

id increments
client_id bigInteger
ticket_id ^FK bigInteger
technical_id bigInteger
description string
timestamps timestamps

attachment

id increments
client_id bigInteger
ticket_id bigInteger
interaction_id bigInteger
name string
size integer
path string
timestamps timestamps
softDeletes softDeletes

category

id increments
name string
timestamps timestamps
softDeletes softDeletes

ticket_related

id increments
ticket_id bigInteger
ticket_relationship_id bigInteger
timestamps timestamps

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