Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| xero_item_code | varchar |
|
|
|
| xero_item_code_tax | varchar |
|
|
|
| name | varchar |
|
|
|
| description | varchar |
|
|
|
| suggested_price_cents | int4 |
|
|
|
| suggested_tenant_percent | numeric |
|
|
|
| quantity_type | varchar |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| uuid | uuid |
|
|
|
| archived_at | timestamp |
|
|
|
| company_id | int8 |
|
|
|
| default | bool |
|
|
|
| registered_tax_id | int8 |
|
|
|
| unregistered_tax_id | int8 |
|
|
|
| price_limit_min_cents | int4 |
|
|
|
| price_limit_min_currency | varchar |
|
|
|
| price_limit_max_cents | int4 |
|
|
|
| price_limit_max_currency | varchar |
|
|
|
| helper_types | _varchar |
|
|
|
| applicable_days | _varchar |
|
|
|
| external_id | varchar |
|
|
|
| applicable_start_time | text |
|
|
|
| applicable_end_time | text |
|
|
|
| visit_duration | int4 |
|
|
The duration of visit that this product is most applicable to, in seconds. @example 3600. @deprecated use visit_duration_range_begin, visit_duration_range_end and visit_duration_range_inclusive instead |
| propagating_updates | bool |
|
|
|
| applicable_start_time_just_time | time |
|
|
|
| applicable_end_time_just_time | time |
|
|
|
| xero_travel_item_code | varchar |
|
|
|
| xero_travel_item_code_tax | varchar |
|
|
|
| provider_travel_external_id | varchar |
|
|
|
| public_holiday | bool |
|
|
Whether or not this product applies on public holidays @example: true |
| visit_duration_range | int4range |
|
|
A range of visit durations in seconds for which this product is applicable. @example: [3600,7200) @deprecated use visit_duration_range_begin, visit_duration_range_end and visit_duration_range_inclusive instead |
| parent_id | int8 |
|
|
For variants, the ID of the base product this variant was created from. @example 1234 |
| funding_scheme_type | varchar |
|
|
The funding scheme type the product is associated with. One of: sah, chsp, dva, hcp, ndis @example sah |
| variant_family_id | int8 |
|
|
Cache column to make variant family lookups faster. Holds the ID for parent products, the parent_id for variants, and null if the product is not a parent or variant. @example 1234 |
| visit_duration_range_begin | int4 |
|
|
The beginning of the range of visit durations in seconds for which this product is applicable. @example: 3600 |
| visit_duration_range_end | int4 |
|
|
The end of the range of visit durations in seconds for which this product is applicable. @example: 7200 |
| visit_duration_range_inclusive | bool |
|
|
Whether the range of visit durations has an inclusive or exclusive upper bound @example: true |
| service_id | int8 |
|
|
The service this product is associated with. @example 1 |
| suggested_independent_contractor_price_cents | int4 |
|
|
The suggested independent contractor price, in cents. @example: 6250 |
| suggested_independent_contractor_price_currency | varchar |
|
|
The currency of the suggested independent contractor price. @example: ‘AUD’ |
| collect_helper_client_transport | bool |
|
|
Determines if a helper is able to enter provider travel when a visit uses a product that has this setting. Currently only applies to Support at Home. @example true |
| registered_independent_contractor_tax_id | int8 |
|
|
The tax to be used for independent contractors when the helper is registered for tax. @example 1 |
| unregistered_independent_contractor_tax_id | int8 |
|
|
The tax to be used for independent contractors when the helper is not registered for tax. @example 2 |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| archived_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_products_pkey | Primary key | Asc | id |
| edge_products_company_id_idx | Performance | Asc | company_id |
| edge_products_external_id_idx | Performance | Asc | external_id |