I need to design a database for GL accounting, HR and payroll applications with web-based framework CodeIgniter.
1. SPG Material: stock, claim, repacking, book purchasing, accounts payable, input tax
2. Finished Goods: stocks of finished goods, the product, sales, account recivable, exit taxes, bank statements, cash
3. fixed Assets
4. General Accounting: detail sumary, income statement, balance sheet profit and loss
6. Sales, marketing & Promosion
8. HR and payroll system (attendance)
9. Device configuration
10. User roles & policy
11. And backup database
This is only the database structure and query design, exclude a web interface (UI).
Plz check worksheet before bid.