Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int4 |
|
|
|
| beginning_at | timestamp |
|
|
|
| ending_at | timestamp |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| member_id | int4 |
|
|
|
| helper_id | int4 |
|
|
|
| schedule_rule_id | int4 |
|
|
|
| schedule_rule_version | varchar |
|
|
|
| checked_in_at | timestamp |
|
|
|
| checked_out_at | timestamp |
|
|
|
| rating | int4 |
|
|
|
| state | varchar |
|
|
|
| canceled_at | timestamp |
|
|
|
| product_id | int4 |
|
|
|
| canceled_reason | varchar |
|
|
|
| company_id | int8 |
|
|
|
| provider_travel_time | interval |
|
|
|
| provider_travel_distance | int4 |
|
|
|
| client_transport_rate_id | int8 |
|
|
|
| provider_travel_projected_time | interval |
|
|
|
| provider_travel_projected_distance | int4 |
|
|
|
| client_transport_distance | int4 |
|
|
|
| provider_travel_distance_rate_id | int8 |
|
|
|
| provider_travel_time_rate_id | int8 |
|
|
|
| provider_travel_time_rate_matches_time_rate | bool |
|
|
|
| provider_travel_calculated_time | interval |
|
|
|
| provider_travel_calculated_distance | int4 |
|
|
|
| provider_travel_rostered_time | interval |
|
|
|
| shift_id | int8 |
|
|
|
| source_type | varchar |
|
|
|
| source_id | int8 |
|
|
|
| timestamp |
|
|
||
| utilisation_beginning_at | timestamp |
|
|
A UTC timestamp indicating when the utilisation period of the visit begins. |
| cancelation_reason_id | int8 |
|
|
Foreign key to visit_cancelation_reasons. @example 1 |
| previous_hcp_product_id | int8 |
|
|
A reference to the HCP visit rate prior to the migration to new Support at Home rate @example 1 |
| product_locked | bool |
|
|
If true prevents the visit product from being recalculated. @example: true |
| product_locked_reason | text |
|
|
Reason given for locking product. @example: Discount override |
| beginning_at_in_company_tz | timestamp |
|
|
|
| ending_at_in_company_tz | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| checked_in_at_in_company_tz | timestamp |
|
|
|
| checked_out_at_in_company_tz | timestamp |
|
|
|
| canceled_at_in_company_tz | timestamp |
|
|
|
| timestamp |
|
|
||
| utilisation_beginning_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| 135186e79a90a98dac60b69719c1dfcf | Performance | Asc | previous_hcp_product_id |
| 1c4787fb19cb15f111604ab2f24fb6be | Performance | Asc | company_id |
| 25a7ec94ab14d3e067100242d636e84a | Performance | Asc | cancelation_reason_id |
| 3e2f6a4f3869094e6fe7a02c74419770 | Performance | Asc | shift_id |
| 44358270d0e05e01b309b52782675a6e | Performance | Asc | schedule_rule_id |
| 4aa2b320f6ce451db101ab65a80136ae | Performance | Asc | provider_travel_distance_rate_id |
| 4dc8116c907968543fff737d02c5344b | Performance | Asc | client_transport_rate_id |
| 9e7bb18dd5a2167ad18515cdf8b2988f | Performance | Asc | helper_id |
| bdecbfb7ab27bd76301c5a6e3f80020b | Performance | Asc | product_id |
| d4bd8ae892d58807604e24fc7345f2d8 | Performance | Asc | provider_travel_time_rate_id |
| f7af1bf6f4f9b34cf3172d27e7e9c35f | Performance | Asc | member_id |
| f90f9c67eaab9eede9b82b276d214f45 | Performance | Asc | source_id |