ㅎㅎ
Tables (8)
audit_logs
- id — BIGINT
- user_id — VARCHAR(36)
- event_type — VARCHAR(100)
- event_json — JSON
- created_at — TIMESTAMP
exercises
- exercise_id — VARCHAR(36)
- name — VARCHAR(200) — NOT NULL
- target_muscles — JSON
- secondary_muscles — JSON
- equipment — JSON
- difficulty — TINYINT
- recommended_sets — INT
- recommended_reps — VARCHAR(50)
- rest_time_sec — INT
- recovery_time_hours — INT
- demo_video_url — VARCHAR(400)
- contraindications — JSON
- tags — JSON
muscle_state_cache
- id — BIGINT
- user_id — VARCHAR(36) — NOT NULL
- date — DATE — NOT NULL
- muscle — VARCHAR(100) — NOT NULL
- recovery_score — DECIMAL(5,4)
- fatigue_contrib — DECIMAL(8,3)
- updated_at — TIMESTAMP
rehab_profiles
- profile_id — VARCHAR(36)
- name — VARCHAR(200) — NOT NULL
- target_conditions — JSON
- template_json — JSON
- safety_notes — TEXT
- last_updated — TIMESTAMP
user_daily_status
- id — BIGINT
- user_id — VARCHAR(36) — NOT NULL
- date — DATE — NOT NULL
- sleep_hours — DECIMAL(4,2)
- rpe — TINYINT
- stress_level — TINYINT
- pain_scores — JSON
- note — TEXT
- created_at — TIMESTAMP
user_workout_sessions
- session_id — VARCHAR(36)
- user_id — VARCHAR(36) — NOT NULL
- date — TIMESTAMP
- plan_json — JSON
- actual_json — JSON
- duration_seconds — INT
- completed — BOOLEAN
- pain_reported — BOOLEAN
- created_at — TIMESTAMP
user_workout_sets
- set_id — BIGINT
- session_id — VARCHAR(36) — NOT NULL
- user_id — VARCHAR(36) — NOT NULL
- exercise_id — VARCHAR(36)
- set_index — SMALLINT
- reps — SMALLINT
- weight — DECIMAL(8,3)
- tempo — VARCHAR(50)
- rpe — TINYINT
- pain_during_set — TINYINT
- created_at — TIMESTAMP
users
- user_id — VARCHAR(36)
- email — VARCHAR(255)
- password_hash — VARCHAR(255)
- created_at — TIMESTAMP
- name — VARCHAR(100)
- birthdate — DATE
- sex — VARCHAR(10)
- height_cm — INT
- weight_kg — DECIMAL(6,2)
- experience_level — TINYINT
- main_goal — VARCHAR(50)
- equipment — JSON
- medical_flags — JSON
- preferred_split — JSON
- locale — VARCHAR(10)
- last_active — TIMESTAMP