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)
image 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

customer

customer_id increments
f_name string (255)
m_name string (255)
l_name string (255)
email string
password string (255)
phone string (255)
timestamps timestamps

shipping

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

order

order_id increments
customer_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

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