WMS - Laravel Schema Designer

store_category

id increments
name string
timestamps timestamps
softDeletes softDeletes

store

id increments
name string
capacity float
current_capacity float
status boolean
location_id ^FK bigInteger
store_category_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

product_category

id increments
name string
timestamps timestamps
softDeletes softDeletes

product

id increments
name string
description string
product_category_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

distribution_center

id increments
name string
user_id ^FK bigInteger
location_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

sell_order

id increments
distribution_center_id ^FK bigInteger
description string
timestamps timestamps
softDeletes softDeletes

sell_bill

id increments
number integer
sell_order_id ^FK bigInteger
description string
timestamps timestamps
softDeletes softDeletes

users

id increments
fname string
lname string
email string
password string
phone integer
timestamps timestamps
softDeletes softDeletes

store_product

id increments
product_id ^FK bigInteger
store_id ^FK bigInteger
quantity integer
timestamps timestamps

store_user

id increments
user_id ^FK bigInteger
store_id ^FK bigInteger
timestamps timestamps

sell_order_item

id increments
sell_order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
timestamps timestamps

sell_bill_item

id increments
sell_bill_id ^FK bigInteger
sell_order_item_id ^FK bigInteger
price float
quantity integer
timestamps timestamps

book_out

id increments
store_id ^FK bigInteger
sell_bill_item_id ^FK bigInteger
date date
quantity integer
timestamps timestamps

fill_order

id increments
user_id ^FK bigInteger
description string
timestamps timestamps

fill_order_item

id increments
fill_order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
timestamps timestamps

fill_bill

id increments
number integer
fill_order_id ^FK bigInteger
description string
timestamps timestamps

fill_bill_item

id increments
fill_bill_id ^FK bigInteger
fill_order_item_id ^FK bigInteger
price float
quantity integer
timestamps timestamps

book_in

id increments
store_id ^FK bigInteger
fill_bill_item_id ^FK bigInteger
date date
quantity integer
timestamps timestamps

state

id increments
name string
timestamps timestamps

location

id increments
name string
state_id ^FK bigInteger
timestamps timestamps

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