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