Milestones fact table (S3)
Table name: bi_factmilestones_s3
This table contains data related to milestone achievements, supporting efficient tracking, analysis, and reporting of user progress and performance.
Field | Field Type | Description | Primary Key |
|---|---|---|---|
FactSegmentId | BIGINT | Primary key for this table. | PK |
MilestoneUserID | VARCHAR(36) |
| |
UserID | VARCHAR(36) | ||
MilestonesID | VARCHAR(36) | Unique identifier for the milestone. | |
AchievedDate | TIMESTAMP | Date on which the milestone was achieved. | |
CreatedOn | TIMESTAMP | Date on which the milestone was created. | |
CreatedBy | VARCHAR(36) | Name of the user who created the milestone. | |
Status | INT | Indicates the status of the milestone. | |
MilestoneCount | BIGINT | Total count of current milestone level. | |
PodName | VARCHAR(20) | Identifer for the region customer belongs to. Internal to Zenoti. | |
Void | BOOLEAN | Indicates if the record is obsolete. | |
groupid | BIGINT | Internal to Zenoti. Used for data processing. | |
etlcreateddate | TIMESTAMP | Date on which the row was created in the table. | |
etlcreatedby | VARCHAR(50) | ETL system admin user who inserted or updated the corresponding record in this table. |