Sprint 2 — Social Account Service

[zerexei]

Sprint Dates: 2026-07-13 to 2026-07-17 (Monday to Friday only)

Goal: Connect and manage social platform accounts.

Tasks & Sub-tasks

• Social Accounts Schema
  • Create social_accounts table
  • Store provider, external_user_id, status
  • Encrypt access + refresh tokens in DB
  • Add unique constraints per provider/user
• OAuth Infrastructure
  • Implement OAuth redirect endpoints
  • Implement callback handlers
  • Normalize token storage & implement automatic refresh
• Platform Integrations
  • Meta (Facebook Pages) OAuth integration & permission fetch
  • LinkedIn OAuth integration & page scope request
  • Twitter/X OAuth integration & profile validation
• Account Management APIs
  • List connected platforms
  • Disconnect/revoke platform access