aa

Tables (19)

analysis_details

  • analysis_id — INTEGER — Primary key — NOT NULL
  • session_id — INTEGER — Foreign key → sessions.session_id — NOT NULL
  • session_exercise_id — INTEGER — Foreign key → session_exercise.session_exercise_id
  • set_id — INTEGER — Foreign key → session_set.set_id
  • exercise_id — INTEGER — Foreign key → exercise.exercise_id
  • rule_id — INTEGER — Foreign key → analysis_rule.rule_id
  • metric_name — TEXT
  • measured_value — REAL
  • result — TEXT
  • score — REAL
  • feedback — TEXT
  • created_at — TEXT — NOT NULL

analysis_rule

  • rule_id — INTEGER — Primary key — NOT NULL
  • exercise_id — INTEGER — Foreign key → exercise.exercise_id — NOT NULL
  • metric_name — TEXT — NOT NULL
  • side — TEXT
  • min_value — REAL
  • max_value — REAL
  • operator — TEXT
  • severity — TEXT
  • feedback_message — TEXT — NOT NULL
  • source_dataset — TEXT
  • created_at — TEXT — NOT NULL

chat_logs

  • chat_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • session_id — INTEGER — Foreign key → sessions.session_id
  • question — TEXT — NOT NULL
  • answer — TEXT
  • intent — TEXT
  • created_at — TEXT — NOT NULL

exercise

  • exercise_id — INTEGER — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • ko_name — TEXT
  • category — TEXT
  • target_muscle — TEXT
  • difficulty — TEXT
  • description — TEXT
  • source_tags — TEXT
  • is_custom — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL

exercise_angle_stat

  • stat_id — INTEGER — Primary key — NOT NULL
  • exercise_id — INTEGER — Foreign key → exercise.exercise_id — NOT NULL
  • source_label — TEXT — NOT NULL
  • side — TEXT — NOT NULL
  • metric_name — TEXT — NOT NULL
  • sample_count — INTEGER — NOT NULL
  • mean_value — REAL
  • std_value — REAL
  • min_value — REAL
  • max_value — REAL
  • q1_value — REAL
  • median_value — REAL
  • q3_value — REAL
  • p05_value — REAL
  • p95_value — REAL

exercise_keypoint_profile

  • profile_id — INTEGER — Primary key — NOT NULL
  • exercise_id — INTEGER — Foreign key → exercise.exercise_id — NOT NULL
  • source_dataset — TEXT — NOT NULL
  • pose_format — TEXT — NOT NULL
  • image_count — INTEGER
  • label_count — INTEGER
  • avg_visible_keypoints — REAL
  • avg_bbox_json — TEXT
  • keypoint_visibility_json — TEXT
  • content — TEXT
  • created_at — TEXT — NOT NULL

exercise_knowledge

  • knowledge_id — INTEGER — Primary key — NOT NULL
  • exercise_id — INTEGER — Foreign key → exercise.exercise_id — NOT NULL
  • source_dataset — TEXT — NOT NULL
  • knowledge_type — TEXT — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • tags — TEXT
  • created_at — TEXT — NOT NULL

exercise_request

  • request_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • requested_name — TEXT — NOT NULL
  • description — TEXT
  • status — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL
  • resolved_at — TEXT

media_assets

  • media_id — INTEGER — Primary key — NOT NULL
  • session_id — INTEGER — Foreign key → sessions.session_id — NOT NULL
  • set_id — INTEGER — Foreign key → session_set.set_id
  • file_path — TEXT — NOT NULL
  • file_type — TEXT
  • duration_sec — REAL
  • resolution — TEXT
  • consent_flag — INTEGER — NOT NULL
  • camera_fit_score — REAL
  • created_at — TEXT — NOT NULL

routine_exercise

  • routine_exercise_id — INTEGER — Primary key — NOT NULL
  • routine_id — INTEGER — Foreign key → user_routine.routine_id — NOT NULL
  • exercise_id — INTEGER — Foreign key → exercise.exercise_id — NOT NULL
  • order_no — INTEGER — NOT NULL
  • target_sets — INTEGER — NOT NULL
  • target_reps — INTEGER — NOT NULL
  • rest_sec — INTEGER

routine_recommendation

  • recommendation_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • source_session_id — INTEGER — Foreign key → sessions.session_id
  • routine_id — INTEGER — Foreign key → user_routine.routine_id
  • reason — TEXT
  • model_name — TEXT
  • created_at — TEXT — NOT NULL

session_exercise

  • session_exercise_id — INTEGER — Primary key — NOT NULL
  • session_id — INTEGER — Foreign key → sessions.session_id — NOT NULL
  • exercise_id — INTEGER — Foreign key → exercise.exercise_id — NOT NULL
  • order_no — INTEGER — NOT NULL
  • planned_sets — INTEGER — NOT NULL
  • planned_reps — INTEGER — NOT NULL
  • completed_sets — INTEGER
  • average_score — REAL

session_set

  • set_id — INTEGER — Primary key — NOT NULL
  • session_exercise_id — INTEGER — Foreign key → session_exercise.session_exercise_id — NOT NULL
  • set_no — INTEGER — NOT NULL
  • reps_done — INTEGER
  • set_score — REAL
  • feedback_summary — TEXT
  • status — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL

sessions

  • session_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • routine_id — INTEGER — Foreign key → user_routine.routine_id
  • status — TEXT — NOT NULL
  • auto_timer_on — INTEGER — NOT NULL
  • started_at — TEXT
  • ended_at — TEXT
  • overall_score — REAL
  • satisfaction_score — INTEGER
  • gpt_summary — TEXT
  • created_at — TEXT — NOT NULL

user_health

  • health_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • age — INTEGER
  • gender — TEXT
  • height_cm — REAL
  • weight_kg — REAL
  • goal — TEXT
  • fitness_level — TEXT
  • pain_history — TEXT
  • updated_at — TEXT — NOT NULL

user_landmark

  • landmark_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • source_type — TEXT — NOT NULL
  • calibration_name — TEXT
  • landmark_json — TEXT — NOT NULL
  • body_ratio_json — TEXT
  • confidence_score — REAL
  • registered_at — TEXT — NOT NULL
  • is_active — INTEGER — NOT NULL

user_routine

  • routine_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • routine_name — TEXT — NOT NULL
  • routine_type — TEXT — NOT NULL
  • auto_timer_on — INTEGER — NOT NULL
  • cycle_count — INTEGER — NOT NULL
  • recommendation_reason — TEXT
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

user_social_auth

  • social_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • provider — TEXT — NOT NULL
  • provider_uid — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL

users

  • user_id — INTEGER — Primary key — NOT NULL
  • email — TEXT — NOT NULL
  • username — TEXT — NOT NULL
  • display_name — TEXT — NOT NULL
  • password_hash — TEXT
  • avatar_url — TEXT
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL