Information for the Streak

Columns

• Id (datatype: int) Required Primary Key
• StreakTypeId (datatype: int) Required Primary Key
• PersonAliasId (datatype: int) Required Primary Key
• EnrollmentDate (datatype: date) Required Primary Key
• LocationId (datatype: int) Required Primary Key
• EngagementMap (datatype: varbinary) Required Primary Key
• CurrentStreakStartDate (datatype: datetime) Required Primary Key
• CurrentStreakCount (datatype: int) Required Primary Key
• LongestStreakStartDate (datatype: datetime) Required Primary Key
• LongestStreakEndDate (datatype: datetime) Required Primary Key
• LongestStreakCount (datatype: int) Required Primary Key
• EngagementCount (datatype: int) Required Primary Key
• CreatedDateTime (datatype: datetime) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• CreatedByPersonAliasId (datatype: int) Required Primary Key
• ModifiedByPersonAliasId (datatype: int) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• InactiveDateTime (datatype: datetime) Required Primary Key
• ExclusionMap (datatype: varbinary) Required Primary Key