11

Tables (19)

analysis_details

  • analysis_id — INT — Primary key — NOT NULL
  • session_id — INT — Foreign key → sessions.session_id — NOT NULL
  • session_exercise_id — INT — Foreign key → session_exercise.session_exercise_id
  • set_id — INT — Foreign key → session_set.set_id
  • exercise_id — INT — Foreign key → exercise.exercise_id
  • rule_id — INT — Foreign key → analysis_rule.rule_id
  • metric_name — VARCHAR(50)
  • measured_value — DOUBLE
  • result — VARCHAR(10)
  • created_at — DATETIME — NOT NULL

analysis_rule

  • rule_id — INT — Primary key — NOT NULL
  • exercise_id — INT — Foreign key → exercise.exercise_id — NOT NULL
  • metric_name — VARCHAR(50) — NOT NULL
  • side — VARCHAR(10)
  • min_value — DOUBLE
  • max_value — DOUBLE
  • operator — VARCHAR(10) — 1~10
  • severity — VARCHAR(20) — 1~100
  • feedback_message — TEXT — NOT NULL
  • source_dataset — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • =분석 — 규칙(Rule Engine

chat_logs

  • chat_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • session_id — INT — Foreign key → sessions.session_id
  • question — TEXT — NOT NULL
  • answer — TEXT
  • intent — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

exercise

  • exercise_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • ko_name — VARCHAR(100)
  • category — VARCHAR(50)
  • target_muscle — VARCHAR(100)
  • difficulty — VARCHAR(20) — INFO/WARNING/DANGER
  • description — TEXT
  • source_tags — VARCHAR(255)
  • is_custom — TINYINT — NOT NULL — BASIC/AI_RECOMMENDED/USER_CUSTOM
  • created_at — DATETIME — NOT NULL

exercise_angle_stat

  • stat_id — INT — Primary key — NOT NULL
  • exercise_id — INT — Foreign key → exercise.exercise_id — NOT NULL
  • source_label — VARCHAR(50) — NOT NULL
  • side — VARCHAR(10) — NOT NULL
  • metric_name — VARCHAR(50) — NOT NULL
  • sample_count — INT — NOT NULL
  • mean_value — DOUBLE
  • std_value — DOUBLE
  • min_value — DOUBLE
  • max_value — DOUBLE
  • q1_value — DOUBLE
  • median_value — DOUBLE
  • q3_value — DOUBLE
  • p05_value — DOUBLE
  • p95_value — DOUBLE

exercise_keypoint_profile

  • profile_id — INT — Primary key — NOT NULL
  • exercise_id — INT — Foreign key → exercise.exercise_id — NOT NULL
  • source_dataset — VARCHAR(100) — NOT NULL
  • pose_format — VARCHAR(50) — NOT NULL
  • image_count — INT
  • label_count — INT
  • avg_visible_keypoints — DOUBLE
  • avg_bbox_json — TEXT
  • keypoint_visibility_json — TEXT
  • content — TEXT
  • created_at — DATETIME — NOT NULL

exercise_knowledge

  • knowledge_id — INT — Primary key — NOT NULL
  • exercise_id — INT — Foreign key → exercise.exercise_id — NOT NULL
  • source_dataset — VARCHAR(100) — NOT NULL
  • knowledge_type — VARCHAR(30) — NOT NULL — 1~10 (전체 블록 반복)
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • tags — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • =운동 — 지식(RAG

exercise_request

  • request_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • requested_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • resolved_at — DATETIME

media_assets

  • media_id — INT — Primary key — NOT NULL
  • session_id — INT — Foreign key → sessions.session_id — NOT NULL
  • set_id — INT — Foreign key → session_set.set_id
  • file_path — VARCHAR(500) — NOT NULL
  • file_type — VARCHAR(10)
  • resolution — VARCHAR(20)
  • consent_flag — TINYINT — NOT NULL

routine_exercise

  • routine_exercise_id — INT — Primary key — NOT NULL
  • routine_id — INT — Foreign key → user_routine.routine_id — NOT NULL
  • exercise_id — INT — Foreign key → exercise.exercise_id — NOT NULL
  • order_no — INT — NOT NULL — 0/1
  • target_sets_per_cycle — INT — NOT NULL — 0~100
  • target_reps_per_set — INT — NOT NULL — 1~5 별점
  • rest_sec — INT — 1~3
  • coaching_focus — VARCHAR(255)

routine_recommendation

  • recommendation_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • source_session_id — INT — Foreign key → sessions.session_id
  • routine_id — INT — Foreign key → user_routine.routine_id
  • reason — TEXT
  • model_name — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

session_exercise

  • session_exercise_id — INT — Primary key — NOT NULL
  • session_id — INT — Foreign key → sessions.session_id — NOT NULL
  • exercise_id — INT — Foreign key → exercise.exercise_id — NOT NULL
  • routine_exercise_id — INT — Foreign key → routine_exercise.routine_exercise_id
  • order_no — INT — NOT NULL — IMAGE/VIDEO
  • planned_sets_per_cycle — INT — NOT NULL — 0/1
  • planned_reps_per_set — INT — NOT NULL — 0~1
  • planned_total_sets — INT — NOT NULL — PASS/WARN/FAIL
  • completed_sets — INT
  • average_score — DOUBLE — 0~100

session_set

  • set_id — INT — Primary key — NOT NULL
  • session_exercise_id — INT — Foreign key → session_exercise.session_exercise_id — NOT NULL
  • cycle_no — INT — NOT NULL
  • target_reps — INT — NOT NULL
  • set_score — DOUBLE
  • status — VARCHAR(20) — NOT NULL

sessions

  • session_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • routine_id — INT — Foreign key → user_routine.routine_id
  • planned_cycle_count — INT — NOT NULL — 1~100
  • status — VARCHAR(20) — NOT NULL — 1~100
  • auto_timer_on — TINYINT — NOT NULL — 0~100
  • camera_permission_granted — TINYINT — NOT NULL — 1~10
  • data_consent_granted — TINYINT — NOT NULL — 1~10
  • started_at — DATETIME
  • ended_at — DATETIME
  • overall_score — DOUBLE — 1~100
  • satisfaction_score — INT — 0~100
  • gpt_summary — TEXT
  • created_at — DATETIME — NOT NULL
  • =세션(루틴 — 1회

user_health

  • health_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL — M/F/ETC
  • age — INT — BEGINNER/INTERMEDIATE/ADVANCED
  • gender — VARCHAR(10) — IMAGE/VIDEO/LIVE_CAMERA/MANUAL
  • height_cm — DOUBLE
  • weight_kg — DOUBLE
  • goal — VARCHAR(255)
  • fitness_level — VARCHAR(20) — 0~1
  • pain_history — TEXT
  • updated_at — DATETIME — NOT NULL

user_landmark

  • landmark_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL — BEGINNER/INTERMEDIATE/ADVANCED
  • calibration_name — VARCHAR(50)
  • landmark_json — TEXT — NOT NULL
  • body_ratio_json — TEXT
  • confidence_score — DOUBLE — 0/1
  • registered_at — DATETIME — NOT NULL
  • is_active — TINYINT — NOT NULL — OVERVIEW/CORRECT_POSTURE/COMMON_ERROR/ANGLE_REFERENCE/KEYPOINT_PROFILE/ROUTINE_TIP/SAFETY

user_routine

  • routine_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • routine_name — VARCHAR(100) — NOT NULL
  • routine_type — VARCHAR(20) — NOT NULL — 1~10
  • auto_timer_on — TINYINT — NOT NULL — CREATED/IN_PROGRESS/COMPLETED/CANCELLED
  • cycle_count — INT — NOT NULL — 0/1
  • recommendation_reason — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_social_auth

  • social_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL — 1:1
  • provider_uid — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • user_id — INT — Primary key — NOT NULL — 사용자 PK
  • email — VARCHAR(255) — NOT NULL
  • username — VARCHAR(100) — NOT NULL — 핸들 @b.dinan5
  • display_name — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255)
  • avatar_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL