ecommerce - Laravel Schema Designer

category

category_id increments
category_name string (255)
category_description text
url string (255)
status enum
timestamps timestamps

brand

brand_id increments
brand_name string (255)
brand_description string (255)
url string (255)
status enum
timestamps timestamps

product

product_id increments
product_name string (255)
category_id ^FK integer
brand_id ^FK integer
width string (255)
height string (255)
description text
product_price string (255)
quantity integer
url string (255)
status enum
timestamps timestamps

user

user_id increments
f_name string (255)
m_name string (255)
l_name string (255)
password string (255)
phone string (255)
timestamps timestamps
email string
role_id ^FK integer

shipping

shipping_id increments
shipping_name string (255)
shipping_address text
shipping_email string (255)
shipping_phone integer
timestamps timestamps
order_id ^FK integer

order

order_id increments
user_id ^FK integer
shipping_id ^FK integer
payment_id ^FK integer
order_total integer
order_status enum
order_date string (255)
timestamps timestamps

payment

payment_id increments
payment_method string (255)
payment_status enum
payment_date string (255)
timestamps timestamps

order_details

order_details_id increments
order_id ^FK integer
product_id ^FK integer
product_name string (255)
product_price string (255)
product_sales_quantity integer
timestamps timestamps

role

role_id increments
timestamps timestamps
permission string
role string

address

address_id increments
timestamps timestamps
adress1 string
address2 string
user_id ^FK integer

image

id increments
timestamps timestamps
product_id ^FK integer
link string
alt string

cart

id increments
timestamps timestamps
user_id ^FK integer
product_id ^FK integer

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