Data store

The app uses the following data stores:

Azure Storage Account

All these resources are created in your Azure subscription. None are hosted directly by Microsoft.

PersonalGoalDetail table

The PersonalGoalDetail table stores the personal goal details.

Attribute	Comment
Partition Key	Azure Active Directory object id of the user.
Row Key	PersonalGoalId as a unique GUID id.
AdaptiveCardActivityId	Activity id of the adaptive card.
IsActive	Value indicating whether personal goal cycle is active.
IsAligned	Value indicating whether personal goal is aligned with team goal.
IsDeleted	Value indicating whether personal goal is deleted.
IsReminderActive	Value indicating whether user wants to receive reminders.
ConversationId	Conversation id of the personal chat with bot on 1:1
GoalName	Goal Name of the goal created.
Status	Status of the each personal goal i.e. not started/in progress/completed.
Start date	Start date of the personal goal.
End date	End date of the personal goal.
ReminderFrequency	Reminder frequency of the personal goal i.e. fortnight/monthly/quarterly.
TeamId	Team id to identify in which team user has aligned his/her personal goals.
TeamGoalId	Unique id of each team goal to identify personal goal is aligned with.
EndDateUTC	Personal goal end date in UTC format to fetch the records from storage for sending goal reminder to personal bot.
ServiceUrl	Service endpoint where operations concerning the referenced conversation.
CreatedOn	Date at which personal goals are created.
CreatedBy	Name of the user who created the personal goals.
LastModifiedOn	Date at which personal goals are updated.
LastModifiedBy	Name of user who modified the personal goals.

The TeamGoalDetail table stores the team goal details.

Attribute	Comment
Partition Key	Team Id in which bot is installed.
Row Key	TeamGoalId as a unique GUID id.
AdaptiveCardActivityId	Activity id of the adaptive card.
IsActive	Value indicating whether team goal cycle is active.
IsDeleted	Value indicating whether team goal is deleted.
IsReminderActive	Value indicating whether user wants to receive reminders.
ConversationId	Conversation id of the team
TeamGoalName	Goal Name of the goal created.
TeamGoalStartDate	Start date of the team goals.
TeamGoalEndDate	End date of the team goals.
TeamGoalEndDateUTC	Team goal end date in UTC format to fetch the records from storage for sending goal reminder in team.
ReminderFrequency	Reminder frequency of the team goals i.e. fortnight/monthly/quarterly.
ServiceUrl	Service endpoint where operations concerning the referenced conversation.
CreatedOn	Date at which personal goals are created.
CreatedBy	Name of the user who created the personal goals.
LastModifiedOn	Date at which personal goals are updated.
LastModifiedBy	Name of user who modified the personal goals.

The PersonalGoalNoteDetail table stores the personal goal note details.

Attribute	Comment
Partition Key	Azure Active Directory object id of the user.
Row Key	PersonalGoalNoteId as a unique GUID id.
PersonalGoalId	Unique id of each personal group.
AdaptiveCardActivityId	Activity id of the adaptive card.
ConversationId	The conversation id of the personal chat with bot on 1:1.
PersonalGoalNoteDescription	Note description for individual personal goal.
SourceName	source name of user from which note is shared.
IsActive	Value indicating whether personal goal cycle is active
CreatedOn	Date at which personal goals are created.
CreatedBy	Name of the user who created the personal goals.
LastModifiedOn	Date at which personal goals are updated.
LastModifiedBy	Name of user who modified the personal goals.