1
Hello, thinking about performance and also good practices, what would be the ideal in this scenario?
3 objects: - Enterprise - Person representing the company - Visit (object of a commercial visit by a seller)
For me to display the information to the user would it be better if I leave as in the image below? respecting the hierarchy or could repeat data, placing the customer id also in the table of visits not to need to give a Join?
I have seen them use both forms, each with its pros and cons. According to good practices, the ideal is to keep everything separate. But to facilitate the queries, you can use the repeated data, speeding up the search in the bank. It is at your discretion.
– Italo Rodrigo
Already law regarding [tag:] ?
– Don't Panic