health_care

Tables (15)

assignment_completions

  • id — BIGINT — Primary key — NOT NULL
  • assignment_id — BIGINT — Foreign key → assignments.id — NOT NULL
  • checked_at — DATETIME — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • note — TEXT

assignments

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.id
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • target_amount — VARCHAR(100)
  • due_date — DATE
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME

feedbacks

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.id
  • analysis_id — BIGINT — Foreign key → posture_analysis.id
  • caution_note — TEXT
  • next_check_point — TEXT
  • created_at — DATETIME — NOT NULL

member_body_profiles

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • height_cm — DECIMAL(5,2)
  • weight_kg — DECIMAL(5,2)
  • body_type_note — TEXT
  • created_at — DATETIME — NOT NULL

member_consents

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • consent_type — VARCHAR(50) — NOT NULL
  • consent_text — TEXT
  • is_agreed — BOOLEAN — NOT NULL
  • agreed_at — DATETIME

member_health_notes

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • pain_area — VARCHAR(100)
  • injury_history — TEXT
  • precautions — TEXT
  • asymmetry_note — TEXT
  • created_at — DATETIME — NOT NULL

members

  • id — BIGINT — Primary key — NOT NULL
  • trainer_id — BIGINT — Foreign key → trainers.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(30)
  • age — INT
  • gender — VARCHAR(20)
  • fitness_goal — VARCHAR(255)
  • exercise_experience — TEXT
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

posture_analysis

  • id — BIGINT — Primary key — NOT NULL
  • posture_image_id — BIGINT — Foreign key → posture_images.id — NOT NULL
  • model_name — VARCHAR(100)
  • movement_name — VARCHAR(100)
  • analysis_status — VARCHAR(30) — NOT NULL
  • main_issue — VARCHAR(255)
  • sub_issue — VARCHAR(255)
  • result_note — TEXT
  • analyzed_at — DATETIME

posture_images

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.id
  • movement_name — VARCHAR(100)
  • image_path — VARCHAR(500) — NOT NULL
  • upload_status — VARCHAR(30) — NOT NULL
  • uploaded_at — DATETIME — NOT NULL

posture_keypoints

  • id — BIGINT — Primary key — NOT NULL
  • analysis_id — BIGINT — Foreign key → posture_analysis.id — NOT NULL
  • point_name — VARCHAR(50) — NOT NULL
  • x — DECIMAL(8,3)
  • y — DECIMAL(8,3)
  • confidence — DECIMAL(5,4)

posture_scores

  • id — BIGINT — Primary key — NOT NULL
  • analysis_id — BIGINT — Foreign key → posture_analysis.id — NOT NULL
  • total_score — INT
  • knee_alignment_score — INT
  • upper_body_score — INT
  • pelvis_balance_score — INT
  • lower_body_stability_score — INT
  • improvement_points — TEXT
  • created_at — DATETIME — NOT NULL

reports

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.id
  • analysis_id — BIGINT — Foreign key → posture_analysis.id
  • report_title — VARCHAR(150)
  • workout_summary — TEXT
  • posture_summary — TEXT
  • good_points — TEXT
  • caution_points — TEXT
  • next_assignment — TEXT
  • created_at — DATETIME — NOT NULL

session_exercises

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.id — NOT NULL
  • exercise_name — VARCHAR(100) — NOT NULL
  • sets — INT
  • reps — INT
  • weight_kg — DECIMAL(6,2)
  • note — TEXT

sessions

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • trainer_id — BIGINT — Foreign key → trainers.id — NOT NULL
  • session_date — DATE — NOT NULL
  • focus_area — VARCHAR(100)
  • memo — TEXT
  • next_memo — TEXT
  • raw_voice_text — TEXT
  • summary — TEXT
  • created_at — DATETIME — NOT NULL

trainers

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(30)
  • center_name — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL