I would like some advices concerning the 2 tables of my database on the image below. These 2 transaction tables are almost identical. One is a transaction with clients who do not have access to the app and the other is transactions between users. The transactions between colleagues must be validated by the user receiver.
I was thinking of merging them but since these are the tables that will be used the most in the database. I’m wondering in terms of performance and queries, is it better to merge the tables or to leave them as it is.
My first option would be to merge them since it is the best thing to do in terms of database optimization and when I do a search, I would filter by null or empty field (client / recipient). And take off the option set transactionFor Since this is my first bubble project and while doing some research about bubble I noticed that there are sometimes constraints with queries and database design. That’s why I need your advice.