Cross Chats

[varunsingh87]

Cross Chats

Ability for teammates to chat with someone they invited or who requested to join (each a "team switcher") the team.

Requirements

• Two participants in the same competition on different teams may send private messages ("direct chat") to each other in a chat window for the purpose of deciding whether to switch teams
  • To initiate a private chat, one participant invites and the other must accept.
• All participants of a team and a participant in the same competition but on a different team may send messages in a group chat window for the purpose of deciding whether to join the team ("group chat")
• These chat windows are accessible from a list of all of the team switcher chats, which appear under the Find Teammates tab

Software Design

Schema Changes

New table: direct_chats

Initiator	Receiver	Competition	Status
USER_1	USER_2	COMPETITION_1	0
USER_1	USER_3	COMPETITION_1	1

New table: group_chats

Team	Potential_Joiner	Competition	Status
TEAM_1	USER_4	COMPETITION_1	1
TEAM_2	USER_5	COMPETITION_3	1

New table: direct_messages

Chat	Sender
CHAT_1	USER_3
CHAT_2	USER_5
CHAT_1	USER_2

New table: group_messages

Chat	Sender
CHAT_1	USER_3
CHAT_2	USER_5
CHAT_1	USER_2

Rename table: messages --> team_messages