Your question is Group Chat Schema and Caching. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Design a database schema and caching layer for a messaging platform that supports group chats with up to 100,000 members, as used in Sendbird deployments.