Database Schema

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider  = "postgresql"
  url       = env("DATABASE_URL")
  directUrl = env("DIRECT_URL") // Optional: for Supabase migrations
}

model User {
  id           String        @id @default(cuid())
  email        String        @unique
  name         String
  displayName  String?
  password     String
  avatarUrl    String?
  createdAt    DateTime      @default(now())
  updatedAt    DateTime      @updatedAt
  
  hostedRooms  Room[]        @relation("HostedRooms")
  participants Participant[]
  messages     Message[]
  
  @@index([email])
}

model Room {
  id           String        @id @default(cuid())
  code         String        @unique
  name         String
  hostId       String
  isActive     Boolean       @default(true)
  isLocked     Boolean       @default(false)
  startedAt    DateTime      @default(now())
  endedAt      DateTime?
  createdAt    DateTime      @default(now())
  updatedAt    DateTime      @updatedAt
  
  host         User          @relation("HostedRooms", fields: [hostId], references: [id])
  settings     RoomSettings?
  participants Participant[]
  messages     Message[]
  
  @@index([code])
  @@index([hostId])
}

model RoomSettings {
  id                     String  @id @default(cuid())
  roomId                 String  @unique
  allowChat              Boolean @default(true)
  allowScreenShare       Boolean @default(true)
  allowGuestAccess       Boolean @default(true)
  waitingRoom            Boolean @default(false)
  muteParticipantsOnJoin Boolean @default(false)
  isLocked               Boolean @default(false)
  maxParticipants        Int     @default(100)
  
  room Room @relation(fields: [roomId], references: [id], onDelete: Cascade)
}

model Participant {
  id         String    @id @default(cuid())
  roomId     String
  userId     String?
  guestName  String?
  isActive   Boolean   @default(true)
  isHost     Boolean   @default(false)
  joinedAt   DateTime  @default(now())
  leftAt     DateTime?
  
  room Room  @relation(fields: [roomId], references: [id], onDelete: Cascade)
  user User? @relation(fields: [userId], references: [id])
  
  @@index([roomId])
  @@index([userId])
}

// Example: Creating participant record
await this.prisma.participant.create({
  data: {
    roomId: room.id,
    userId: userId,           // null for guests
    guestName: userId ? null : displayName,  // set for guests
    isHost,
  },
});

model Message {
  id         String      @id @default(cuid())
  roomId     String
  userId     String?
  senderName String?
  content    String
  type       MessageType @default(TEXT)
  createdAt  DateTime    @default(now())
  
  room Room  @relation(fields: [roomId], references: [id], onDelete: Cascade)
  user User? @relation(fields: [userId], references: [id])
  
  @@index([roomId])
  @@index([createdAt])
}

enum MessageType {
  TEXT
  SYSTEM
  FILE
}

const room = await prisma.room.create({
  data: {
    code: generateRoomCode(),
    name: "Team Meeting",
    hostId: userId,
    settings: {
      create: {
        allowChat: true,
        allowScreenShare: true,
        maxParticipants: 50,
      },
    },
  },
  include: {
    settings: true,
  },
});

// Verify room exists and is active
const room = await this.prisma.room.findUnique({
  where: { code: roomCode },
  include: { settings: true },
});

if (!room) {
  throw new Error("Room not found");
}

if (!room.isActive) {
  throw new Error("Room is no longer active");
}

if (room.isLocked) {
  throw new Error("Room is locked");
}

// Add participant to database
await this.prisma.participant.create({
  data: {
    roomId: room.id,
    userId: userId,
    guestName: userId ? null : displayName,
    isHost,
  },
});

const rooms = await prisma.room.findMany({
  where: {
    hostId: userId,
    isActive: true,
  },
  include: {
    settings: true,
    participants: {
      where: { isActive: true },
    },
  },
  orderBy: {
    startedAt: 'desc',
  },
});

{
  "db:generate": "prisma generate",
  "db:push": "prisma db push",
  "db:migrate": "prisma migrate dev",
  "db:studio": "prisma studio"
}

// Good: Single query with include
const messages = await this.prisma.message.findMany({
  where: { roomId: room.id },
  orderBy: { createdAt: "asc" },
  take: 50,
  include: {
    user: {
      select: { id: true, name: true, displayName: true },
    },
  },
});