Training App LMS Features

apps/command-center/src/features/training/content/
├── courses/
│   ├── ai-orchestration-fundamentals/
│   │   ├── course.config.ts          # Course metadata
│   │   ├── Lesson01BuildingBlocks.tsx # React component
│   │   ├── Lesson02Workflows.tsx
│   │   └── FinalAssessment.tsx       # Uses LessonQuiz
│   └── sales-fundamentals/
│       └── ...
├── certifications/
│   └── certifications.config.ts      # Certification definitions
└── registry.ts                       # Auto-discovers courses

// apps/command-center/src/features/training/content/types.ts
interface CourseConfig {
  slug: string
  title: string
  description: string
  audience: 'internal' | 'developer' | 'customer' | 'public'
  estimatedDuration: string
  lessons: LessonConfig[]
  assessments?: AssessmentConfig[]
  certification?: CertificationRequirement
}

interface LessonConfig {
  slug: string
  title: string
  duration: string
  order: number
  component: React.ComponentType
}

interface AssessmentConfig {
  slug: string
  title: string
  passingScore: number  // 0-100
  questions: TypeformQuestion[]
}

interface CertificationRequirement {
  certificationSlug: string
  requiredLessons: 'all' | string[]
  requiredAssessments?: { slug: string; minScore: number }[]
}

-- Lesson completion tracking
CREATE TABLE training_progress (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id UUID NOT NULL REFERENCES users(id),
  organization_id UUID NOT NULL REFERENCES organizations(id),
  course_slug TEXT NOT NULL,
  lesson_slug TEXT NOT NULL,
  completed_at TIMESTAMPTZ NOT NULL DEFAULT now(),
  UNIQUE(user_id, course_slug, lesson_slug)
);

-- Assessment results
CREATE TABLE training_assessments (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id UUID NOT NULL REFERENCES users(id),
  organization_id UUID NOT NULL REFERENCES organizations(id),
  course_slug TEXT NOT NULL,
  assessment_slug TEXT NOT NULL,
  score DECIMAL(5,2) NOT NULL,
  passed BOOLEAN NOT NULL,
  answers JSONB,
  attempted_at TIMESTAMPTZ NOT NULL DEFAULT now()
);

-- Awarded certifications
CREATE TABLE training_certifications (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id UUID NOT NULL REFERENCES users(id),
  organization_id UUID NOT NULL REFERENCES organizations(id),
  certification_slug TEXT NOT NULL,
  awarded_at TIMESTAMPTZ NOT NULL DEFAULT now(),
  UNIQUE(user_id, certification_slug)
);

-- Example policy structure (applied to all 3 tables)
CREATE POLICY "Platform admins have full access"
  ON training_progress TO authenticated
  USING (current_user_is_platform_admin());

CREATE POLICY "Org admins can manage training"
  ON training_progress TO authenticated
  USING (is_org_admin(organization_id));

CREATE POLICY "Users have full access to own data"
  ON training_progress TO authenticated
  USING (user_id = current_user_supabase_id());

CREATE FUNCTION public.current_user_supabase_id() RETURNS uuid AS $$
  SELECT id FROM users WHERE workos_user_id = (auth.jwt() ->> 'sub')::text
$$ LANGUAGE sql STABLE SECURITY DEFINER;

// apps/command-center/src/features/training/content/courses/ai-orchestration-fundamentals/Lesson01BuildingBlocks.tsx
import { LessonContainer, Callout, KeyTakeaways } from '@repo/ui'
import { Stack, Text } from '@mantine/core'

export default function Lesson01BuildingBlocks() {
  return (
    <LessonContainer
      title="The Building Blocks"
      subtitle="AI Orchestration Fundamentals"
      duration="8 min"
    >
      <Stack gap="xl">
        <Text>In this lesson, you'll learn the core building blocks...</Text>

        <Callout type="info" title="What you'll learn">
          <Text>- Core platform concepts</Text>
          <Text>- How AI agents work</Text>
          <Text>- Basic workflow patterns</Text>
        </Callout>

        <KeyTakeaways items={[
          'Workflows orchestrate step-by-step processes',
          'Agents make intelligent decisions',
          'Integrations connect external services'
        ]} />
      </Stack>
    </LessonContainer>
  )
}

apps/command-center/src/routes/training/
├── index.tsx                     # Training dashboard
├── courses/
│   ├── index.tsx                 # Course catalog
│   └── $courseSlug/
│       ├── index.tsx             # Course overview with SubshellSidebar
│       └── $lessonSlug.tsx       # Lesson viewer
├── assessments/
│   └── $courseSlug/$assessmentSlug.tsx  # Quiz page
└── certifications/
    └── index.tsx                 # My certifications

// Example: Progress tracking hook
import { useSupabase } from '@repo/ui/supabase'
import { useMutation, useQuery } from '@tanstack/react-query'

export function useMarkComplete() {
  const { client } = useSupabase()

  return useMutation({
    mutationFn: async ({ courseSlug, lessonSlug }) => {
      const { error } = await client
        .from('training_progress')
        .upsert({ course_slug: courseSlug, lesson_slug: lessonSlug })
      if (error) throw error
    }
  })
}