Leadership Operating System Database Tables

lo_accountability_chart
    ├── Visionary (seat)
    ├── Integrator (seat)
    └── Department Heads
            └── Team Leads
                    └── Individual Contributors

lo_role_definitions (defines each seat):
    - GWC (Get it, Want it, Capacity)
    - Key responsibilities
    - Core metrics

lo_seat_assignments (who sits in each seat):
    - employee_id
    - seat_id
    - is_primary

interface VisionDocument {
  // Core Values
  core_values: string[];
  
  // Core Focus
  purpose: string;        // Why we exist
  niche: string;          // What we do best
  
  // 10-Year Target
  ten_year_target: string;
  
  // Marketing Strategy
  target_market: string;
  three_uniques: string[];
  proven_process: string;
  guarantee: string;
  
  // 3-Year Picture
  three_year_revenue: number;
  three_year_profit: number;
  three_year_measurables: string[];
  
  // 1-Year Plan
  one_year_revenue: number;
  one_year_profit: number;
  one_year_goals: Goal[];
}

interface Rock {
  id: string;
  title: string;
  description: string;
  quarter: string;          // 'Q1-2026'
  fiscal_year_id: string;
  owner_id: string;         // Primary owner
  status: RockStatus;
  completion_percent: number;
  due_date: string;
  completed_date?: string;
  milestones: Milestone[];
}

interface ScorecardMetric {
  id: string;
  name: string;
  owner_id: string;
  goal: number;
  goal_direction: GoalDirection;
  frequency: 'weekly' | 'monthly';
  display_order: number;
}

1. Segue (5 min) - Good news
2. Scorecard Review (5 min)
3. Rock Review (5 min)
4. Customer/Employee Headlines (5 min)
5. To-Do List (5 min)
6. IDS (60 min) - Identify, Discuss, Solve
7. Conclude (5 min)

interface OneOnOne {
  id: string;
  manager_id: string;
  employee_id: string;
  scheduled_date: string;
  actual_date?: string;
  duration_minutes: number;
  topics_discussed: string[];
  action_items: string[];
  employee_notes?: string;  // Private to employee
  manager_notes?: string;   // Private to manager
  shared_notes?: string;    // Visible to both
}

const { data } = await supabase
  .from('lo_accountability_chart')
  .select(`
    *,
    role:lo_role_definitions(*),
    assignments:lo_seat_assignments(
      employee:hr_employees(first_name, last_name, photo_url)
    )
  `)
  .eq('organization_id', orgId)
  .is('parent_id', null)  // Start from top
  .order('display_order');

const { data } = await supabase
  .from('lo_quarterly_rocks')
  .select(`
    *,
    owner:pf_profiles(first_name, last_name),
    milestones:lo_rock_milestones(*)
  `)
  .eq('organization_id', orgId)
  .eq('quarter', currentQuarter)
  .order('status');

const { data } = await supabase
  .from('lo_scorecard_metrics')
  .select(`
    *,
    owner:pf_profiles(first_name, last_name),
    values:lo_scorecard_values(
      value,
      period_date
    )
  `)
  .eq('scorecard_id', scorecardId)
  .order('display_order');

const { data } = await supabase
  .from('lo_issues')
  .select(`
    *,
    created_by:pf_profiles(first_name, last_name),
    discussions:lo_issue_discussions(*)
  `)
  .eq('organization_id', orgId)
  .eq('status', 'open')
  .order('priority')
  .order('created_at');

const { data } = await supabase
  .from('lo_meetings')
  .select(`
    *,
    attendees:lo_meeting_attendees(
      attendee:pf_profiles(first_name, last_name)
    ),
    action_items:lo_meeting_action_items(*)
  `)
  .eq('organization_id', orgId)
  .eq('meeting_type', 'level_10')
  .gte('scheduled_date', new Date().toISOString())
  .order('scheduled_date');

lo_seat_assignments → hr_employees
lo_gwc_assessments → hr_employees (performance data)
lo_one_on_ones → hr_employees (manager/employee)

lo_meetings → pf_tasks (action items become tasks)
lo_issues → pf_notifications (issue assignments)