ecomerce - Laravel Schema Designer

clients

id increments
name string
email string
password string (250)
phone string (11)
timestamps timestamps

orders

id increments
client_id ^FK integer
address_id ^FK integer
pay enum
status enum
total decimal
timestamps timestamps

order_product

id increments
product_id ^FK integer
order_id ^FK integer
price decimal
quantity integer
timestamps timestamps

products

id increments
category_id ^FK integer
photo text
title string (100)
price decimal
quantity integer
description text
status boolean
timestamps timestamps

product_photos

id increments
product_id ^FK integer
photo text
timestamps timestamps

categories

id increments
title string (100)
photo text
timestamps timestamps

reviews

id increments
client_id ^FK integer
product_id ^FK integer
body text
rate integer
timestamps timestamps

countries

id increments
title string (100)
timestamps timestamps

governorates

id increments
country_id ^FK integer
title string (100)
timestamps timestamps

cities

id increments
title string (100)
governorate_id ^FK integer
timestamps timestamps

addresses

id increments
city_id ^FK integer
client_id ^FK integer
address_line text
timestamps timestamps

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