clientdb - Laravel Schema Designer

clients

id increments
name string (255)
shortname string (64)
supplier tinyInteger
manufacturer tinyInteger
timestamps timestamps
softDeletes softDeletes

addressbook

id increments
parent_id bigInteger
address1 string (255)
address2 string (255)
address3 string (255)
city string (100)
state string (100)
country string (100)
pincode integer
landmark string (100)
timestamps timestamps
softDeletes softDeletes

contacts

id increments
client_id bigInteger
name string (64)
mobile string (10)
email string (255)
designation string (100)
department string (100)
timestamps timestamps
softDeletes softDeletes

leads

id increments
title string (255)
source string (16)
status string (16)
client_id bigInteger
user_created_id integer
user_assigned_id integer
user_monitor_id string (255)
timestamps timestamps
softDeletes softDeletes

users

id increments
timestamps timestamps

quotes

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
description string (255)
lead_id bigInteger
contact_id bigInteger
address_id integer
user_created_id integer
status string (16)

clientproperties

id increments
client_id integer
property_name string (64)
property_details string (100)
timestamps timestamps
softDeletes softDeletes

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