erd

Creating bussiness role Many to many relationship


Just a question to know if my logic are true or not? I'm kinda confuse here either to use 1-M relationship or M-M relationship

I have table user and Event

(User can join multiple event that they want)

Can I do this relationship as M-M ?


Solution

  • Yes, you should use a many-to-many relationship, because one user can participate in several events and an event consists of several users.