I ask you to advise on the development of a Web application, how to implement accounting and a database?

Question

MySQL

Greetings, it took the need to implement an application accounting system.
The essence of the system is to track: the order of positions by the foreman, the approval of the order by 2 departments, the search for a supply supplier, payment by the accounting department, delivery to the warehouse (status on the way), arrival at the warehouse (notification of the foreman), and the cost of each item in the order.
Some positions require a passport.
There can be several suppliers for one position, there can be several invoices from one supplier, pre and post - payment.
Having summarized everything in a table, I have not yet come up with a better implementation option.

The question is how to build a database for faster work. To store everything in different tables and to connect through ID?
There is a need to filter by all fields, select by supplier, search for an order by invoice (invoice), orders by: object, manager, foreman, and others...

Answer 1

I worked in the same organization, with similar tasks, only there were millions of data. DB - MSSQL, did a pretty good job + monitor queries well, conduct tests, and see where it loads, and which query fails. And almost all the data was in one table with more than 150 columns.
There were also binders, where there were quite a few speakers, and they had to be tied, otherwise there was a complete bacchanalia. Everything was done to limit the number of requests to the database, and in principle everything works pretty well.

Answer 2

ARX2 Split , draw tables, then draw connections of these tables.
This way you can build a flexible system.
user - employees
group - departments
supplier - suppliers
order - orders
order_approval - in this table record the order-IDs and (user-IDs or department-IDs) that must approve the order.
order_supplier - relationship between supplier and order
order_payments - payments
, etc.