Activities

The ActivityId field is a primary key in the Activity table, designed to uniquely identify each activity record. It has a data type of nvarchar with a maximum length of 32 characters, allowing for the storage of alphanumeric identifiers. This ensures that each activity can be distinctly referenced and efficiently retrieved within the database. The use of nvarchar accommodates a wide range of character sets, providing flexibility for internationalization and special characters.

A brief textual overview of the activity, allowing for up to 128 characters of alphanumeric input, providing context and details about the specific activity recorded in the database.

The BadgeCaption field is an nvarchar data type with a maximum length of 32 characters in the Activity table. This field is designed to store a brief descriptive label or caption for a badge associated with a specific activity, providing a concise identification that enhances user engagement and recognition.

Stores the Image of the Badge that should be displayed for the Activity.