pos - Laravel Schema Designer

users

id increments
store_id ^FK integer
name string (191)
mobile string (191)
password string (255)
father_name string (191)
mother_name string (191)
national_id string (191)
type enum
address text
rememberToken rememberToken
timestamps timestamps

stores

timestamps timestamps
id increments
name string (191)
location string (191)

customers

id increments
name string (191)
mobile string (191)
father_name string (191)
mother_name string (191)
national_id string (191)
address text
store_id ^FK integer
timestamps timestamps

suppliers

id increments
name string (191)
address text
mobile string (191)
store_id ^FK integer
timestamps timestamps

categories

id increments
category_name string (191)
timestamps timestamps

products

id increments
category_id ^FK integer
product_name string (191)
model_name string (191)
model_code string (191)
color_code string (191)
color_image string (191)
timestamps timestamps

stocks

id increments
stock_type enum
sales_id ^FK integer
purchase_id ^FK integer
customer_id ^FK integer
supplier_id ^FK integer
product_id ^FK integer
quantity double (10,2)
buying_price double (10,2)
selling_price double (10,2)
subtotal double (10,2)
total_vat double (10,2)
total_discount double (10,2)
store_id ^FK integer
timestamps timestamps

purchases

id increments
store_id ^FK integer
supplier_id ^FK integer
subtotal double (10,2)
total_discount double (10,2)
total_vat double (10,2)
timestamps timestamps

sales

id increments
store_id ^FK integer
sales_type enum
customer_id ^FK integer
subtotal double (10,2)
total_discount double (10,2)
total_vat double (10,2)
timestamps timestamps

hires

id increments
customer_id ^FK integer
jamindar_name string (191)
payment_method string (191)
down_payment double (10,2)
due_balance double (10,2)
installament_price double (10,2)
term integer
timestamps timestamps

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