crm_db - Laravel Schema Designer

leads

id increments
timestamps timestamps
softDeletes softDeletes
type enum
client_id mediumInteger
owner_id mediumInteger
phase_id mediumInteger
marketing_channel_id mediumInteger
communication_method_id mediumInteger
note longText
campaign_name string
referred_by string

phases

id increments
timestamps timestamps
softDeletes softDeletes
name string

marketing_channels

id increments
timestamps timestamps
softDeletes softDeletes
name string

communication_methods

id increments
timestamps timestamps
softDeletes softDeletes
name string

phones

id increments
timestamps timestamps
softDeletes softDeletes
model_name string
model_id mediumInteger
phone string

property_specifications

id increments
timestamps timestamps
softDeletes softDeletes
purchase_type enum
priority_level enum
payment_method enum
now tinyInteger
received_date datetime
area_of_interest string
budget_from double
budget_to double
size_from double
size_to double
budget_measureme string
size_measurement string
type_id mediumInteger
purpose_id integer
view_id mediumInteger
number_of_rooms tinyInteger
bathrooms_number_from tinyInteger
floor_number tinyInteger
finishing smallInteger
furnished tinyInteger
ready_to_move tinyInteger
note longText
lead_id mediumInteger

property_specification_projects

id increments
timestamps timestamps
softDeletes softDeletes
property_specification_id mediumInteger
project_id mediumInteger

types

id increments
timestamps timestamps
softDeletes softDeletes
name string

purposes

id increments
timestamps timestamps
softDeletes softDeletes
name string

views

id increments
timestamps timestamps
softDeletes softDeletes
name string

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
phone string

projects

id increments
timestamps timestamps
softDeletes softDeletes
name string

project_stages

id increments
timestamps timestamps
softDeletes softDeletes
name string
date_created datetime
delivery_date datetime
note text
project_id integer

groups

id increments
timestamps timestamps
softDeletes softDeletes
name string
note string
project_stage_id string

roots

id increments
timestamps timestamps
softDeletes softDeletes
name string
note longText
group_id mediumInteger

models

id increments
timestamps timestamps
softDeletes softDeletes
root_id mediumInteger
name string
type_id mediumInteger
purpose_id mediumInteger
size double
size_measureme string
view_id mediumInteger
number_of_rooms smallInteger
bathrooms_number_from smallInteger
floor_number smallInteger
finishing smallInteger
furnished tinyInteger
ready_to_move tinyInteger
budget double
budget_measureme string

model_properties

id increments
timestamps timestamps
softDeletes softDeletes
model_id mediumInteger
property_id mediumInteger

properties

id increments
timestamps timestamps
softDeletes softDeletes
name string

comforts

id increments
timestamps timestamps
softDeletes softDeletes
name string

model_comforts

id increments
timestamps timestamps
softDeletes softDeletes
model_id mediumInteger
comfort_id mediumInteger

lead_comments

id increments
timestamps timestamps
softDeletes softDeletes

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