Elrwad - Laravel Schema Designer

branches

id increments
timestamps timestamps
softDeletes softDeletes
name string
user_id integer

vendors

id increments
timestamps timestamps
softDeletes softDeletes
name string
phone string
code string
user_id integer

stores

id increments
timestamps timestamps
softDeletes softDeletes
name string
branch_id integer
user_id integer

products

id increments
timestamps timestamps
softDeletes softDeletes
name string
store_id integer
buy_price double
sell_price double
code string
user_id integer
quantity integer

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string
address string
g_name string
g_phone string
g_address string
code string
phone string
user_id integer

invoices

id increments
timestamps timestamps
softDeletes softDeletes
amount double
invoice_number string
client_name string
branch_id integer
user_id integer

invoiceitems

id increments
timestamps timestamps
softDeletes softDeletes
invoice_id integer
product_id integer
quantity integer
price double
total_price double
user_id integer

installmentinvoices

id increments
timestamps timestamps
softDeletes softDeletes
client_id integer
branch_id integer
sell_price double
base_price double
pre_amount double
remain_amount double
start_at date
count integer
amount double
system integer
paid double
note string
user_id integer

installmentpayments

id increments
timestamps timestamps
softDeletes softDeletes
type enum
amount double
installment_id integer
note string
user_id integer

bills

id increments
timestamps timestamps
softDeletes softDeletes
amount double
branch_id integer
invoice_number string
vendor_id integer
user_id integer

installmentitems

id increments
timestamps timestamps
softDeletes softDeletes
product_id integer
quantity integer
base_price string
price double
total_price double
installment_id integer
user_id integer

vendorpayments

id increments
timestamps timestamps
softDeletes softDeletes
amount double
note string
vendor_id integer
user_id integer

billitems

id increments
timestamps timestamps
softDeletes softDeletes
product_id integer
quantity integer
price double
total_price double
bill_id integer
user_id integer

accounts

id increments
timestamps timestamps
softDeletes softDeletes
name string
open_balance double
balance double
user_id integer

accounthistories

id increments
timestamps timestamps
softDeletes softDeletes
account_id integer
amount double
note string
user_id integer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string

expenses

id increments
timestamps timestamps
softDeletes softDeletes
account_id integer
amount double
date datetime
note text
type enum
expense_item string
user_id integer

returned

id increments
timestamps timestamps
softDeletes softDeletes
branch_id integer
invoice_id integer
invoice_type enum
account_id string
user_id integer
total double

returned_items

id increments
timestamps timestamps
softDeletes softDeletes
returned_id integer
product_id integer
price double
quantity integer
total double

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