{
  "care_lines": [],
  "conditions": [],
  "medications": [],
  "key_exams": [],
  "lab_results": [],
  "exam_requests": [],
  "consultations": [],
  "documents": [],
  "limits": {}
}

care_lines: id, care_line_id, name, description, color, icon, status, start_date, end_date, risk_level, notes, created_at, updated_at.

conditions: id, patient_id, care_line_id, name, status, started_at, ended_at, notes, created_at, updated_at, care_line_name, care_line_color.

medications: id, patient_id, name, dose, frequency, route, started_at, ended_at, status, last_reviewed_at, notes, created_at, updated_at.

key_exams: id, patient_id, exam_type_id, exam_type_name, exam_date, result_value, notes, created_at.

lab_results: id, patient_id, consultation_id, exam_date, canonical_name, raw_key, value_numeric, value_text, unit, recognized, created_at.

exam_requests: id, patient_id, requested_at, status, note.

consultations: id, patient_id, consultation_date, status, chief_complaint, subjective, objective, assessment, plan, notes, raw_text, copied_from_consultation_id, created_at, updated_at, finalized_at, vitals, lab_results, documents.

consultations[].vitals: id, consultation_id, blood_pressure_systolic, blood_pressure_diastolic, weight_kg, height_cm, bmi, capillary_glucose, heart_rate, waist_cm, notes, created_at, updated_at.

documents: id, patient_id, consultation_id, doc_type, title, body, created_at.

limits: key_exams, lab_results, consultations, documents.

Campos calculados no objeto do paciente:

last_consultation_date: data da consulta mais recente registrada em consultations.consultation_date, ou null. Não é agendamento.

consultation_count: total de consultas registradas do paciente.

last_hba1c_value: valor da HbA1c mais recente, ou null.

last_hba1c_date: data do exame referente à última HbA1c, ou null.

last_exam_date: data do exame mais recente do paciente, considerando exames-chave e laboratório.

Filtros aceitos: is_dm=1, last_consultation_before=2025-06-07, months_without_consultation=12, hba1c_min=7, hba1c_max=6, hba1c_before=2026-01-07, last_exam_before=2026-01-07.

Observação: filtros *_before incluem pacientes sem dado correspondente, para facilitar coortes de pendência.

Qualidade de dados futura: preencher lab_results.unit quando possível e validar HbA1c implausível, como 0. Faixa sugerida: 3 a 20.