Working on a hobby project, have 0 database design experience, and trying to wrap my head around how to model the following.
I have an appointments, users, and tutors table.
Each appointment will have 1 user and 1 tutor.
In this situation can I use a one-to-many relationship where I link one appointment to one user and one tutor.
Or does it make more sense to make the appointment table the many-to-many third table, which takes a user and a tutor?
I feel like it should probably be many-to-many, but a second opinion would be great based on my lack of experiance