Challenges dimension table (S3)
Table name: bi_dimchallenges_s3
This table contains data related to challenges, designed to enable efficient management, reporting, and analytical processes.
Field | Field Type | Primary Key |
|---|---|---|
ChallengePK | BIGINT | PK |
ChallengeID | VARCHAR (36) | |
ChallengeName | VARCHAR (2000) | |
ChallengeDescription | VARCHAR (65535) | |
ChallengeMetrics | BIGINT |
|
ChallengeTypeCount | INTEGER | |
ChallengeStartDate | TIMESTAMP | |
ChallengeEndDate | TIMESTAMP | |
RuleId | VARCHAR (36) | |
CreatedOn | TIMESTAMP | |
CreatedBy | VARCHAR (36) | |
OrganizationId | VARCHAR (36) | |
Void | BOOLEAN | |
ChallengeMetricsName | VARCHAR (2000) | |
ParentChallengeMetricsName | VARCHAR (2000) | |
etllastupdatedon | TIMESTAMP | |
etllastupdatedon | VARCHAR (50) | |
PodName | VARCHAR (20) | |
groupid | BIGINT |