Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| helper_community_id | text |
|
|
The unique identifier (uuid) 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 |