aihealthpj
Tables (5)
health_metrics
- id — INT
- user_id — INT — NOT NULL
- date — DATE — NOT NULL
- systolic — INT — NOT NULL — 수축기 혈압
- diastolic — INT — NOT NULL — 이완기 혈압
- blood_sugar — INT — NOT NULL
- sleep_hours — FLOAT — NOT NULL
- sleep_start — TIME — 취침 시각
- sleep_end — TIME — 기상 시각
- sleep_quality — VARCHAR(20) — 수면 품질
- prep_duration — INT — 취침 준비 시간(분)
- created_at — TIMESTAMP
meal_logs
- id — VARCHAR(36) — 프론트엔드 UUID
- user_id — INT — NOT NULL
- date — DATE — NOT NULL
- target_kcal — INT — NOT NULL
- recommendation — TEXT — NOT NULL
- created_at — TIMESTAMP
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- height — FLOAT — NOT NULL — cm
- target_weight — FLOAT — NOT NULL — kg
- goal — VARCHAR(50) — NOT NULL — HealthGoal enum
- age — INT — NOT NULL
- gender — ENUM('남', '여') — NOT NULL
- created_at — TIMESTAMP
weight_records
- id — VARCHAR(36) — 프론트엔드 UUID
- user_id — INT — NOT NULL
- date — DATE — NOT NULL
- weight — FLOAT — NOT NULL
- height — FLOAT — 기록 당시 키
- bmi — FLOAT — NOT NULL
- memo — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
workout_records
- id — VARCHAR(36) — 프론트엔드 UUID
- user_id — INT — NOT NULL
- date — DATETIME — NOT NULL
- category — VARCHAR(100) — NOT NULL
- type — VARCHAR(100) — NOT NULL
- intensity — ENUM('낮음', '보통', '높음') — NOT NULL
- duration — INT — NOT NULL — 분
- met — FLOAT — NOT NULL
- calories — FLOAT — NOT NULL
- completed — BOOLEAN
- title — VARCHAR(255) — NOT NULL
- memo — TEXT
- created_at — TIMESTAMP