Milestones fact table (Redshift)
Table name: bi_factmilestones
This table contains data related to milestone achievements, supporting efficient tracking, analysis, and reporting of user progress and performance
Field | Field Type | Primary Key |
|---|---|---|
FactSegmentId | BIGINT | PK |
MilestoneUserID | VARCHAR(36) |
|
UserWID | BIGINT | |
CenterWID | BIGINT | |
MilestoneWID | BIGINT | |
AchievedDate | TIMESTAMP | |
CreatedOn | TIMESTAMP | |
CreatedByWID | VARCHAR(36) | |
Status | INT | |
MilestoneCount | BIGINT | |
PodName | VARCHAR(20) |
|
Void | BOOLEAN |
|
groupid | BIGINT | |
etlcreateddate | TIMESTAMP | |
etlcreatedby | VARCHAR(50) |