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 |
|
|
|
| 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 |
|
|
|
| sah_membership_plan_id | int8 |
|
|
Foreign key to membership_plans. @example 1 |
| hcp_membership_plan_id | int8 |
|
|
Foreign key to membership_plans. @example 1 |
| services_australia_identifier_id | int8 |
|
|
The ID of the Services Australia Identifier associated with the membership. @example ‘1’ |
| archive_reason_id | int8 |
|
|
The archive reason id. @example 1. |
| 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 |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_memberships_pkey | Primary key | Asc | id |
| edge_memberships_agreement_id_idx | Performance | Asc | agreement_id |
| edge_memberships_archive_reason_id_idx | Performance | Asc | archive_reason_id |
| edge_memberships_community_id_idx | Performance | Asc | community_id |
| edge_memberships_company_id_idx | Performance | Asc | company_id |
| edge_memberships_hcp_membership_plan_id_idx | Performance | Asc | hcp_membership_plan_id |
| edge_memberships_membership_plan_id_idx | Performance | Asc | membership_plan_id |
| edge_memberships_primary_contact_id_idx | Performance | Asc | primary_contact_id |
| edge_memberships_sah_membership_plan_id_idx | Performance | Asc | sah_membership_plan_id |
| edge_memberships_services_australia_identifier_id_idx | Performance | Asc | services_australia_identifier_id |
| edge_memberships_tax_id_idx | Performance | Asc | tax_id |