What does the invoice database look like?

Question

Database design

What does the architecture of the database of bank accounts look like, banks have clients, each client has a personal account, clients can also have businesses, each also needs an account. It is necessary to make a structure in which, having received a client, we will receive all his accounts. The problem is that the client and the business are 2 different entities, that is, they cannot be combined into 1 table.

Answer 1

Offhand, you can use this structure as a directory to access specific entities:
GenericEntities: AccType (enum), AccID (int), col1, col2, ...
Although building a database of bank accounts requires knowledge in accounting and banking. But if you create something simple that does not claim to be great, then you need to start somewhere and change it according to your needs along the way.
I googled and this is what I found:
https://towardsdatascience.com/how-to-build-an-acc...
https://stackoverflow.com/questions/23811912/datab...

Answer 2

No one will tell you how it looks in banks because of the NDA. In addition, there are very specific tasks and different databases.