inventory
id
store_id
product_id
barcode
quantity
restock_threshold
cost_price
selling_price
vat_rate
notes
last_stocked_at
modified_by
modified_at
deleted_at
created_at
updated_at


products
id
product_name
barcode
category_id
unit
cost_price
selling_price
vat_rate
image_path
created_at
updated_at


stock entries
id
store_id
product_id
quantity
cost_price
purchase_date
remarks
added_by
created_at
updated_by
updated_at
supplier_id

stock transfer log

	id	product_id	from_store_id	to_store_id	quantity	transfer_date	transferred_by	remarks	

	

sales items

id	transaction_id	product_id	quantity	unit_price	discount	vat_rate	total_price	created_at	

