CRM - Laravel Schema Designer

users

id increments
first_name string (255)
last_name string (255)
email string (255)
phone_extension integer
softDeletes softDeletes
timestamps timestamps
department_id ^FK integer
position_id ^FK integer
manager_id ^FK integer

departments

id increments
name string (255)
parent_id ^FK integer
timestamps timestamps
softDeletes softDeletes

position

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
status enum
reporting_day tinyInteger
account_manager ^FK integer
logo_file string (255)

client_contact

id increments
timestamps timestamps
softDeletes softDeletes
first_name string (255)
last_name string (255)
email string (255)
phone_primary string (20)
phone_secondary string (20)
phone_tertiary string (20)
type enum
client_id ^FK integer

notes

id increments
timestamps timestamps
softDeletes softDeletes
author_id ^FK integer
type enum
parent_id ^FK integer

campaigns

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK integer
website string (255)
revenue double
campaign_manager_id ^FK integer
client_lead_id ^FK integer
digital_strategist_id ^FK integer
status enum
live_date date
end_date date
campaign_type_id ^FK integer

campaign_types

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

requests

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
client_id ^FK integer
campaign_id ^FK integer
created_by ^FK integer
assigned_to ^FK integer
due_date date
frozen_by ^FK integer
description text
attachments string (255)

campaign_type_fields

id increments
timestamps timestamps
softDeletes softDeletes
campaign_type_id ^FK integer
field_name string (255)
field_type enum

campaign_type_values

id increments
timestamps timestamps
softDeletes softDeletes
value text
campaign_id ^FK integer
campaign_type_field_id ^FK integer

reports

id increments
timestamps timestamps
softDeletes softDeletes
campaign_id ^FK integer
sent_by ^FK integer
due_date date
sent_date date
status enum
url string (255)

invoices

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK integer
amount double
tax double
paid double
status enum

client_emails

id increments
timestamps timestamps
client_contact_id ^FK integer
subject text
content text

rankings

id increments
timestamps timestamps
softDeletes softDeletes

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