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