Wondering if anyone can help me with this little chesnut??
I am developing an app that has two different user types, lets say, student and teacher.
A teacher or a student can both create "a group" and a regular user can then search through all of these groups together. So there is no real difference between the two as far as a regular user can see.
Is it best practise to separate this into two tables so I would have a student_group table and a teacher_group table?
My question is how do you group the two together so the two can be displayed in search results?