health_care
Tables (15)
assignment_completions
- id — BIGINT — Primary key — NOT NULL
- assignment_id — BIGINT — Foreign key → assignments.id — NOT NULL
- checked_at — DATETIME — NOT NULL
- status — VARCHAR(30) — NOT NULL
- note — TEXT
assignments
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- target_amount — VARCHAR(100)
- due_date — DATE
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- completed_at — DATETIME
feedbacks
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id
- analysis_id — BIGINT — Foreign key → posture_analysis.id
- caution_note — TEXT
- next_check_point — TEXT
- created_at — DATETIME — NOT NULL
member_body_profiles
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- height_cm — DECIMAL(5,2)
- weight_kg — DECIMAL(5,2)
- body_type_note — TEXT
- created_at — DATETIME — NOT NULL
member_consents
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- consent_type — VARCHAR(50) — NOT NULL
- consent_text — TEXT
- is_agreed — BOOLEAN — NOT NULL
- agreed_at — DATETIME
member_health_notes
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- pain_area — VARCHAR(100)
- injury_history — TEXT
- precautions — TEXT
- asymmetry_note — TEXT
- created_at — DATETIME — NOT NULL
members
- id — BIGINT — Primary key — NOT NULL
- trainer_id — BIGINT — Foreign key → trainers.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(30)
- age — INT
- gender — VARCHAR(20)
- fitness_goal — VARCHAR(255)
- exercise_experience — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
posture_analysis
- id — BIGINT — Primary key — NOT NULL
- posture_image_id — BIGINT — Foreign key → posture_images.id — NOT NULL
- model_name — VARCHAR(100)
- movement_name — VARCHAR(100)
- analysis_status — VARCHAR(30) — NOT NULL
- main_issue — VARCHAR(255)
- sub_issue — VARCHAR(255)
- result_note — TEXT
- analyzed_at — DATETIME
posture_images
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id
- movement_name — VARCHAR(100)
- image_path — VARCHAR(500) — NOT NULL
- upload_status — VARCHAR(30) — NOT NULL
- uploaded_at — DATETIME — NOT NULL
posture_keypoints
- id — BIGINT — Primary key — NOT NULL
- analysis_id — BIGINT — Foreign key → posture_analysis.id — NOT NULL
- point_name — VARCHAR(50) — NOT NULL
- x — DECIMAL(8,3)
- y — DECIMAL(8,3)
- confidence — DECIMAL(5,4)
posture_scores
- id — BIGINT — Primary key — NOT NULL
- analysis_id — BIGINT — Foreign key → posture_analysis.id — NOT NULL
- total_score — INT
- knee_alignment_score — INT
- upper_body_score — INT
- pelvis_balance_score — INT
- lower_body_stability_score — INT
- improvement_points — TEXT
- created_at — DATETIME — NOT NULL
reports
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id
- analysis_id — BIGINT — Foreign key → posture_analysis.id
- report_title — VARCHAR(150)
- workout_summary — TEXT
- posture_summary — TEXT
- good_points — TEXT
- caution_points — TEXT
- next_assignment — TEXT
- created_at — DATETIME — NOT NULL
session_exercises
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id — NOT NULL
- exercise_name — VARCHAR(100) — NOT NULL
- sets — INT
- reps — INT
- weight_kg — DECIMAL(6,2)
- note — TEXT
sessions
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- trainer_id — BIGINT — Foreign key → trainers.id — NOT NULL
- session_date — DATE — NOT NULL
- focus_area — VARCHAR(100)
- memo — TEXT
- next_memo — TEXT
- raw_voice_text — TEXT
- summary — TEXT
- created_at — DATETIME — NOT NULL
trainers
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(30)
- center_name — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL