What the copy you download from your coach account, or ask us for to switch to another provider, contains (section 8 of the
terms of service): each table, with its fields and the format of each one. It is generated from the same list the export uses, so it is up to date.
The package
A ZIP file with a README.txt explaining what it contains, an index data.json (which tables it includes and how many rows each one has, the list of files with their store, path and size, what did not fit with the reason and a temporary download link, and the providers that keep the data), a tables/ folder with one JSON file per table and a files/ folder with the photos, videos, audio and images in their original format, under files/<store>/<path>.
Each file in tables/ is a JSON list (UTF-8) with one object per row, one per line. The keys are the field names below, in Spanish, as they are in our database: they are not translated, so that the package can be loaded elsewhere. Dates are ISO 8601 text (2026-10-27 or 2026-10-27T10:00:00+00:00) and identifiers are UUIDs; a field that can be empty comes out as null.
Rows in assistant_suggestion, assistant_proposal, client_recipe, recipe_chat_message, assistant_turn, assistant_report, checkin_form, client_note, calendar_event, routine_exercise, exercise, client_macros, client_macro_log, message, client_goal, checkin, etiqueta_sugerencia, client_etiqueta also carry the field generado_por_ia (true or false): whether the artificial intelligence wrote them.
The package does not include the access log, each device's notification subscriptions, the video processing queues, the app's preferences or keys and passwords. We will give you the access log if you ask for it in writing at privacidad@ontrain.app.
The tables
trainer
| Field | Format |
|---|
activo | true or false |
avatar_url | text (can be empty) |
color_fondo | text (can be empty) |
color_marca | text (can be empty) |
colores_plan | JSON object (can be empty) |
created_at | text |
estilo_app | text |
fecha_baja | text (can be empty) |
genero | text (can be empty) |
ia_acciones | JSON object |
ia_autocompletar_apagado | list of text |
ia_autoetiquetado | true or false |
ia_autoetiquetado_aceptado_at | text (can be empty) |
ia_autoetiquetado_aceptado_por | text (can be empty) |
ia_autoetiquetado_frecuencia | text |
ia_autoetiquetado_texto_version | text (can be empty) |
ia_autoetiquetado_vista | text |
ia_historial | true or false |
ia_historial_dias | number |
ia_informe_lunes | true or false |
ia_sugerencias_auto | true or false |
id | text |
idioma | text (can be empty) |
logo_url | text (can be empty) |
marca | text (can be empty) |
nombre | text |
onboarding_completado | text (can be empty) |
parent_trainer_id | text (can be empty) |
permisos | JSON object |
push_mostrar_remitente | true or false |
recetas_activas | true or false |
recetas_prompt | text (can be empty) |
terminos_aceptados_at | text (can be empty) |
terminos_version | text (can be empty) |
cuenta_suspendida | true or false (can be empty) |
trainer_message
| Field | Format |
|---|
autor | text |
collaborator_id | text |
fecha | text |
id | text |
leido | true or false |
org_id | text |
texto | text |
trainer_notice
| Field | Format |
|---|
autor_id | text (can be empty) |
created_at | text |
cuerpo | text |
expira_at | text (can be empty) |
id | text |
org_id | text |
para_todos | true or false |
publicado_at | text |
requiere_confirmacion | true or false |
retirado_at | text (can be empty) |
titulo | text |
video_id | text (can be empty) |
trainer_notice_recipient
| Field | Format |
|---|
client_id | text |
confirmado_at | text (can be empty) |
notice_id | text |
visto_at | text (can be empty) |
trainer_payment
| Field | Format |
|---|
ciclo | text |
created_at | text |
credito_cents | number |
id | text |
importe_cents | number |
metodo | text |
periodo_fin | text |
periodo_inicio | text |
plan | text |
stripe_invoice_id | text (can be empty) |
trainer_id | text |
cobro_cuenta
| Field | Format |
|---|
cobros_activos | true or false |
contacto_email | text (can be empty) |
contacto_telefono | text (can be empty) |
created_at | text |
datos_completos | true or false |
desconectada | text (can be empty) |
direccion_calle | text |
direccion_cp | text |
direccion_localidad | text |
direccion_pais | text |
direccion_piso | text (can be empty) |
direccion_provincia | text |
fecha_nacimiento | text (can be empty) |
modo | text |
nif | text |
nif_iva | text (can be empty) |
nombre_comercial | text (can be empty) |
nombre_legal | text (can be empty) |
pausar_por_impago | true or false |
razon_social | text (can be empty) |
registro_mercantil | text (can be empty) |
stripe_account_id | text |
trainer_id | text |
transferencias_activas | true or false |
updated_at | text |
vendedor_tipo | text (can be empty) |
cobro_tarifa
| Field | Format |
|---|
activa | true or false |
created_at | text |
id | text |
importe_cents | number |
meses | number |
nombre | text |
recurrente | true or false |
stripe_account_id | text |
stripe_price_id | text |
stripe_product_id | text |
trainer_id | text |
calendar_event
| Field | Format |
|---|
client_id | text (can be empty) |
created_at | text |
estado_gestion | text (can be empty) |
fecha | text |
hora | text (can be empty) |
hora_fin | text (can be empty) |
ia_generado_at | text (can be empty) |
id | text |
nota | text (can be empty) |
nota_gestion | text (can be empty) |
tipo | text |
titulo | text |
trainer_id | text |
vacation_day
| Field | Format |
|---|
created_at | text |
decided_at | text (can be empty) |
estado | text |
fecha | text |
id | text |
motivo_rechazo | text (can be empty) |
solicitud_id | text (can be empty) |
titulo | text (can be empty) |
trainer_id | text |
trainer_availability_window
| Field | Format |
|---|
created_at | text |
day_of_week | number |
end_time | text |
id | text |
start_time | text |
tipo | text |
trainer_id | text |
soporte_consulta
| Field | Format |
|---|
asunto | text |
created_at | text |
estado | text |
id | text |
mensaje | text (can be empty) |
respondida_at | text (can be empty) |
tipo | text |
trainer_id | text |
soporte_contacto
| Field | Format |
|---|
codigo | text |
cuenta | text |
telefono | text (can be empty) |
updated_at | text |
valoracion
| Field | Format |
|---|
created_at | text |
id | text |
nota | number (can be empty) |
trainer_id | text |
client_invitation
| Field | Format |
|---|
aceptada_en | text (can be empty) |
assigned_trainer_id | text (can be empty) |
client_id | text (can be empty) |
created_at | text |
email | text |
estado | text |
expira_en | text |
form_asignado_en | text (can be empty) |
form_copia_id | text (can be empty) |
form_id | text (can be empty) |
id | text |
idioma | text (can be empty) |
nombre | text |
trainer_id | text |
trainer_invitation
| Field | Format |
|---|
aceptada_en | text (can be empty) |
colaborador_id | text (can be empty) |
creada_por | text (can be empty) |
created_at | text |
email | text |
estado | text |
expira_en | text |
id | text |
nombre | text |
permisos | JSON object |
trainer_id | text |
assistant_instruction
| Field | Format |
|---|
activa | true or false |
ambito | text |
compartida | true or false |
contenido | text |
created_at | text |
id | text |
orden | number |
titulo | text |
trainer_id | text |
assistant_suggestion
| Field | Format |
|---|
client_id | text (can be empty) |
contenido | text |
created_at | text |
estado | text |
id | text |
razon | text (can be empty) |
scope | text |
signal_hash | text |
trainer_id | text |
assistant_proposal
| Field | Format |
|---|
accion | text |
client_id | text (can be empty) |
creada_at | text |
decidida_at | text (can be empty) |
decidida_por | text (can be empty) |
estado | text |
id | text |
org_id | text |
payload | JSON object |
resumen | text |
trainer_id | text |
whatsapp_clientes | list of text |
whatsapp_conexion | text (can be empty) |
assistant_action_log
| Field | Format |
|---|
accion | text |
client_id | text (can be empty) |
created_at | text |
id | text |
payload | JSON object |
trainer_id | text |
ia_lectura_cliente
| Field | Format |
|---|
client_id | text |
creado_at | text |
herramientas | list of text |
id | number |
org_id | text |
proceso | text |
trainer_id | text (can be empty) |
assistant_conversation
| Field | Format |
|---|
created_at | text |
id | text |
org_id | text |
titulo | text |
trainer_id | text |
updated_at | text |
whatsapp_clientes | list of text |
whatsapp_conexion | text (can be empty) |
assistant_conversation_client
| Field | Format |
|---|
client_id | text |
conversation_id | text |
assistant_turn
| Field | Format |
|---|
conversation_id | text |
created_at | text |
id | text |
informe_id | text (can be empty) |
propuestas | list of text |
rol | text |
texto | text |
assistant_report
| Field | Format |
|---|
conversation_id | text (can be empty) |
created_at | text |
id | text |
informe | JSON object |
org_id | text |
tipo | text |
titulo | text |
trainer_id | text |
assistant_report_client
| Field | Format |
|---|
client_id | text |
report_id | text |
analisis_plantilla
| Field | Format |
|---|
campos | JSON object |
compartida | true or false |
created_at | text |
id | text |
org_id | text |
texto | text |
tipo | text |
trainer_id | text |
updated_at | text |
assistant_memory_documentos
The documents you uploaded to the assistant: the rows of assistant_memory that are documents, with these fields.
| Field | Format |
|---|
contenido | text |
created_at | text |
fecha | text |
id | text |
source_type | text |
trainer_id | text |
exercise
| Field | Format |
|---|
autor_id | text (can be empty) |
created_at | text |
en_biblioteca | true or false |
es_global | true or false |
grupo_muscular | text (can be empty) |
ia_generado_at | text (can be empty) |
id | text |
material | text (can be empty) |
miniatura_fin_url | text (can be empty) |
miniatura_url | text (can be empty) |
modalidad | text (can be empty) |
nombre | text |
nombre_en | text (can be empty) |
texto_instruccion | text (can be empty) |
texto_instruccion_en | text (can be empty) |
trainer_id | text (can be empty) |
video_bytes | number (can be empty) |
video_con_audio | true or false |
video_estado | text |
video_origen | text (can be empty) |
video_poster | text (can be empty) |
video_segundos | number (can be empty) |
video_url | text (can be empty) |
exercise_muscle
| Field | Format |
|---|
created_at | text |
exercise_id | text |
id | text |
musculo | text |
rol | text, one of: principal, secundario |
routine
| Field | Format |
|---|
activa | true or false |
ciclar | true or false |
client_id | text (can be empty) |
created_at | text |
created_by_trainer_id | text (can be empty) |
descripcion | text (can be empty) |
dias_sueltos | true or false |
es_plantilla | true or false |
fecha_fin | text (can be empty) |
fecha_inicio | text (can be empty) |
id | text |
nombre | text |
regla_progresion | text, one of: off, lineal, doble, tiempo |
repetir_cada_semanas | number (can be empty) |
semanas_totales | number (can be empty) |
source_routine_id | text (can be empty) |
trainer_id | text |
routine_week
| Field | Format |
|---|
archivado_at | text (can be empty) |
created_at | text |
id | text |
nombre | text (can be empty) |
numero_semana | number |
routine_id | text |
plan_override
| Field | Format |
|---|
created_at | text |
fecha_nueva | text |
fecha_original | text |
id | text |
routine_id | text |
session_id | text |
session
| Field | Format |
|---|
archivado_at | text (can be empty) |
color | text (can be empty) |
created_at | text |
dia_semana | text, one of: lunes, martes, miercoles, jueves, viernes, sabado, domingo (can be empty) |
fecha | text (can be empty) |
id | text |
nombre | text |
orden | number |
repeticion_id | text (can be empty) |
routine_id | text |
routine_week_id | text (can be empty) |
source_session_id | text (can be empty) |
tipo | text (can be empty) |
routine_exercise
| Field | Format |
|---|
al_fallo | true or false |
amrap | true or false |
archivado_at | text (can be empty) |
created_at | text |
descanso_segundos | number (can be empty) |
distancia_m | number (can be empty) |
duracion_segundos | number (can be empty) |
ejercicio_alternativo_id | text (can be empty) |
estructura | text, one of: normal, superserie, drop_set |
exercise_id | text |
ia_generado_at | text (can be empty) |
id | text |
incremento_kg | number (can be empty) |
modalidad | text, one of: fuerza, isometrico, cardio |
notas_entrenador | text (can be empty) |
orden | number |
pasos | number (can be empty) |
peso_objetivo | number (can be empty) |
regla_progresion | text, one of: off, lineal, doble, tiempo (can be empty) |
reps_objetivo | text (can be empty) |
rir_objetivo | number (can be empty) |
series | number (can be empty) |
session_id | text |
source_routine_exercise_id | text (can be empty) |
superset_con_id | text (can be empty) |
routine_set
| Field | Format |
|---|
created_at | text |
descanso_segundos | number (can be empty) |
id | text |
numero_serie | number |
peso_objetivo | number (can be empty) |
reps_objetivo | text (can be empty) |
rir_objetivo | number (can be empty) |
routine_exercise_id | text |
set_drop
| Field | Format |
|---|
created_at | text |
id | text |
orden_bajada | number |
peso_objetivo | number (can be empty) |
reps_objetivo | text (can be empty) |
routine_exercise_id | text |
checkin_form
| Field | Format |
|---|
activa | true or false |
client_id | text (can be empty) |
created_at | text |
descripcion | text (can be empty) |
es_plantilla | true or false |
fecha_inicio | text (can be empty) |
ia_generado_at | text (can be empty) |
ia_lectura | true or false |
ia_lectura_en | text (can be empty) |
ia_lectura_por | text (can be empty) |
ia_lectura_texto_version | text (can be empty) |
id | text |
nombre | text |
periodicidad | text |
pide_salud | true or false |
proposito | text |
recordatorio_dias | number (can be empty) |
salud_aceptada_en | text (can be empty) |
salud_aceptada_por | text (can be empty) |
salud_aceptadas | list of text |
salud_aviso_version | text (can be empty) |
salud_cambios | number |
salud_huella | text (can be empty) |
salud_intento_en | text (can be empty) |
salud_metodo | text (can be empty) |
salud_pedida_en | text (can be empty) |
salud_preguntas | JSON object |
salud_previa | true or false |
salud_revisada_en | text (can be empty) |
salud_revision | text |
source_form_id | text (can be empty) |
trainer_id | text |
video_id | text (can be empty) |
checkin_form_question
| Field | Format |
|---|
ayuda | text (can be empty) |
created_at | text |
etiqueta | text |
form_id | text |
id | text |
opciones | JSON object (can be empty) |
orden | number |
requerida | true or false |
tipo | text |
checkin_form_attachment
| Field | Format |
|---|
created_at | text |
form_id | text |
id | text |
mime | text (can be empty) |
nombre | text |
orden | number |
path | text |
tamano | number (can be empty) |
checkin_form_override
| Field | Format |
|---|
created_at | text |
fecha_nueva | text |
fecha_original | text |
form_id | text |
id | text |
video_adjunto
| Field | Format |
|---|
bytes | number (can be empty) |
con_audio | true or false |
created_at | text |
estado | text |
id | text |
origen | text |
poster | text (can be empty) |
segundos | number (can be empty) |
trainer_id | text |
url | text (can be empty) |
formacion
| Field | Format |
|---|
autor_id | text (can be empty) |
created_at | text |
cuerpo | text (can be empty) |
id | text |
titulo | text |
trainer_id | text |
updated_at | text |
video_id | text (can be empty) |
formacion_adjunto
| Field | Format |
|---|
created_at | text |
formacion_id | text |
id | text |
mime | text (can be empty) |
nombre | text |
orden | number |
path | text |
tamano | number (can be empty) |
curso
| Field | Format |
|---|
autor_id | text (can be empty) |
created_at | text |
descripcion | text (can be empty) |
en_orden | true or false |
id | text |
titulo | text |
trainer_id | text |
updated_at | text |
curso_paso
| Field | Format |
|---|
curso_id | text |
formacion_id | text |
orden | number |
trainer_id | text |
diet
| Field | Format |
|---|
activa | true or false |
autor_id | text (can be empty) |
carbohidratos_objetivo_g | number (can be empty) |
client_id | text (can be empty) |
created_at | text |
descripcion | text (can be empty) |
es_plantilla | true or false |
grasas_objetivo_g | number (can be empty) |
id | text |
kcal_objetivo | number (can be empty) |
nombre | text |
proteinas_objetivo_g | number (can be empty) |
source_diet_id | text (can be empty) |
supermercado | text (can be empty) |
trainer_id | text (can be empty) |
diet_item
| Field | Format |
|---|
cantidad | text (can be empty) |
categoria | text (can be empty) |
comprado | true or false |
created_at | text |
diet_id | text |
id | text |
nombre | text |
orden | number |
precio | number (can be empty) |
supermercado | text (can be empty) |
diet_meal
| Field | Format |
|---|
alimentos | JSON object |
carbohidratos_g | number (can be empty) |
comida | text |
descripcion | text (can be empty) |
dias | text |
diet_id | text |
grasas_g | number (can be empty) |
id | text |
kcal | number (can be empty) |
opcion | number |
orden_comida | number |
proteinas_g | number (can be empty) |
updated_at | text |
etiqueta
| Field | Format |
|---|
color | text |
created_at | text |
id | text |
nombre | text |
trainer_id | text |
updated_at | text |
etiqueta_regla
| Field | Format |
|---|
activa | true or false |
alcance | text |
clientes | list of text |
creada_por | text (can be empty) |
created_at | text |
etiqueta_id | text |
fuentes | list of text |
id | text |
poner | text |
quitar | text (can be empty) |
quitar_modo | text |
trainer_id | text |
updated_at | text |
client
| Field | Format |
|---|
apodo | text (can be empty) |
app_desde | text (can be empty) |
assigned_trainer_id | text (can be empty) |
avatar_url | text (can be empty) |
canal | text |
created_at | text |
edad_confirmada_at | text (can be empty) |
edad_confirmada_por | text (can be empty) |
email | text (can be empty) |
estado | text, one of: activo, baja, borrador |
fecha_alta | text |
fecha_baja | text (can be empty) |
fecha_nacimiento | text (can be empty) |
fuera_del_autoetiquetado | true or false |
genero | text (can be empty) |
id | text |
idioma | text (can be empty) |
nombre | text |
objetivo | text (can be empty) |
onboarding_completado | text (can be empty) |
pedir_peso_entreno | true or false |
privacidad_version | text (can be empty) |
purgar_desde | text (can be empty) |
telefono | text (can be empty) |
terminos_aceptados_at | text (can be empty) |
terminos_version | text (can be empty) |
tier | text, one of: coaching, self_service |
trainer_id | text |
client_intake
| Field | Format |
|---|
client_id | text |
consentimiento_fotos_en | text (can be empty) |
consentimiento_fotos_version | text (can be empty) |
consentimiento_ia_en | text (can be empty) |
consentimiento_ia_version | text (can be empty) |
consentimiento_ia_whatsapp_at | text (can be empty) |
consentimiento_publicidad_con_cara | true or false |
consentimiento_publicidad_en | text (can be empty) |
consentimiento_publicidad_version | text (can be empty) |
consentimiento_salud_en | text (can be empty) |
consentimiento_salud_version | text (can be empty) |
consentimientos_set | text (can be empty) |
created_at | text |
dias_disponibles | number (can be empty) |
experiencia | text (can be empty) |
id | text |
objetivo_principal | text (can be empty) |
updated_at | text |
client_etiqueta
| Field | Format |
|---|
client_id | text |
created_at | text |
etiqueta_id | text |
origen | text |
puesta_por | text (can be empty) |
regla_id | text (can be empty) |
etiqueta_sugerencia
| Field | Format |
|---|
accion | text |
client_id | text |
created_at | text |
estado | text |
etiqueta_id | text |
id | text |
motivo | text (can be empty) |
regla_id | text |
trainer_id | text |
updated_at | text |
consentimiento_solicitud
| Field | Format |
|---|
claves | list of text |
client_id | text |
creada_at | text |
id | text |
pedida_por | text (can be empty) |
respondida_at | text (can be empty) |
trainer_id | text |
client_note
| Field | Format |
|---|
client_id | text |
created_at | text |
cuerpo | text |
fecha | text |
ia_generado_at | text (can be empty) |
id | text |
proximo_paso | text (can be empty) |
titulo | text (can be empty) |
client_payment
| Field | Format |
|---|
client_id | text (can be empty) |
created_at | text |
fecha_fin | text |
fecha_pago | text |
id | text |
importe | number |
moneda | text |
nota | text (can be empty) |
origen | text |
stripe_account_id | text (can be empty) |
stripe_invoice_id | text (can be empty) |
stripe_livemode | true or false (can be empty) |
trainer_id | text |
cobro_suscripcion
| Field | Format |
|---|
cancela_al_final | true or false |
checkout_id | text (can be empty) |
client_id | text (can be empty) |
contratado_at | text (can be empty) |
contrato_confirmado_at | text (can be empty) |
created_at | text |
desistido_at | text (can be empty) |
desistimiento_acuse_at | text (can be empty) |
estado | text |
evento_ts | number |
id | text |
inicio_inmediato_at | text (can be empty) |
periodo_fin | text (can be empty) |
stripe_account_id | text |
stripe_customer_id | text (can be empty) |
stripe_estado | text (can be empty) |
stripe_subscription_id | text (can be empty) |
tarifa_id | text |
trainer_id | text |
updated_at | text |
client_macros
| Field | Format |
|---|
agua_ml | number (can be empty) |
carbohidratos_g | number (can be empty) |
client_id | text |
grasas_g | number (can be empty) |
ia_generado_at | text (can be empty) |
kcal | number (can be empty) |
proteinas_g | number (can be empty) |
updated_at | text |
client_macro_log
| Field | Format |
|---|
carbohidratos_g | number (can be empty) |
client_id | text |
created_at | text |
descripcion | text (can be empty) |
diet_meal_id | text (can be empty) |
fecha | text |
grasas_g | number (can be empty) |
ia_generado_at | text (can be empty) |
id | text |
kcal | number (can be empty) |
origen | text |
proteinas_g | number (can be empty) |
racion | number |
client_water_log
| Field | Format |
|---|
client_id | text |
fecha | text |
ml | number |
saldo_ml | number (can be empty) |
client_activity
| Field | Format |
|---|
client_id | text |
created_at | text |
distancia_m | number (can be empty) |
duracion_min | number (can be empty) |
fecha | text |
id | text |
nota | text (can be empty) |
tipo | text |
trainer_id | text |
client_metric_goal
| Field | Format |
|---|
clave | text |
client_id | text |
nota | text (can be empty) |
objetivo | number |
updated_at | text |
client_goal
| Field | Format |
|---|
avisada_at | text (can be empty) |
cerrada_at | text (can be empty) |
client_id | text |
created_at | text |
estado | text |
fase_actual | number |
hitos | JSON object |
ia_generado_at | text (can be empty) |
id | text |
inicio | text (can be empty) |
nota | text (can be empty) |
orden | number (can be empty) |
punto_partida | text (can be empty) |
titulo | text |
trainer_id | text |
updated_at | text |
formacion_asignacion
| Field | Format |
|---|
asignada_por | text (can be empty) |
client_id | text |
created_at | text |
curso_id | text (can be empty) |
fecha | text |
formacion_id | text (can be empty) |
id | text |
trainer_id | text |
formacion_progreso
| Field | Format |
|---|
client_id | text |
completado_at | text (can be empty) |
formacion_id | text |
visto_at | text (can be empty) |
client_recipe
| Field | Format |
|---|
client_id | text |
contenido | text |
created_at | text |
id | text |
titulo | text |
recipe_chat_message
| Field | Format |
|---|
carbohidratos_g | number (can be empty) |
client_id | text |
content | text |
created_at | text |
fecha | text |
grasas_g | number (can be empty) |
id | text |
kcal | number (can be empty) |
proteinas_g | number (can be empty) |
registrado | true or false |
role | text |
message
| Field | Format |
|---|
appointment_id | text (can be empty) |
archivo_url | text (can be empty) |
autor | text, one of: client, trainer |
client_id | text |
created_at | text |
escrito_at | text (can be empty) |
fecha | text |
ia_generado_at | text (can be empty) |
id | text |
leido | true or false |
llamada_id | text (can be empty) |
ref_clave | text (can be empty) |
ref_id | text (can be empty) |
ref_tipo | text (can be empty) |
retirado_at | text (can be empty) |
retirado_por | text (can be empty) |
sender_trainer_id | text (can be empty) |
texto | text (can be empty) |
tipo | text, one of: texto, audio, imagen, video, cita, llamada, referencia |
transcripcion | text (can be empty) |
transcripcion_estado | text, one of: pendiente, hecha, sin_voz, purgada |
whatsapp_mensaje
| Field | Format |
|---|
clave_envio | text (can be empty) |
client_id | text |
conexion_id | text (can be empty) |
created_at | text |
desde_business_app | true or false |
direccion | text |
entregado_at | text (can be empty) |
enviado_at | text (can be empty) |
enviado_por | text (can be empty) |
error_codigo | number (can be empty) |
estado | text (can be empty) |
fallido_at | text (can be empty) |
fecha | text |
ia_generado_at | text (can be empty) |
id | text |
incierto_at | text (can be empty) |
leido_at | text (can be empty) |
medio_bytes | number (can be empty) |
medio_caduca_at | text (can be empty) |
medio_mime | text (can be empty) |
plantilla_idioma | text (can be empty) |
plantilla_nombre | text (can be empty) |
plantilla_que | text (can be empty) |
tipo | text |
trainer_id | text |
visto_at | text (can be empty) |
wamid | text (can be empty) |
texto | text (can be empty) |
whatsapp_consentimiento
| Field | Format |
|---|
actor_id | text (can be empty) |
bsuid | text (can be empty) |
client_id | text |
conexion_id | text (can be empty) |
created_at | text |
estado | text |
fallo_at | text (can be empty) |
fallo_codigo | number (can be empty) |
fecha | text |
id | text |
motivo | text (can be empty) |
numero | text (can be empty) |
optin_version | text (can be empty) |
orden | number |
origen | text |
trainer_id | text |
version | text (can be empty) |
wamid | text (can be empty) |
whatsapp_declaracion_optin
| Field | Format |
|---|
client_id | text |
created_at | text |
declarado_por | text (can be empty) |
id | text |
trainer_id | text |
version | text |
appointment
| Field | Format |
|---|
checkin_id | text (can be empty) |
client_id | text |
created_at | text |
duracion_min | number |
estado_actualizado_at | text (can be empty) |
estado_gestion | text (can be empty) |
fecha | text |
fecha_aplazado | text (can be empty) |
id | text |
meet_url | text (can be empty) |
nota_gestion | text (can be empty) |
recordatorio_enviado_at | text (can be empty) |
tipo | text, one of: revision, urgencia |
llamada
| Field | Format |
|---|
client_id | text |
contestada_at | text (can be empty) |
created_at | text |
id | text |
iniciada_por | text (can be empty) |
latido_at | text |
latido_cliente_at | text (can be empty) |
salio_cliente_at | text (can be empty) |
terminada_at | text (can be empty) |
trainer_id | text |
exercise_record
| Field | Format |
|---|
client_id | text |
created_at | text |
exercise_id | text |
fecha | text |
id | text |
peso | number (can be empty) |
reps | number (can be empty) |
tipo | text, one of: carga, e1rm |
valor | number |
workout_session_id | text (can be empty) |
workout_session
| Field | Format |
|---|
cierre_automatico | true or false |
client_id | text |
created_at | text |
empezada_at | text |
fecha | text |
id | text |
nombre | text (can be empty) |
peso_corporal | number (can be empty) |
series_hechas | number (can be empty) |
session_id | text (can be empty) |
terminada_at | text (can be empty) |
visto_at | text |
volumen_kg | number (can be empty) |
checkin
| Field | Format |
|---|
client_id | text |
created_at | text |
estado | text, one of: completo, incompleto |
fecha | text |
ia_generado_at | text (can be empty) |
id | text |
notas_cliente | text (can be empty) |
notas_entrenador | text (can be empty) |
origen | text |
response_id | text (can be empty) |
checkin_measurement
| Field | Format |
|---|
checkin_id | text |
clave | text |
created_at | text |
etiqueta | text |
id | text |
unidad | text |
valor | number |
checkin_photo
| Field | Format |
|---|
checkin_id | text |
clave | text |
created_at | text |
etiqueta | text (can be empty) |
id | text |
url | text |
checkin_form_response
| Field | Format |
|---|
client_id | text |
created_at | text |
de_salud | true or false |
fecha_programada | text |
form_id | text |
id | text |
revisado | true or false |
salud_cambios | number (can be empty) |
salud_sin_clasificar | true or false |
salud_sin_consentimiento | true or false |
checkin_form_answer
| Field | Format |
|---|
created_at | text |
etiqueta | text |
id | text |
orden | number |
pregunta | JSON object (can be empty) |
question_id | text (can be empty) |
response_id | text |
tipo | text |
valor | JSON object (can be empty) |
valor_numero | number (can be empty) |
valor_texto | text (can be empty) |
exercise_log
| Field | Format |
|---|
atendido_en | text (can be empty) |
atendido_por | text (can be empty) |
client_id | text |
comentario | text (can be empty) |
comentario_en | text (can be empty) |
completado | true or false |
created_at | text |
fecha | text |
id | text |
modalidad | text, one of: fuerza, isometrico, cardio (can be empty) |
routine_exercise_id | text |
rpe | number (can be empty) |
urgente | true or false |
urgente_en | text (can be empty) |
workout_session_id | text (can be empty) |
set_log
| Field | Format |
|---|
al_fallo | true or false |
created_at | text |
distancia_m | number (can be empty) |
duracion_segundos | number (can be empty) |
exercise_log_id | text |
id | text |
numero_serie | number |
objetivo | JSON object (can be empty) |
pasos | number (can be empty) |
peso_real | number (can be empty) |
reps_real | number (can be empty) |
rir_real | number (can be empty) |