CRM - Laravel Schema Designer

targeted_customers

id increments
customer_name string
address string
city_id string
last_status_id string
notes string
specialize_id string
current_stage_id string
next_stage_id string
timestamps timestamps

specializations

id increments
major string
minor string
timestamps timestamps

targeted_customers_phones

id increments
targeted_customers_id string
phone string
timestamps timestamps

contact_persons

id increments
targeted_customers_id string
name string
job string
phone1 string
phone2 string
email string
timestamps timestamps

status

id increments
targeted_customers_id string
status string
timestamps timestamps

target_customer_stage

id increments
targeted_customers_id string
stage_id integer
is_open boolean
description string
date string
notes string
created_by string
timestamps timestamps

stages

id increments
name string (255)
has_reminder boolean
timestamps timestamps

erp_common_cities

id increments
name string
status string
timestamps timestamps

crm_log

id increments
created_by string
log string
timestamps timestamps

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