🗄️ Activity Suggestion Session

Data Entity Details | Generated by Eircodex v1.0.0

📊 Activity Suggestion Session Entity

Tracks individual user sessions interacting with the activity suggestion algorithm, including spins, selections, and completions.

audit 🔑 Primary Key: session_id

📈 Entity Statistics

📋 Attributes

11

1 required, 1 unique

🔍 Indexes

2

Database performance indexes

✅ Validations

1

Data integrity rules

⚡ Operations

0

Allowed CRUD operations

📝 Entity Overview

The Activity Suggestion Session entity captures detailed user interactions with the activity suggestion algorithm, enabling measurement of engagement, effectiveness, and user behavior patterns. This data supports evaluation of the platform's impact on physical activity levels and informs continuous improvement. By tracking sessions, the organization can demonstrate value to stakeholders and optimize the user experience to maximize health benefits.

Implementing this entity requires robust session tracking integrated with the activity-suggestion-engine, ensuring accurate capture of user actions such as spins, selections, and completions. The entity must support efficient querying for analytics and comply with data retention policies. Coordination with analytics and data governance teams is necessary. The entity's audit nature demands high data integrity and validation, particularly for session timestamps.

From a technical standpoint, the Activity Suggestion Session entity is stored in a relational database within the activity-data-repository. It includes arrays for activities suggested, selected, and completed, requiring appropriate schema design and serialization. Validation rules enforce logical consistency of timestamps. CRUD operations are managed by the activity-suggestion-engine component, which records and updates session data in real time. Indexes on user_id and timestamp_start optimize retrieval for reporting.

📋 Data Structure

Name Type Description Constraints
id uuid Unique identifier for activity suggestion session REQUIRED UNIQUE
session_id PK string Unique identifier for the suggestion session. PRIMARY KEY
user_id string Identifier of the user participating in the session. -
timestamp_start string Start time of the session. -
timestamp_end string End time of the session. -
activities_suggested array List of activity IDs suggested during the session. -
activities_selected array List of activity IDs selected by the user. -
activities_completed array List of activity IDs marked as completed by the user. -
location_id string Identifier of the location where the session took place. -
weather_snapshot string Weather conditions at the time of the session. -
device_type string Type of device used (e.g., mobile, tablet). -

🔍 Database Indexes

Index on user_id

Columns: user_id

Index on timestamp_start

Columns: timestamp_start

✅ Validation Rules

undefined

error

Ensure timestamp_end is after timestamp_start.

📐 Business Rules

undefined

undefined

All user interactions with the activity suggestion algorithm must be recorded for analytics and evaluation.

⚡ CRUD Operations

➕ CREATE

Not Allowed

👁️ READ

Not Allowed

✏️ UPDATE

Not Allowed

🗑️ DELETE

Not Allowed

💾 Storage Configuration

Storage Type: relational_database
Location: activity-data-repository