Hello,
Basic question, but want to make sure I configure my database correctly.
I have three tables:
- users
- teams
- conversations
Say I want to return all conversations that are part of the team the user is assigned to. Is the best way of handling this to create reference fields in all three tables and add logic similar to this in the SQL query?
Any help is greatly appreciated!
Regards,
Gio