Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| helper_community_id | text |
|
|
The unique identifier of the helper and community combo. E.g. “ea54c06c1e1c06ba9f1aa39d98dc5bc1”. |
|||
| helper_id | int4 |
|
|
The unique helper ID. E.g. 57. |
|||
| community_id | int4 |
|
|
The unique community ID of the Helper. E.g. 123. |
|||
| community_name | text |
|
|
The name of the community the helper is a part of. E.g. “Adelaide West”. |
|||
| company_id | int8 |
|
|
The company ID. E.g. 345 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_helper_communities_pkey | Primary key | Asc | helper_community_id |
| fct_helper_communities_community_id_idx | Performance | Asc | community_id |
| fct_helper_communities_company_id_idx | Performance | Asc | company_id |
| fct_helper_communities_helper_id_idx | Performance | Asc | helper_id |