Trainero Workouts – API Workflow

1. Full API map (33 operations)

Every operation maps to docs/schema.sql. Base path: /v1. Headers: x-tenant-id, x-user-id.

Area	Method	Path
Workouts	GET	/workouts
Workouts	POST	/workouts
Workouts	GET	/workouts/{workout_id}
Workouts	POST	/workouts/{workout_id}/archive
Workout drafts	GET	/workouts/{workout_id}/draft
Workout drafts	PATCH	/workouts/{workout_id}/draft
Workout drafts	POST	/workouts/{workout_id}/publish
Executions	POST	/executions
Executions	GET	/executions
Executions	GET	/executions/{execution_id}
Executions	POST	/executions/{execution_id}/choices
Executions	POST	/executions/{execution_id}/results
Executions	POST	/executions/{execution_id}/complete
Exercises	GET	/exercises
Exercises	POST	/exercises
Exercises	GET	/exercises/{exercise_id}
Exercises	PUT	/exercises/{exercise_id}
Exercises	POST	/exercises/{exercise_id}/archive
Exercises	PUT	/exercises/{exercise_id}/star
Exercises	DELETE	/exercises/{exercise_id}/star
Exercises	POST	/exercises/{exercise_id}/share
Exercises	DELETE	/exercises/{exercise_id}/share
Exercises	POST	/exercises/{exercise_id}/duplicate
Exercise types	GET	/exercise-types
Exercise types	POST	/exercise-types
Exercise equipment	GET	/exercise-equipment
Exercise equipment	POST	/exercise-equipment
SetRep templates	GET	/setrep-templates
SetRep templates	POST	/setrep-templates
SetRep templates	GET	/setrep-templates/{template_id}
SetRep templates	PUT	/setrep-templates/{template_id}
SetRep templates	POST	/setrep-templates/{template_id}/share
SetRep templates	POST	/setrep-templates/{template_id}/duplicate

2. Workout + Publish flow

Trainer creates a workout, edits the draft (holders, alternatives, setrep rows), then publishes. Default version is used when a customer starts an execution.

flowchart LR A[POST /workouts] --> B[GET /workouts/id/draft] B --> C[PATCH /workouts/id/draft] C --> D[POST /workouts/id/publish] D --> E[GET /workouts/id] E --> F[POST /workouts/id/archive]

3. Execution flow

Customer starts an execution (uses workout default version), chooses alternatives per holder, logs setrep results, then completes or abandons.

flowchart LR A[POST /executions] --> B[GET /executions/id] B --> C[POST /executions/id/choices] C --> D[POST /executions/id/results] D --> E[POST /executions/id/complete]

4. Schema ↔ API (high level)

Which schema areas each API group touches.

flowchart TB subgraph workouts [Workouts] w[workout, workout_version, workout_version_i18n] p[workout_pattern, workout_pattern_i18n, workout_pattern_membership] h[workout_exercise_holder, workout_exercise_alternative, workout_setrep_row] end subgraph executions [Executions] ex[workout_execution, execution_choice, setrep_result_row] end subgraph exercises [Exercises] e[exercise, exercise_version, exercise_version_i18n, media, equipment, muscle] es[exercise_share, exercise_star] end subgraph ref [Reference] et[exercise_type, equipment, muscle] end subgraph templates [SetRep templates] st[setrep_template, setrep_template_i18n, setrep_template_row, setrep_template_share] end workouts --> executions ref --> exercises exercises --> workouts templates --> workouts