online_shop - Laravel Schema Designer

users

id increments
parent_id ^FK bigInteger
username string (100)
password string
type tinyInteger
created_by bigInteger
created_by_ip string (15)
updated_by bigInteger
updated_by_ip string (15)
timestamps timestamps
softDeletes softDeletes

customers

id increments
name string
mobile_no string (15)
address string
created_by bigInteger
created_by_ip string (15)
updated_by bigInteger
updated_by_ip string (15)
timestamps timestamps
softDeletes softDeletes

categories

id increments
name string
created_by bigInteger
created_by_ip string (15)
updated_by bigInteger
updated_by_ip string (15)
timestamps timestamps
softDeletes softDeletes

products

id increments
category_id ^FK bigInteger
name string
timestamps timestamps
softDeletes softDeletes

inventories

id increments
product_id ^FK bigInteger
purchase_date date
order_id ^FK bigInteger
buying_price decimal (10,2)
selling_price decimal (10,2)
cr mediumInteger
dr mediumInteger
timestamps timestamps
softDeletes softDeletes

orders

id increments
customer_id ^FK bigInteger
order_id bigInteger
order_date date
shipping_address string
mobile_no string (15)
net_amount decimal (10,2)
status tinyInteger
timestamps timestamps
softDeletes softDeletes

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