Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int4 |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| community_id | int4 |
|
|
|
| uuid | varchar |
|
|
|
| archived_at | timestamp |
|
|
|
| plan_payment_frequency | varchar |
|
|
|
| billing_reference | varchar |
|
|
|
| commenced_at | timestamp |
|
|
|
| next_review_at | timestamp |
|
|
|
| agreement_id | int8 |
|
|
|
| archive_reason | varchar |
|
|
|
| plan_care_management_price_cents | int4 |
|
|
|
| plan_care_management_price_currency | varchar |
|
|
|
| primary_contact_id | int8 |
|
|
|
| signed_up_at | timestamp |
|
|
|
| commenced_on | date |
|
|
|
| company_id | int8 |
|
|
|
| tax_id | int8 |
|
|
|
| membership_plan_id | int8 |
|
|
|
| signed_up_on | date |
|
|
|
| plan_package_management_price_cents | int4 |
|
|
|
| plan_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 |
|
|
|
| plan_package_management_price_warning_disabled | bool |
|
|
|
| client_transport_maximum_claimable_kilometers | int4 |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| archived_at_in_company_tz | timestamp |
|
|
|
| commenced_at_in_company_tz | timestamp |
|
|
|
| next_review_at_in_company_tz | timestamp |
|
|
|
| signed_up_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|