CRM - Laravel Schema Designer

users

id increments
timestamps timestamps

leads

id increments
phone string
campaign_name string (255)
lead_genration_time datetime
platform string (255)
first_name string (255)
last_name string (255)
status string (255)
reachablitiy string (255)
timestamps timestamps

leads_progress

id increments
lead_id ^FK integer
action string (255)
timestamps timestamps

leads_overviews

id increments
lead_id ^FK integer
user_id ^FK integer
content string (255)
from datetime
to datetime
columns json
timestamps timestamps

attachments

id increments
path string
mode_id integer
model_name string
timestamps timestamps

assign_agents

id increments
user_id ^FK integer
lead_id ^FK integer
timestamps timestamps

leads_updates

id increments
user_id integer
lead_id ^FK integer
content string (255)
timestamps timestamps

updated_replies

id increments
update_id ^FK integer
content string

contacts

id increments
account_id integer
contact_number string
first_name string
last_name string
phone string
email string
city_id integer
job_id ^FK integer
potentialtity string
timestamps timestamps

accounts

id increments
name string (255)
business_id integer
city_id integer
potentialtity string (255)
due_time datetime
timestamps timestamps

projects

id increments
account_id integer
name string (255)
description string (255)
location string
value float
currency string
probability float
challenges string
timestamps datetime

deals

id increments
name string
description string
due_date datetime
account_id integer
stage string
project_id integer
value integer
total_cost integer
incentive integer
profit integer
timestamps timestamps

tasks

id increments
name string
description string
start_date datetime
due_date datetime
assignees json
account_id integer
status string
deal_id integer
cost float
weight integer
expected_bonus string
timestamps timestamps

events

id increments
name string
objectives string
date datetime
status string
type string
account_id integer
project_id integer
deal_id integer
task_id integer
timestamps timestamps

contact_projects

id increments
contact_id integer
project_id integer

contact_deals

id increments
contact_id ^FK integer
deal_id ^FK integer
timestamps timestamps

contact_events

id increments
contact_id integer
event_id integer
timestamps timestamps

contact_tasks

id increments
task_id integer
project_id integer
contact_id integer
timestamps timestamps

jobs

id increments
job_title string
timestamps timestamps

assignes

id increments
user_id string
model_id ^FK integer
model_name ^FK integer
timestamps timestamps

mentions

id increments
model_id integer
model_name string
timestamps timestamps

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