Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| profile_id | int4 |
|
|
The ID of the profile, e.g. 85. |
|||
| profile_uuid | varchar |
|
|
The UUID of the profile, e.g. a2311fd4-02a8-4452-99g2-fg391c5173a0. |
|||
| timezone | text |
|
|
A string representation of the timezone of the profile, e.g. Australia/Hobart. |
|||
| is_staffer | bool |
|
|
Whether the profile is a staff member. One of True, False. |
|||
| staffer_id | int4 |
|
|
The ID of the associated staff member, if applicable. E.g. 829. |
|||
| current_primary_role | text |
|
|
The current primary role of the profile. One of |
|||
| is_user_invited | bool |
|
|
A user has been created in the app (and invited to activate). One of True, False. |
|||
| user_invited_at | timestamp |
|
|
The datetime (in UTC) when the user was invited to activate, e.g. 2022-11-18 14:00:00. |
|||
| user_id | int4 |
|
|
The associated user ID in the app, empty of there`s no user, e.g. 25820. |
|||
| is_user_activated | bool |
|
|
Whether the user associated with the profile has activated their account. One of True, False. |
|||
| user_activated_at | timestamp |
|
|
The datetime (in UTC) the user signed in and created a password, e.g. 2023-07-28 04:02:56.095589. |
|||
| created_at | timestamp |
|
|
The date and time the profile was created (in UTC), e.g.: 2021-03-02 00:12:59.996101. |
|||
| updated_at | timestamp |
|
|
The date and time the profile was last updated (in UTC), e.g.: 2021-03-02 00:12:59.996101. |
|||
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dim_profiles_pkey | Primary key | Asc | profile_id |
| dim_profiles_company_id_idx | Performance | Asc | company_id |
| dim_profiles_profile_uuid_idx | Performance | Asc | profile_uuid |