Table: AchievementType

Database schema and system attributes for AchievementType.

---

AchievementFailureWorkflowTypeId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AchievementIconCssClass

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 200

AchievementStartWorkflowTypeId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AchievementStepStatusId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AchievementStepTypeId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AchievementSuccessWorkflowTypeId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AchieverEntityTypeId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AllowOverAchievement

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

AlternateImageBinaryFileId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

BadgeLavaTemplate

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = -1

CategoryId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ComponentConfigJson

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = -1

ComponentEntityTypeId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CreatedByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CreatedDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

CustomSummaryLavaTemplate

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = -1

Description

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = -1

ForeignGuid

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

ForeignId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ForeignKey

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 200

Guid

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

HighlightColor

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 100

Id

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ImageBinaryFileId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

IsActive

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

IsPublic

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

MaxAccomplishmentsAllowed

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ModifiedByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ModifiedDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

Name

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 500

ResultsLavaTemplate

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = -1

SourceEntityTypeId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

TargetCount

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

StreakType

• Required Property: false
• Lava Supported Property: true
• Database Property: false
• Data Type: Streak Type
• Description: The source streak type from which achievements are earned.

StreakType

• Required Property: false
• Lava Supported Property: true
• Database Property: false
• Data Type: Streak Type
• Description: The source streak type from which achievements are earned.