MarketingSystem - Laravel Schema Designer

products

id increments
timestamps timestamps
softDeletes softDeletes
name string
price string
expire_date string
in_stock integer

orders

id increments
timestamps timestamps
number_of_product integer
location string
client_id integer
price double

order_details

id increments
timestamps timestamps
order_id integer
product_id integer
price string
quantity double
total string

promitions

id increments
timestamps timestamps
promo_code string
product_id string
promo_name string
discount string

employees

id increments
timestamps timestamps
name string
salary string
address string

stocks

id increments
timestamps timestamps
name string
location string

product_in_stocks

id increments
timestamps timestamps
product_id integer
stock_id integer
available_quantity integer
quantity integer

invoices

id increments
timestamps timestamps
code string
total string
discoun decimal
order_id string

invoice_details

id increments
timestamps timestamps
invoice_id integer
product_id integer
price string
quantity string
promo_code string

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