---
# System prepended metadata

title: Rohan Rajak

---

# 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


