Private Group Coaching Infrastructure

Act as a Senior Product Designer and Full-Stack Architect. Your task is to design the comprehensive specification for a SaaS platform named "Cohort OS," the operating system for running structured group coaching and cohort programs.

The design must prioritize a clean, professional, and intuitive Coach-First User Experience (UX).

Goal: Provide a detailed, structured specification covering the architecture, core features, user flows, and necessary data models required to build this platform using the specified stack.

Core Features & Requirements:

1. Program Builder (Coach View):

   • The coach must be able to define a program, including: Program Name, total Session Count, Cadence (weekly/bi-weekly), Maximum Participant Capacity, Pricing structure, and Start Date.
   • Each Session must be individually defined with a Title, a required Pre-work Assignment, and a Post-session Reflection Prompt.

2. Participant Portal (Student View):

   • Participants must have a centralized dashboard showing their personal program timeline, visibility of upcoming sessions, access to submitted assignments, and a dedicated space for viewing peer reflections.

3. Assignment & Feedback Flow:

   • Submission: Participants must be able to submit assignments (written text or links) prior to each session.
   • Coach Review: The coach must have a centralized view of all submissions, allowing them to provide personalized, written feedback directly on each submission.
   • Peer Feedback Rounds: Implement an automated, structured peer feedback mechanism. After each session, participants must be prompted to provide one piece of structured feedback to one other participant. The system must ensure balanced rotation so every participant gives and receives feedback equally.

4. Progress & Engagement Tracking (Coach Dashboard):

   • The coach dashboard must feature clear metrics: Assignment Completion Rate per participant, Attendance tracking, and a calculated, simple Engagement Score for the cohort.

5. Certification System:

   • Upon program completion, the system must automatically generate a professional, downloadable PDF Certificate for each participant, clearly including the Participant Name, Program Name, Coach Name, and Completion Date.

Technical Stack & Constraints:

• Frontend: React (Focus on component architecture and state management).
• Backend/Database: Supabase (Specify the necessary table structures for Programs, Sessions, Participants, Assignments, and Feedback).
• Payments: Stripe Connect (Detail the necessary flow for handling coach payouts and participant enrollment fees).
• Communication: Resend (Specify the trigger points for automated session reminders and peer feedback prompts).
• Design Constraint: The entire system must adhere to a clean, professional aesthetic, prioritizing clarity and ease of navigation for the coach.

Desired Output Format:
Provide a high-level technical specification, including:

1. Conceptual Database Schema Outline (Key tables and relationships).
2. A defined User Flow Diagram for the core process (Program Setup -> Enrollment -> Session -> Feedback -> Completion).
3. A suggested component/feature breakdown mapping the requirements to the chosen stack.