dropbuy - Laravel Schema Designer

users

id increments
name string (255)
email string (255)
phone string (50)
role integer
status integer
last_login datetime
email_verify_status enum
phone_verify_status enum
api_token string (255)
password string (255)
profilePic string (255)
softDeletes softDeletes
timestamps timestamps

merchantProfiles

id increments
user_id integer
email string (255)
phone string (50)
business_name string (255)
manager_name string (255)
address string (255)
lat string (255)
long string (255)
coverImage string (255)
logo string (255)
tax_number string (255)
softDeletes softDeletes
timestamps timestamps

driverProfiles

id increments
user_id integer
vehicle_type ^FK integer
address string (255)
softDeletes softDeletes
timestamps timestamps

vechileTypes

id increments
name string (255)
max_volumetric string (255)
max_weight string (255)
image string (255)
softDeletes softDeletes
timestamps timestamps

address_book

id increments
name string (255)
lat string (255)
long string (255)
user_id integer
softDeletes softDeletes
timestamps timestamps

categories

id increments
name string (255)
parent_category integer
softDeletes softDeletes
timestamps timestamps

coupen

id increments
name string (255)
amount double
description string (255)
image string (255)
start_date datetime
end_date datetime
status integer
softDeletes softDeletes
timestamps timestamps

custom_attributes

id increments
timestamps timestamps
softDeletes softDeletes
field_name string (255)
field_value string (255)
field_type string (255)
field_label string (255)
required boolean

categoryattributes

id increments
timestamps timestamps
softDeletes softDeletes
custom_attributes_id ^FK integer
category_id ^FK integer
showinsearch boolean

products

id increments
timestamps timestamps
softDeletes softDeletes
category_id ^FK integer
categorietree string (255)
name string (255)
description string (255)
price double
offerprice double
status enum
approvel_note string (255)
user_id ^FK integer
store_id ^FK integer
location_lat string (255)
location_long string (255)

productImages

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK integer
url string (255)

productAttribute

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK integer
custom_attributes_id ^FK integer
attribute_value string (255)

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