# Rohan Rajak
- Java, Nodejs
- PSQL, SQL
- Microservices, Nextjs

# Question 1: DB design
User service -

Chat service
- DMs listing (recent message activity)
- channel listing (recent message activity)
- text message
- workspace()

Tables:
1. DM_per_user
cols: workspaceID, sender, time, text, is_read
2. channel_listing_user
cols: workspaceID,channelID, time, text, is_read
workspaceMember
cols: workspaceID, user_id, joined_at
3. messages
cols: workspaceID,users, text, time, is_read
4. workspace
cols: workspaceID, details, created_at.

indexs: sender
text, channelID
text
workspaceID, userID