challengeSubmissions: defineTable({
  profileId: v.id("guestProfiles"),
  orderId: v.id("orders"),
  tableId: v.id("tables"),
  challengeType: v.literal("GOOGLE_REVIEW"),
  screenshotUrl: v.string(),
  status: v.union(
    v.literal("PENDING"),
    v.literal("APPROVED"),
    v.literal("REJECTED"),
  ),
  rewardMenuItemId: v.optional(v.id("menuItems")),
  reviewedBy: v.optional(v.id("users")),
  reviewedAt: v.optional(v.number()),
  notes: v.optional(v.string()),
  showDate: v.string(),
  createdAt: v.number(),
})
  .index("by_status", ["status"])
  .index("by_show_date", ["showDate"])
  .index("by_table_show", ["tableId", "showDate"]);

challengeConfig: defineTable({
  challengeType: v.union(
    v.literal("PHOTO_WALL"),
    v.literal("LUCKY_SPIN"),
    v.literal("GOOGLE_REVIEW"),
  ),
  enabled: v.boolean(),
  maxValue: v.optional(v.number()),
  prizeDescription: v.optional(v.string()),
  steps: v.array(
    v.object({
      order: v.number(),
      text: v.string(),
      imageUrl: v.optional(v.string()),
    }),
  ),
  activeForDates: v.array(v.string()),
  createdAt: v.number(),
  updatedAt: v.number(),
}).index("by_type", ["challengeType"]);