Health APP
테이블 (5)
건강 (HEALTH RECORD)
- record_id (Key) — INT — 기본 키 — NOT NULL
- user_id (Key2) — INT — 외래 키 → 사용자.user_id — NOT NULL
- height (Field) — FLOAT
- weight (Field2) — FLOAT
- blood_pressure (Field3) — VARCHAR
- heart_rate (Field4) — INT
- sleep_deration (Field5) — FLOAT
- steps (Field6) — INT
- record_date (Field7) — DATE
목표 (GOAL)
- goal_id (Key) — INT — 기본 키 — NOT NULL
- user_id (Key2) — INT — 외래 키 → 사용자.user_id — NOT NULL
- goal_type (Field) — VARCHAR
- target_value (Field2) — FLOAT
- current_value (Field3) — FLOAT
- goal_date (Field4) — DATE
사용자 (USER)
- user_id (Key) — INT — 기본 키 — NOT NULL
- username (Field) — VARCHAR
- password (Field2) — VARCHAR
- birthdate (Field3) — DATE
- gender (Field4) — VARCHAR
- phone_num (Field5) — VARCHAR
- email (Field6) — VARCHAR
식단 (DIET)
- meal_id (Key) — INT — 기본 키 — NOT NULL
- user_id (Key2) — INT — 외래 키 → 사용자.user_id — NOT NULL
- food_items (Field) — TEXT
- calories (Field2) — FLOAT
- nutrients (Field3) — TEXT
- meal_date (Field4) — DATE
운동 (EXERCISE RECORD)
- exercise_id (Key) — INT — 기본 키 — NOT NULL
- user_id (Key2) — INT — 외래 키 → 사용자.user_id — NOT NULL
- exercise_type (Field) — VARCHAR
- duration (Field2) — FLOAT
- intensity (Field3) — VARCHAR
- calories_burnt (Field4) — FLOAT
- exercise_date (Field5) — DATE