Guest Profiles — House of Legends

Reservation Made
      │
      ▼
QR Code Received (via email/WhatsApp)
      │
      ▼
Guest Arrives → Scan QR at Venue
      │
      ▼
Profile Created/Linked
      │
      ├──► Reaction (WAVE/CHEERS/HEART other guests)
      ├──► Photo Wall (submit photo, like others)
      ├──► Lucky Spin (win comp items)
      └──► Google Review Challenge (earn rewards)

{
  "reservationId": "abc123",
  "token": "guest-token-xyz",
  "showDate": "2026-05-15"
}

guestProfiles: defineTable({
  reservationId: v.optional(v.id("reservations")),
  tableId: v.optional(v.id("tables")),
  token: v.string(),
  googleId: v.optional(v.string()),
  facebookId: v.optional(v.string()),
  email: v.optional(v.string()),
  avatarUrl: v.optional(v.string()),
  nickname: v.string(),
  origin: v.string(),
  moodTags: v.array(v.string()),
  bio: v.optional(v.string()),
  showDate: v.string(),
  checkedIn: v.boolean(),
  createdAt: v.number(),
  updatedAt: v.number(),
})
  .index("by_reservation", ["reservationId"])
  .index("by_show_date", ["showDate"])
  .index("by_token", ["token"]);

guestReactions: defineTable({
  fromProfileId: v.id("guestProfiles"),
  toProfileId: v.id("guestProfiles"),
  reactionType: v.union(
    v.literal("WAVE"),
    v.literal("CHEERS"),
    v.literal("HEART"),
  ),
  showDate: v.string(),
  createdAt: v.number(),
})
  .index("by_to_profile", ["toProfileId"])
  .index("by_from_profile", ["fromProfileId"])
  .index("by_show_date", ["showDate"]);

Step 1: Scan QR → Token validated
Step 2: Login with Google/Facebook (or skip)
Step 3: Enter nickname
Step 4: Select mood tags (multi-select)
Step 5: Select origin (dropdown)
Step 6: Profile created → Redirect to experience