Returning Rows that Pertain to a Team which a Specific User is a Member Of


Basic question, but want to make sure I configure my database correctly.

I have three tables:

  1. users
  2. teams
  3. 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!



I think what you have should be fine...though I guess it depends on what you are trying to display to the user...Could a user be on more than one team? I guess you would want to display user's names as well?