Webshop - Laravel Schema Designer

customers

Id increments
Firstname string (45)
Email string (45)
Password string (45)
Lastname string (45)
Phone string (45)
City string (70)
PostalCode string (12)
Country string (60)
State string (45)
timestamps timestamps

orders

Id increments
Date datetime
ShippedDate datetime
Status string (45)
Customer_Id ^FK integer
timestamps timestamps

products

id increments
Name string (250)
Description longText
InStock integer
Price double
Category ^FK integer
timestamps timestamps

image

id increments
Product_ID ^FK integer
Path string (500)
timestamps timestamps

order_details

Order_ID ^FK integer
Product_ID ^FK integer
Amount integer
PriceEach double
timestamps timestamps

categories

id increments
Name string (50)
Description string (200)
Image longText
Parent ^FK integer
timestamps timestamps

users

id increments
Username string (45)
Password string (45)
Email string (65)
timestamps timestamps

payments

id increments
Amount double
Customer_ID ^FK integer
timestamps timestamps

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