Clients, products and subscriptions

In the UI a Client is a trainee, a Product is a plan the studio sells, and a ClientSubscription is one purchase of a plan by a trainee. None of this touches a payment provider. It is the coach’s bookkeeping, and it also drives app access.

`Client`

Table clients. The largest model in the schema. Fields are grouped below.

Identity and contact

Field	Type	Meaning
`studioId`	`String`	Tenant. Cascade delete.
`coachId`	`String?`	Legacy single responsible coach. The full list is in `ClientCoach`.
`externalUserId`	`String?`	External identity, unique per studio. Either the auth `User.id` of the trainee, or an import key for a trainee brought in from AutoFit. The trainee account deletion keeps an AutoFit key on the erased row so a later re-sync recognises the deletion and skips the trainee.
`name`	`String`	Full name.
`firstName`, `lastName`	`String?`
`email`	`String?`
`phone`	`String?`	Stored in canonical form. Every write goes through the phone normalizer.
`israeliId`	`String?`	National id number.
`avatarUrl`	`String?`
`tags`	`String[]`	Free-form labels.
`goal`	`String?`	Free-text goal.

Body and targets

Field	Type	Meaning
`birthDate`	`DateTime?` (`@db.Date`)
`age`	`Int?`
`gender`	`Gender?`	`MALE`, `FEMALE`, `OTHER`.
`heightCm`, `weightKg`	`Float?`	Current profile values. Weight history lives in `WeightEntry` and `DailyMetric`.
`goalWeightKg`	`Float?`
`tdee`	`Float?`	Total daily energy expenditure.
`bmrMethod`	`String?`	Which formula produced the BMR.
`activityFactor`	`Float?`	Multiplier applied to BMR.
`waterGoalMl`	`Int?`	Daily water goal.
`stepsGoal`	`Int?`	Daily steps goal.

Plan mirror

These columns mirror the trainee’s current subscription. ClientSubscription is the source of truth. The service in apps/core-api/src/modules/client-subscriptions/client-subscriptions.service.ts recomputes the mirror whenever subscription rows change.

Field	Type	Meaning
`status`	`ClientStatus`	Default `ACTIVE`.
`productId`	`String?`	The plan in force. `onDelete: SetNull`.
`planName`	`String?`	Plan name snapshot.
`priceAgorot`	`Int?`	Price snapshot, VAT included, in agorot.
`startedOn`, `endsOn`	`DateTime?`	Coverage dates. Stored as UTC midnight of the studio’s civil day.
`planFrozenOn`	`DateTime?`	When the plan was frozen.
`planRemainingDays`	`Int?`	Days left at the moment of the freeze, restored on reactivation.
`appAccessWhileFrozen`	`Boolean`	Default `false`. A frozen trainee is locked out of the app unless this is on.

endsOn being null means “this studio does not track subscriptions for this trainee”, and the app stays open. That is why a client whose only subscription was cancelled before it started still gets a dated endsOn: leaving it null would hand app access back.

Check-in schedule

Field	Type	Meaning
`onboardingFormId`	`String?`	Per-trainee onboarding form override. `SetNull` on form delete.
`updateFormId`	`String?`	Per-trainee check-in form override.
`updateCadence`	`FormCadence?`	`WEEKLY`, `BIWEEKLY`, `MONTHLY`.
`updateWeekday`	`Int?`	Day of week the check-in is sent.
`updateDayOfMonth`	`Int?`	Day of month, for the monthly cadence.
`updateAnchorOn`	`DateTime?`	The date the biweekly cycle counts from. Defaults to the plan start, but it is a separate column so moving a trainee to the opposite fortnight does not rewrite when their subscription began.
`updateNextOn`	`DateTime?` (`@db.Date`)	Next scheduled send date.
`updateSkipOn`	`DateTime?` (`@db.Date`)	A single date to skip.
`lastUpdateFormSentAt`	`DateTime?`	Last time the dispatcher sent the check-in form.
`lastCheckInReminderAt`	`DateTime?`	Last reminder.

When the per-trainee form columns are null, the form comes from the trainee’s Product (Product.onboardingFormId, Product.updateFormId).

App activity and preferences

Field	Type	Meaning
`lastCheckInAt`	`DateTime?`	Last time the trainee opened the app. Per-day history is in `ClientAppDay`.
`lastCheckInPlatform`	`String?`	Platform reported on that open.
`timezone`	`String?`	The trainee device’s IANA zone. Trainee “days” follow the device, not the studio zone.
`foodPreferences`	`Json?`	The trainee’s food exclusions. Stores ids and is resolved at read time.
`foodPreferencesUpdatedAt`	`DateTime?`
`mutedNotificationGroups`	`String[]`	Default `[]`. Notification groups the trainee muted in the app. A muted push is treated as handled, not as failed.

Bookkeeping

Field	Type	Meaning
`deletedAt`	`DateTime?`	Soft delete.
`createdAt`, `updatedAt`	`DateTime`

Indexes and constraints

Unique (studioId, externalUserId). Import identity is per studio, so the same AutoFit client can be imported into two studios.
B-tree: studioId, coachId, productId, onboardingFormId, updateFormId, (studioId, status), deletedAt, (studioId, createdAt), (studioId, deletedAt).
Trigram GIN: name, phone, email. These back the server-side trainee search.

`ClientStatus`

Value	Meaning
`ACTIVE`	Normal state.
`PAUSED`	Frozen.
`CHURN_RISK`	Flagged as at risk.
`CHURNED`	Left.
`ARCHIVED`	Archived. Also the status written when a trainee deletes their account.

`Gender`

MALE, FEMALE, OTHER. The gender form field is separate: its answers are lowercase male or female, and that field type is not in CLIENT_SAVE_TYPES, so a form answer does not write this column.

Trainee account deletion

deleteTraineeAccount in apps/core-api/src/modules/trainee/trainee.repository.ts is a soft delete with a scrub. In one transaction it deletes the trainee’s photos, technique videos, health samples, meal logs, nutrition day logs, favourite meals, shopping list, form responses, form assignments, inbox items, push tokens and WhatsApp messages, detaches calendar events, then sets deletedAt, status: 'ARCHIVED', an anonymized name, and nulls every personal field. Push tokens are deleted explicitly because a soft delete never fires the cascade.

`Product`

Table products. A plan the studio sells to trainees.

Field	Type	Meaning
`studioId`	`String`	Tenant. Cascade delete.
`name`	`String`	Internal name.
`displayName`	`String?`	Trainee-facing name. Resolved at read time, with `name` as fallback.
`tag`	`String?`	Short label.
`priceAgorot`	`Int?`	`null` means the plan does not fix a price and the coach sets it per trainee on assignment. `0` is a real price, a free plan.
`durationValue`	`Int?`	Length of the plan.
`durationUnit`	`DurationUnit`	`DAYS` or `MONTHS`. Default `MONTHS`.
`onboardingFormId`	`String?`	Form sent to a new trainee on this plan. `SetNull`.
`updateFormId`	`String?`	Recurring check-in form for this plan. `SetNull`.
`active`	`Boolean`	Default `true`.
`createdAt`, `updatedAt`	`DateTime`

Indexes: studioId, onboardingFormId, updateFormId. Relations: clients (the mirror column), subscriptions, and the two form relations named ProductOnboardingForm and ProductUpdateForm.

`ClientSubscription`

Table client_subscriptions. One row per plan a trainee holds, held or will hold. A trainee can have several, queued back to back.

Field	Type	Meaning
`studioId`	`String`	Tenant. Plain column, no relation.
`clientId`	`String`	Cascade delete.
`productId`	`String?`	`SetNull` when the product is deleted.
`planName`	`String?`	Name snapshot at assignment.
`priceAgorot`	`Int?`	Price snapshot.
`startedOn`	`DateTime?`	Null only while `AWAITING_START`.
`endsOn`	`DateTime?`	Null only while `AWAITING_START`.
`status`	`SubscriptionStatus`	Default `SCHEDULED`.
`startTrigger`	`SubscriptionStartTrigger?`	What event starts a waiting row. Kept after the start so history shows what started it.
`durationValue`, `durationUnit`	`Int?`, `DurationUnit?`	The duration used to compute `endsOn` when a waiting row starts. Taken from the request body, or the product at assignment.
`planFrozenOn`	`DateTime?`	Freeze date.
`planRemainingDays`	`Int?`	Days remaining at freeze.
`canceledOn`	`DateTime?`	A wall-clock instant, unlike the day-boundary dates.
`createdAt`, `updatedAt`	`DateTime`

Indexes: clientId, (studioId, status), (clientId, status), (clientId, startedOn), (studioId, status, startedOn).

`SubscriptionStatus`

Value	Meaning
`AWAITING_START`	No dates yet. The row waits for its `startTrigger`. It still counts as the trainee’s plan: it names the product and price, and its null dates keep the app open.
`SCHEDULED`	Has dates, starts in the future.
`ACTIVE`	Running.
`FROZEN`	Paused with `planFrozenOn` and `planRemainingDays` set.
`CANCELED`	Ended by a coach. `canceledOn` is set.
`EXPIRED`	Ran past `endsOn`.

LIVE_SUBSCRIPTION_STATUSES in client-subscriptions/coverage.ts is SCHEDULED, ACTIVE, FROZEN. Live rows are the ones that block overlapping dates.

`SubscriptionStartTrigger`

Chosen by the studio setting subscriptionStartMode.

Value	The subscription starts when
`INTAKE_FORM`	The trainee submits the intake form.
`FIRST_PLAN`	The first plan is assigned to the trainee.
`FIRST_WORKOUT`	The trainee logs their first workout.

Rules the service enforces

These come from client-subscriptions.service.ts and are worth knowing before writing rows by hand:

Dates are civil days stored as UTC midnight. Comparisons use the day key, never the millisecond.
No row may end before it starts. Equal dates are allowed, because endsOn === startedOn is the legacy shape for “no end date recorded”.
Live rows of one trainee may not overlap. Overlap is a strict comparison on whole days, so a new plan may start on the day the previous one ends. That is the back-to-back renewal.
When a plan is assigned without a start date, it starts when the trainee’s last live plan runs out, not today.
An hourly reconciler moves dated rows along: an ACTIVE row past its end becomes EXPIRED, and the first due SCHEDULED row becomes ACTIVE. Waiting rows are never touched by it.
A cancellation can only shorten coverage. It is capped at the row’s own endsOn, and a row cancelled before it started covers nothing.
Some imported rows have startedOn after endsOn. The overlap check squares the endpoints up so a broken row is flagged, never silently ignored.

`DurationUnit`

DAYS or MONTHS.

​Client

​Identity and contact

​Body and targets

​Plan mirror

​Check-in schedule

​App activity and preferences

​Bookkeeping

​Indexes and constraints

​ClientStatus

​Gender

​Trainee account deletion

​Product

​ClientSubscription

​SubscriptionStatus

​SubscriptionStartTrigger

​Rules the service enforces

​DurationUnit