Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| helper_service_id | text |
|
|
The ID associated to the helper service, e.g. 546. |
| helper_id | int4 |
|
|
The ID of the helper that the associated service is linked to, e.g. 1403. |
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
| service_id | int4 |
|
|
The ID of the service that the helper is linked to, e.g. 7. |
| service | text |
|
|
The name of the service, e.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_helper_services_pkey | Primary key | Asc | helper_service_id |
| fct_helper_services_company_id_idx | Performance | Asc | company_id |
| fct_helper_services_helper_id_idx | Performance | Asc | helper_id |
| fct_helper_services_service_id_idx | Performance | Asc | service_id |