I am writing an e-sports website where I allow users to register as a team to compete with others. Team and Users are many-to-many relation ship. One team will have many members, members can join in different team. On my website also have more than one competition that allow user to register.
I am confused on how to link this two tables with a bridge entity.
I have an idea which is ONE user is allowed to REGISTER the team which means the ONE user will have to enter other 4 members' MEMBERID on the website.
I am having a problem which is cannot connect all these tables.
Member TABLE, Team TABLE, [TeamMemberList] Table as bridge table
When the user register a team which has 5 member ids inserted into the TeamMemberList table which is the bridge entity connect TEAM and MEMBER table.
Is my idea wrong?