amazon - Laravel Schema Designer

products

id increments
category_id ^FK integer
name string
price double
unit_id ^FK integer
timestamps timestamps

stocks

id increments
product_id ^FK integer
categoty_id ^FK integer
value integer
user_id ^FK integer
order_id ^FK integer
import_id ^FK integer
timestamps timestamps

orders

id increments
user_id ^FK integer
date date
price double
remark longText
order_status tinyInteger
timestamps timestamps

users

id increments
username string
password string
name string
phone string
address longText
address_stock longText
type tinyInteger
timestamps timestamps

categorys

id increments
name string
timestamps timestamps

units

id increments
name string
timestamps timestamps

imports

id increments
user_id ^FK integer
date date
price double
remark string
import_status tinyInteger
timestamps timestamps

order_items

id increments
order_id ^FK integer
product_id ^FK integer
stock_id ^FK integer
value integer
timestamps timestamps

import_items

id increments
import_id ^FK integer
product_id ^FK integer
stock_id ^FK integer
value integer
timestamps timestamps

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