Event Data Model

A complete reference for the event data model stored in biztechEvents. Every field that defines an event, where it comes from, and what uses it.

Primary Key

The same id can be reused across years — blueprint + 2025 and blueprint + 2026 are separate events.

Core Fields

Pricing

The payments service reads pricing.members or pricing.nonMembers based on the user's isMember status to set the Stripe checkout session amount.

Registration Questions

Each question object:

{
  "questionId": "uuid-abc-123",
  "type": "TEXT",
  "label": "Why do you want to attend?",
  "required": true,
  "options": ["Option A", "Option B"]
}

Question types (frontend): TEXT, SELECT, CHECKBOX, UPLOAD, WORKSHOP_SELECTION, SKILLS

The questionId is auto-assigned by addIdsToRegistrationQuestions() in services/events/helpers.js if not already present. UUIDs are generated with uuid.v4().

On update (PATCH), the handler checks each question — if questionId is missing, it assigns a new UUID to that question while preserving existing IDs.

Feedback Questions

Each feedback question object:

{
  "questionId": "uuid-def-456",
  "type": "LINEAR_SCALE",
  "label": "How would you rate this event overall?",
  "required": true,
  "scaleMin": 1,
  "scaleMax": 10,
  "scaleMinLabel": "Poor",
  "scaleMaxLabel": "Excellent"
}

Feedback question types: SHORT_TEXT (280 char limit), LONG_TEXT (4000 char limit), MULTIPLE_CHOICE, CHECKBOXES, LINEAR_SCALE

Default Overall Rating Question

Both attendeeFeedbackQuestions and partnerFeedbackQuestions always have this question prepended at index 0:

{
  "questionId": "overall-rating",
  "type": "LINEAR_SCALE",
  "label": "How would you rate this event overall?",
  "required": true,
  "scaleMin": 1,
  "scaleMax": 10,
  "scaleMinLabel": "Poor",
  "scaleMaxLabel": "Excellent"
}

This is injected by ensureDefaultOverallRatingQuestion() in feedbackHelpers.js on both create and update. It cannot be removed — the function strips any existing question with questionId === "overall-rating" and re-prepends the default.

Validation Rule

Enabling a feedback form (attendeeFeedbackEnabled: true) requires at least one question beyond the default. The handler returns 406 if you try to enable feedback with zero custom questions.

Legacy Fields

These fields exist on the event schema but are from older versions of the registration system:

The new system uses registrationQuestions and attendeeFeedbackQuestions/partnerFeedbackQuestions instead.

GSI: event-overview

The event-overview GSI is used by getAll to scan all events efficiently. Used by:

• GET /events/ — lists all events
• GET /events/getActiveEvent — finds the currently active event

Full Example Record

{
  "id": "blueprint",
  "year": 2026,
  "ename": "Blueprint 2026",
  "description": "UBC's premier product and design conference",
  "partnerDescription": "Join as a sponsor to connect with 200+ students",
  "startDate": "2026-01-25T09:00:00.000Z",
  "endDate": "2026-01-25T18:00:00.000Z",
  "deadline": "2026-01-20T23:59:59.000Z",
  "capac": 200,
  "elocation": "UBC Nest Ballroom",
  "longitude": -123.246,
  "latitude": 49.2606,
  "imageUrl": "https://biztech-event-images.s3.us-west-2.amazonaws.com/event-thumbnails/blueprint/optimized/1735689600000.jpg",
  "pricing": {
    "members": 0,
    "nonMembers": 5
  },
  "isPublished": true,
  "isCompleted": false,
  "isApplicationBased": false,
  "nonBizTechAllowed": false,
  "registrationQuestions": [
    {
      "questionId": "q-why-attend",
      "type": "TEXT",
      "label": "Why do you want to attend Blueprint?",
      "required": true
    },
    {
      "questionId": "q-workshop",
      "type": "SELECT",
      "label": "Which workshop track?",
      "required": true,
      "options": ["Product Design", "UX Research", "Prototyping"]
    }
  ],
  "partnerRegistrationQuestions": [],
  "attendeeFeedbackEnabled": true,
  "partnerFeedbackEnabled": true,
  "attendeeFeedbackQuestions": [
    {
      "questionId": "overall-rating",
      "type": "LINEAR_SCALE",
      "label": "How would you rate this event overall?",
      "required": true,
      "scaleMin": 1,
      "scaleMax": 10,
      "scaleMinLabel": "Poor",
      "scaleMaxLabel": "Excellent"
    },
    {
      "questionId": "q-enjoyed",
      "type": "SHORT_TEXT",
      "label": "What did you enjoy most?",
      "required": false
    }
  ],
  "partnerFeedbackQuestions": [
    {
      "questionId": "overall-rating",
      "type": "LINEAR_SCALE",
      "label": "How would you rate this event overall?",
      "required": true,
      "scaleMin": 1,
      "scaleMax": 10,
      "scaleMinLabel": "Poor",
      "scaleMaxLabel": "Excellent"
    }
  ],
  "createdAt": 1735689600000,
  "updatedAt": 1735689600000
}

Where Each Field Is Used

Related Pages

• Events System Overview — how events fit into the platform
• Event Creation Flow — how the form data becomes a record
• Events Service — endpoint reference
• Event Feedback Backend — feedback question validation details