Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| name | varchar |
|
|
|
| care_management_price_cents | int4 |
|
|
|
| care_management_price_currency | varchar |
|
|
|
| payment_frequency | varchar |
|
|
|
| tax_id | int8 |
|
|
|
| company_id | int8 |
|
|
|
| archived_at | timestamp |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| allow_membership_to_self_manage | bool |
|
|
|
| package_management_price_cents | int4 |
|
|
|
| package_management_price_currency | varchar |
|
|
|
| provider_travel_maximum_claimable_minutes | int4 |
|
|
|
| provider_travel_maximum_claimable_kilometers | int4 |
|
|
|
| client_transport_chargeable | bool |
|
|
|
| provider_travel_distance_chargeable | bool |
|
|
|
| provider_travel_time_chargeable | bool |
|
|
|
| client_transport_maximum_claimable_kilometers | int4 |
|
|
|
| funding_scheme_type | varchar |
|
|
The funding scheme type the product is associated with. One of: sah, chsp, dva, hcp, ndis @example sah |
| archived_at_in_company_tz | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_membership_plans__dbt_tmp_pkey | Primary key | Asc | id |