publishercrm - Laravel Schema Designer

Contractors

id increments
type_id integer
first_name string
second_name string
middle_name string
phone string
email string
delivery_address string
softDeletes softDeletes
timestamps timestamps

Tickets

id increments
contractor_id integer
product_id integer
data text
comment text
softDeletes softDeletes
timestamps timestamps

Contractors_Types

id increments
name string
timestamps timestamps

Communications

id increments
contractor_id integer
ticket_id integer
type_id integer
description text
timestamps timestamps

Communications_Types

id increments
name string
timestamps timestamps

Poducts

id increments
name string
description text
softDeletes softDeletes
timestamps timestamps

Status_Tickets

id increments
type_id string
name string
ticket_id ^FK integer
timestamps timestamps

Status_Tickets_Types

id increments
name string
timestamps timestamps

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