We are updating a system developed in Delphi that stored the data in access tables for PostgreSQL. So far so good, however, I came across the following situation:
In the old bank we had the following tables to store the movements:
- notafiscal
- notafiscalitem
- request
- request
- coupon
- coupon
- notes entered
- notesinfo
To standardize I thought of grouping everything by making it easy to update fields and group everything into a single table (sic):
- handling
- handling
Creating a field that would differ from one release to the next.
Can this cause slowness? Is it an acceptable technique? What are the pros and cons?