Admin (1 user only)
    │
    ▼
Organization Owner
    │
    ▼
Team Admin
    │
    ▼
Team Member
    │
    ▼
Authenticated User
    │
    ▼
Anonymous Visitor

interface User {
  id: string;                    // Supabase auth ID
  github_id: string;             // GitHub user ID
  github_username: string;       // GitHub username
  avatar_url: string;            // GitHub avatar
  email: string;                 // GitHub email
  created_at: timestamp;         // Registration date
  updated_at: timestamp;         // Last update
  is_admin: boolean;             // Admin flag (only 1 true)
  onboarding_completed: boolean; // Onboarding status
}

interface OrganizationMember {
  id: string;
  user_id: string;
  organization_id: string;
  role: 'owner' | 'member';
  joined_at: timestamp;
}

interface TeamMember {
  id: string;
  user_id: string;
  team_id: string;
  role: 'admin' | 'member';
  joined_at: timestamp;
}

GitHub OAuth Success
    │
    ▼
Check if user exists in Supabase
    │
    ├── No: Create user record
    │       │
    │       ▼
    │   Set onboarding_completed = false
    │       │
    │       ▼
    │   Redirect to /onboarding
    │
    └── Yes: Check onboarding status
            │
            ├── Not completed: /onboarding
            │
            └── Completed: /explorer

User on /explorer (first time)
    │
    ▼
Prompt: "Create your organization"
    │
    ▼
User enters organization name
    │
    ▼
Generate organization_slug
    │
    ▼
Create organization in Supabase
    │
    ▼
Add user as organization owner
    │
    ▼
Redirect to organization dashboard

Organization Owner on /organization/{org}
    │
    ▼
Click "Create Team"
    │
    ▼
Enter team name
    │
    ▼
Generate team_slug
    │
    ▼
Create team under organization
    │
    ▼
Owner automatically becomes team admin

Org Owner/Team Admin
    │
    ▼
Click "Invite Member"
    │
    ▼
Enter GitHub username or email
    │
    ├── User exists on platform
    │       │
    │       ▼
    │   Add to team directly
    │
    └── User not on platform
            │
            ▼
        Send invitation email
            │
            ▼
        User signs up via GitHub
            │
            ▼
        Auto-add to team on signup