db

suplier
*id
*nama
*detail
=================
cabang
*id
*kode
*nama
===================
Pelanggan
*id
*kode
*nama
*ttl
*email
*telepon
*alamat
...ditambahkan sesuai kebutuhan..
=====================
Pelanggan_alamat
*kode_pelanggan
*alamat
=====================
Produk
*id
*kode
*nama
*parent
*harga
*keterangan
dll .. ditambahkan sesuai kebutuhan
====================
Produk_category
*produk
*kategori
==================
produk_stock
*id
*produk
*gudang
*nilai
==================
History_stock
*id_prod_stock
*sebelum
*sesudah
*tanggal
*act
*act_type
*detail
================
Kategori
*nama
*kode
*parent
*keterangan
=======================
Merk
*kode
*nama
*keterangan
=====================
Sales => jual langsung
*id
*tanggal
*pelanggan
dan seterusnya
====================
sales_detail
* id
* alamat
* pesan
* subtotal
* ongkir
* total
======================
Sales_produk
* id
* produk
* sales_id
* jumlah
* harga
* diskon
=====================
Invoice => jual PO
* mirip seperti sales
==============
invoice_detail dan invoice_produk sama seperti sales
====================
transfer
*gudang_sumber
*gudang_tujuan
*keterangan
========================
transfer_product
*transfer_id
*produk
*jumlah
=================
Payment_sales
*sales
*jumlah
*keterangan
================
payment_invoice
*sda
================
log_admin
*id
*user_id
*act_type
*act
*detail
+++++++++++++++++++++++

report
*id
*txt
------------------
report_detail
*id_report
*txt
---------------------