Live Chat ~ Chat App Tables - uchicago-cs/chigame GitHub Wiki

LiveChat

• id (Autoincrementing Primary Key)
• name (String)
• users (ManyToManyField to User)

LiveChatMessage

• id (Autoincrementing Primary Key)
• live_chat (Foreign Key to LiveChat)
• user (Foreign Key to User)
• sent_at (DateTimeField)
• content (String)
• reply_to (Foreign Key to Self)

LiveChatUser

• id (Autoincrementing Primary Key)
• user (Foreign Key to User)
• live_chat (Foreign Key to LiveChat)

LiveChatMessageReaction

• id (Autoincrementing Primary Key)
• user (Foreign Key to User)
• message (Foreign Key to LiveChatMessage)
• content (validated Char, max=10)

LiveChatPollOption

• id (Autoincrementing Primary Key)
• content (String)

LiveChatPoll

• id (Autoincrementing Primary Key)
• live_chat (Foreign Key to LiveChat)
• question (String)
• options (ManyToManyField to LiveChatPollOption)
• created_at (DateTimeField)
• updated_at (DateTimeField)

LiveChatPollVote

• id (Autoincrementing Primary Key)
• poll (Foreign Key to LiveChatPoll)
• option (Foreign Key to LiveChatPollOption)
• user (Foreign Key to User)