This section provides detailed descriptions for all data points related to mandatory training and certifications in Thrive. Each article includes the table name, the columns within each table, the data type for each column, and a user-friendly description of what each column represents.
Table Relationships
To help you visualise how the tables connect, the following Entity-Relationship Diagram (ERD) serves as a visual map of the tables and their primary and foreign keys.
erDiagram
FCT_COMPLIANCE_SERVICE_ASSIGNMENTS }o--|| DIM_AUDIENCE_SERVICE_AUDIENCES : "assigned to"
FCT_COMPLIANCE_SERVICE_ASSIGNMENTS ||--o{ FCT_COMPLIANCE_SERVICE_ENROLMENTS : "includes"
DIM_USER_SERVICE_USERS ||--o{ BRG_AUDIENCE_PEOPLE_MANAGER_PERMISSIONS : "manages"
DIM_USER_SERVICE_USERS ||--o{ BRG_USER_AUDIENCE : "member of"
DIM_USER_SERVICE_USERS ||--o{ DIM_USER_SERVICE_USERS_ADDITIONAL_FIELDS : "extends"
FCT_COMPLIANCE_SERVICE_ENROLMENTS }o--|| DIM_CONTENT_SERVICE_CONTENTS : "assigns"
FCT_COMPLIANCE_SERVICE_ENROLMENTS }o--|| DIM_USER_SERVICE_USERS : "enrolled user"
DIM_AUDIENCE_SERVICE_AUDIENCES ||--o{ BRG_USER_AUDIENCE : "has users"
DIM_AUDIENCE_SERVICE_AUDIENCES ||--o{ BRG_AUDIENCE_PEOPLE_MANAGER_PERMISSIONS : "manages"
DIM_CONTENT_SERVICE_CONTENTS ||--o{ BRG_CONTENT_TAGS : "tagged with"
FCT_COMPLIANCE_SERVICE_ASSIGNMENTS {
text Assignment_ID PK
text Primary_Content_ID PK,FK
text Tenant_ID PK,FK
}
DIM_USER_SERVICE_USERS {
text User_ID PK, FK
text Tenant_ID PK
}
DIM_USER_SERVICE_USERS_ADDITIONAL_FIELDS {
text User_ID PK,FK
text Additional_Field_Key PK
text Tenant_ID PK,FK
}
DIM_AUDIENCE_SERVICE_AUDIENCES {
text Audience_ID PK
text Tenant_ID PK,FK
}
FCT_COMPLIANCE_SERVICE_ENROLMENTS {
text Enrolments_ID PK
text Assignment_ID PK,FK
text User_ID PK,FK
text Primary_Content_ID PK,FK
text Tenant_ID PK,FK
}
DIM_CONTENT_SERVICE_CONTENTS {
text Content_ID PK
text Tenant_ID PK
}
BRG_USER_AUDIENCE {
text User_ID PK,FK
text Audience_ID PK,FK
text Tenant_ID PK,FK
}
BRG_CONTENT_TAGS {
text Content_Tag PK
text Content_ID PK,FK
text Tenant_ID PK,FK
}
BRG_AUDIENCE_PEOPLE_MANAGER_PERMISSIONS {
text Audience_ID PK,FK
text Manager_User_ID FK
text Tenant_ID PK,FK
}Note:
Underscores are included in the ERD for syntax compliance, but the corresponding field names in Snowflake do not include the underscore.