Data Model

{
  _id: ObjectId,
  ownerUserId: string,    // Clerk user ID
  name: string,           // Project name
  createdAt: Date
}

{
  _id: ObjectId,
  projectId: ObjectId,    // Reference to projects._id
  label: string,          // Display name (e.g., "Production")
  keyHash: string,        // SHA-256 hash of key:pepper
  keyPreview: string,     // "mtr_a1b2...ef01"
  createdAt: Date,
  lastUsedAt?: Date,      // Updated on each ingestion
  revokedAt?: Date        // Set when key is revoked
}

{
  _id: ObjectId,
  projectId: ObjectId,    // Reference to projects._id
  name: string,           // Event name (e.g., "pageview")
  path?: string,          // Page path
  url?: string,           // Full URL
  referrer?: string,      // HTTP referrer
  metadata?: object,      // Custom key-value data
  sessionId?: string,     // Session identifier
  visitorId?: string,     // Visitor identifier
  occurredAt: Date,       // When the event happened
  ip?: string,            // Client IP (from x-forwarded-for or connection)
  userAgent?: string,     // Client User-Agent
  browser?: string,       // Server-side parsed browser name
  os?: string,            // Server-side parsed OS name
  deviceType?: string,    // Server-side parsed device category (desktop, mobile, tablet)
  country?: string,       // Vercel-resolved 2-letter country code
  city?: string,          // Vercel-resolved city name
  region?: string,        // Vercel-resolved region code
  createdAt: Date         // When the server received it
}