Infrastructure & Supporting Systems

/api/articles           GET: List articles    POST: Create article
/api/articles/[id]      GET: Get article      PUT: Update          DELETE: Delete
/api/auth/session       GET: Check auth status
/api/chatbot/stream     POST: Stream chatbot response
/api/schedule/available POST: Get available time slots
/api/schedule/book      POST: Create booking

{
  "data": {
    "id": "abc123",
    "title": "Platform Architecture",
    "content": "...",
    "publishedAt": "2024-11-08T12:00:00Z"
  },
  "meta": {
    "timestamp": "2024-11-08T14:30:00Z"
  }
}

{
  "data": {
    "id": "xyz789",
    "status": "created"
  },
  "meta": {
    "timestamp": "2024-11-08T14:30:00Z"
  }
}

{
  "error": {
    "code": "VALIDATION_ERROR",
    "message": "Title is required",
    "details": {
      "field": "title",
      "constraint": "required"
    }
  },
  "meta": {
    "timestamp": "2024-11-08T14:30:00Z"
  }
}

query GetArticle($slug: String!) {
  article(slug: $slug) {
    id
    title
    content
    publishedAt
    author {
      name
      avatar
      bio
    }
    tags {
      name
      slug
      articleCount
    }
  }
}

query GetRecentArticles($limit: Int!, $offset: Int!) {
  articles(limit: $limit, offset: $offset, orderBy: PUBLISHED_DESC) {
    id
    title
    excerpt
    publishedAt
    tags {
      name
    }
  }
  articlesCount
}

model User {
  id            String    @id @default(cuid())
  email         String    @unique
  name          String?
  avatar        String?
  role          Role      @default(VIEWER)
  articles      Article[]
  createdAt     DateTime  @default(now())
  updatedAt     DateTime  @updatedAt
}

enum Role {
  VIEWER   // Read-only
  EDITOR   // Can create/edit content
  ADMIN    // Full access
}

model Article {
  id            String     @id @default(cuid())
  title         String
  slug          String     @unique
  content       String     @db.Text
  excerpt       String?
  published     Boolean    @default(false)
  publishedAt   DateTime?
  views         Int        @default(0)
  authorId      String
  author        User       @relation(fields: [authorId], references: [id])
  tags          Tag[]
  createdAt     DateTime   @default(now())
  updatedAt     DateTime   @updatedAt
  
  @@index([slug])
  @@index([published, publishedAt])
  @@index([authorId])
}

model Booking {
  id                String    @id @default(cuid())
  name              String
  email             String
  date              DateTime
  duration          Int       @default(30)
  timezone          String
  notes             String?   @db.Text
  status            String    @default("confirmed")
  googleEventId     String?   @unique
  googleMeetLink    String?
  confirmationSent  Boolean   @default(false)
  createdAt         DateTime  @default(now())
  updatedAt         DateTime  @updatedAt
  
  @@index([email, date])
  @@index([date, status])
}

model ChatAnalytics {
  id              String    @id @default(cuid())
  sessionId       String
  messageCount    Int
  avgResponseTime Float
  userSatisfaction Float?
  topics          String[]
  createdAt       DateTime  @default(now())
  
  @@index([sessionId])
  @@index([createdAt])
}

# Create migration from schema changes
pnpm prisma migrate dev --name add_booking_status

# Apply migrations in production
pnpm prisma migrate deploy

# Generate TypeScript types
pnpm prisma generate

// BAD: N+1 query problem
const articles = await prisma.article.findMany();
for (const article of articles) {
  const author = await prisma.user.findUnique({ where: { id: article.authorId }});
  // This runs N queries!
}

// GOOD: Single query with include
const articles = await prisma.article.findMany({
  include: {
    author: true,
    tags: true
  }
});
// Single query fetches everything

logger.info('Booking created', {
  bookingId: 'abc123',
  email: 'user@example.com',
  date: '2024-11-10T14:00:00Z',
  duration: 30,
  timezone: 'America/New_York'
});