Hi,
I have a users table for auth, inside I have a table ref to a 'managers table'
My plan was to then have a user_id ref to the user table in the managers table as a list to create teams. In my head i feel it makes it more streamlined to get data for employee tables in the front end however, i also feel that it then makes two places that you have to remeber to edit, delete etc… when required.
I have read that its not wise to duplicate data however, with the potential of have a huge user table will having to search for team members based on the manager become difficult over time and potentially slow?
TIA, this community is super helpful!!!