Community Builder

Database Schema

model User {
  id              String    @id
  // ... other fields

  // Community Builder Tracking
  invitedById     String?
  invitedBy       User?     @relation("CommunityInviter")
  invitedMembers  User[]    @relation("CommunityInviter")
  originalGroupId String?
  originalGroup   Group?    @relation("OriginalGroupMember")
}

Invitation Analytics

Query invitation chains to identify top builders:

// Get top 10 community builders
const topBuilders = await prisma.user.findMany({
  include: {
    _count: {
      select: { invitedMembers: true }
    }
  },
  orderBy: {
    invitedMembers: {
      _count: 'desc'
    }
  },
  take: 10
});

Workflow Schema

model OnboardingWorkflow {
  id          String   @id
  groupId     String
  group       Group    @relation(fields: [groupId])
  name        String
  description String?
  targetRole  UserRole  // MEMBER or GROUP_ADMIN
  steps       Json      // Array of step objects
  isActive    Boolean   @default(true)
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt

  userProgress OnboardingProgress[]
}

Step Structure

{
  "steps": [
    {
      "id": "welcome",
      "title": "Welcome to the Community",
      "description": "Learn about our mission",
      "type": "content",
      "required": true,
      "order": 0
    },
    {
      "id": "profile",
      "title": "Complete Your Profile",
      "description": "Add photo and bio",
      "type": "action",
      "actionType": "complete_profile",
      "required": true,
      "order": 1
    },
    {
      "id": "first-app",
      "title": "Launch Your First App",
      "description": "Try one of our apps",
      "type": "action",
      "actionType": "launch_app",
      "required": false,
      "order": 2
    }
  ]
}

Tracking Progress

model OnboardingProgress {
  id          String   @id
  userId      String
  user        User     @relation(fields: [userId])
  workflowId  String
  workflow    OnboardingWorkflow @relation(fields: [workflowId])

  completedSteps  Json    // Array of completed step IDs
  currentStep     String?
  progress        Float   // 0-100 percentage
  startedAt       DateTime @default(now())
  completedAt     DateTime?

  @@unique([userId, workflowId])
}