ecom - Laravel Schema Designer

products

id increments
product_code string (20)
product_name string (255)
product_title string (255)
product_subtitle string (255)
product_description string (255)
product_stock integer
cost float (10,2)
display_price float
is_active boolean
product_avg_rating integer
timestamps timestamps

sellers

id increments
users_id integer
seller_name string (50)
seller_address string (255)
seller_phone string (20)
seller_alt_phone string (20)
seller_role string (50)
seller_rating integer
is_active boolean
timestamps timestamps

categories

id increments
name string (255)
display_name string (255)
short_description string (255)
description string (255)
rating integer
is_active boolean
timestamps timestamps

offers

id increments
offer_id string (20)
offer_type string (20)
offer_name string (255)
offer_description string (255)
on_number_of_items integer
discount_amount float (5,5)
expiration_timing string (50)
is_active boolean
timestamps timestamps

product_material

id increments
timestamps timestamps
softDeletes softDeletes
name string (50)

brands

id increments
timestamps timestamps
softDeletes softDeletes

brand_models

id increments
timestamps timestamps
softDeletes softDeletes

coupon_codes

id increments
coupon_id string (50)
timestamps timestamps
softDeletes softDeletes
is_active string (2)

faqs

id increments
timestamps timestamps

reviews

id increments
timestamps timestamps

product_compare

id increments
timestamps timestamps
softDeletes softDeletes

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