The app uses the following data stores:
All these resources are created in your Azure subscription. None are hosted directly by Microsoft.
Carousel - Stores the carousel metadata that are getting displayed on home page.
| Column |
Description |
| Id |
Primary key identifier for this table. |
| Link |
External link to be viewed by clicking the carousel. |
| Title |
Header of the carousel. |
| Thumbnail |
Link of photo to be displayed in carousel from blob storage. |
| Description |
Short definition of carousel. |
| IsActive |
Determines whether the carousel is deleted or not. |
| Created |
Date and time of creation. |
| CreatedBy |
Identifies the user who created the carousel. |
| LastModified |
Date and time of the last modification. |
| LastModifiedBy |
Identifies the user who recently modified the carousel. |
ChallengeInvities - stores the metadata for share challenge workflow.
| Column |
Description |
| Id |
Primary key identifier for this table. |
| From |
Sender of the challenge invite. |
| To |
Recepient of the challenge invite. |
| ChallengeId |
Determines the challenge that was shared. |
| Title |
Header of the notification. |
| Message |
Short definition of notification. |
| IsAccepted |
Identifies whether the recipient accepted the challenge. |
| Created |
Date and time of creation. |
| CreatedBy |
Identifies the user who created the carousel. |
| LastModified |
Date and time of the last modification. |
| LastModifiedBy |
Identifies the user who recently modified the carousel. |
ChallengeRecords - Stores the metadata for accepted and completed challenges of the users.
| Column |
Description |
| Id |
Primary key identifier for this table. |
| UserId |
Sender of the challenge invite. |
| ChallengeId |
Indetifier of challenge. |
| ChallengePoint |
Current point of the challenge upon acceptance/completion. |
| Status |
States whether the challenge is accepted,completed or abandoned. (0 = Accepted, 1 = Completed, 2 = Abandoned) |
| Created |
Date and time of creation. |
| CreatedBy |
Identifies the user who created the carousel. |
| LastModified |
Date and time of the last modification. |
| LastModifiedBy |
Identifies the user who recently modified the carousel. |
ChallengeRecordSummaries - Stores the summarized data of accumulated points of the users from completed challenges.
| Column |
Description |
| Id |
Primary key identifier for this table. |
| UserId |
Identifies the owner of challenge record summary. |
| CurrentPoints |
Latest accumulated points of the user. |
| Created |
Date and time of creation. |
| CreatedBy |
Identifies the user who created the carousel. |
| LastModified |
Date and time of the last modification. |
| LastModifiedBy |
Identifies the user who recently modified the carousel. |
Challenges - data store for metadata of challenges.
| Column |
Description |
| Id |
Primary key identifier for this table. |
| Title |
Header of the challenge. |
| Points |
Number of points that can be accumulated upon completion of challenge. |
| Thumbnail |
Link of photo to be displayed in challenge card from blob storage. |
| Description |
Definition of challenge. |
| ActiveUntil |
Determines until when the challenge is active. |
| Recurrence |
Determines whether the challenge is one time or daily. |
| FocusArea |
Focus area of the challenge. |
| AdditionalResources |
Additional links for references of the challenge. |
| IsActive |
Determines whether the challenge is deleted or not. |
| IsPinned |
Identifies whether the challenge is pinned or not (max of 4). |
| Created |
Date and time of creation. |
| CreatedBy |
Identifies the user who created the carousel. |
| LastModified |
Date and time of the last modification. |
| LastModifiedBy |
Identifies the user who recently modified the carousel. |
Roles - Stores the data of roles.
| Column |
Description |
| Id |
Primary key identifier for this table. |
| Name |
Name of the role. |
| Created |
Date and time of creation. |
| CreatedBy |
Identifies the user who created the carousel. |
| LastModified |
Date and time of the last modification. |
| LastModifiedBy |
Identifies the user who recently modified the carousel. |
SiteConfigs - Stores the configuration of the application.
| Column |
Description |
| Id |
Primary key identifier for this table. |
| ServiceType |
Determines whether the config is for Yammer or SharePoint. |
| URI |
Web URL of the resource (SharePoint / Yammer). |
| IsEnabled |
Determines whether the service should be enabled or disabled. |
| IsNewsEnabled |
Determines whether the news should be shown or not for SharePoint config. |
| IsEventsEnabled |
Determines whether the events should be shown or not for SharePoint config. |
| Created |
Date and time of creation. |
| CreatedBy |
Identifies the user who created the carousel. |
| LastModified |
Date and time of the last modification. |
| LastModifiedBy |
Identifies the user who recently modified the carousel. |
| Value |
Description |
| necsus-appreg-secret |
Contains the secret of App Registration. |
| necsus-blob-connectionstring |
Connection string of Azure Storage Account. |
| necsus-blob-key |
Key of Azure Storage Account. |
| necsus-sql-connection-string |
Connection string of Azure SQL Server. |
| Container |
Description |
| photos |
Contains the thumbnails and cover photo of carousel and challenges. |