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