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. |
| full_name | varchar |
|
|
|
| nickname | varchar |
|
|
|
| varchar |
|
|
||
| telephone1 | varchar |
|
|
|
| telephone2 | varchar |
|
|
|
| address1 | varchar |
|
|
|
| address2 | varchar |
|
|
|
| locality | varchar |
|
|
|
| region | varchar |
|
|
|
| postcode | varchar |
|
|
|
| year_of_birth | int4 |
|
|
|
| deceased_on | date |
|
|
The date the member died, e.g.: 2021-03-02. |
| lonlat | geography |
|
|
The longitude and latitude of the member, e.g.: 0000000010E51000001C1AE2B380111110111F111B11111AA0. |
| 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 |