dim_studio_starter_package_adjustment


Description

Studio-specific overrides for the one-time starter package fee charged at membership sign-up. Each row defines a custom fee for a specific gym and rate term configuration, overriding the default fee on the rate term (dim_rate_term_configuration.starter_package). Only gyms with an explicit override have a row here; the absence of a row means the rate term default applies.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
studio_starter_package_adjustment_id int8 19 null

The primary key of this table. System-generated identifier of the adjustment per studio.
rate_id int8 19 √ null
dim_rate.rate_id Implied Constraint R

The rate (tariff) for which this adjustment rule applies.
rate_term_configuration_id int8 19 √ null
dim_rate_term_configuration.rate_term_configuration_id Implied Constraint R

The rate term configuration for which this starter package amount applies.
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id Implied Constraint R

The organization unit (gym) where this starter package amount applies.
amount numeric 19,2 √ null

The studio-specific override for the one-time starter package fee. Overrides the default fee defined on the rate term configuration. A value of 0.0 means the studio has explicitly waived the fee.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation