dim_membership_plans


Description

Information about membership plans including pricing, payment frequency, and management settings.

Columns

Column Type Children Parents Comments
membership_plan_id int8
dim_memberships.membership_plan_id Implied Constraint R
dim_memberships.sah_membership_plan_id Implied Constraint R

The unique membership plan ID. E.g. 214.
plan_type varchar

The type of membership plan. E.g. HCP Level 1.
funding_scheme_type varchar
allow_membership_to_self_manage bool

Whether the membership is allowed to self-manage. One of True, False.
care_management_price_cents int4

The care management price in cents. E.g. 1500.
care_management_price_currency varchar

The currency for the care management price. E.g. AUD.
payment_frequency varchar

The frequency of payments for the plan. E.g. Weekly.
tax_id int8
dim_taxes.tax_id Implied Constraint R

The tax ID associated with the plan. E.g. 52.
archived_at timestamp

The date and time the helper was archived (in UTC). E.g.: 2021-03-17 22:59:01.116801.
created_at timestamp

The date and time the plan was created (in UTC). E.g.: 2021-03-17 22:59:01.116801.
updated_at timestamp

The date and time the plan was last updated (in UTC). E.g.: 2021-03-17 22:59:01.116801.
company_id int8
dim_companies.company_id Implied Constraint R

The company ID associated with the plan. E.g. 62.

Indexes

Constraint Name Type Sort Column(s)
dim_membership_plans_pkey Primary key Asc membership_plan_id
dim_membership_plans_company_id_idx Performance Asc company_id

Relationships

Close relationships within degrees of separation