CASE FILE // WEB / FULL-STACK - FREELANCE

STUDENT CONSULTATION SYSTEM.

ROLE // FULL-STACK DEVELOPERTIMELINE // 2025STATUS // DELIVERED
NO VISUAL CLASSIFIED

EXECUTIVE SUMMARY

Full-stack platform turning ad-hoc student–professor consultations into a structured, trackable workflow: role-based dashboards, realtime messaging with attachments, an interactive scheduling calendar, and a clear consultation status lifecycle.

SYSTEM HIGHLIGHTS

  • Role-based interfaces for students, professors, and admins
  • Realtime messaging and calendar scheduling with status lifecycle (pending → approved → ongoing → completed)
  • Profile management with photo cropping; dashboard analytics; announcements

CORE ARCHITECTURE

  • Three-tier: React frontend, Express API, PostgreSQL database
  • JWT auth with refresh tokens; bcrypt hashing; parameterized queries
  • Sharp-based image pipeline; response-level caching on hot read endpoints
SYS_UPLINK // DOWNLOAD