ㅁㅁ

Tables (5)

activity

  • activity_id — VARCHAR(20)
  • user_id — VARCHAR(20)
  • activity_type — VARCHAR(50)
  • start_time — DATETIME
  • end_time — DATETIME
  • calories_burned — FLOAT

device

  • device_id — VARCHAR(20)
  • brand — VARCHAR(50)
  • model — VARCHAR(50)
  • user_id — VARCHAR(20)

feedback

  • feedback_id — VARCHAR(20)
  • user_id — VARCHAR(20)
  • activity_id — VARCHAR(20)
  • rating — INT
  • comment — TEXT — EX
  • feedback_time — DATETIME

sensor_data

  • sensor_id — VARCHAR(20)
  • device_id — VARCHAR(20)
  • timestamp — DATETIME
  • heart_rate — INT
  • hrv — FLOAT
  • steps — INT

user

  • user_id — VARCHAR(20)
  • name — VARCHAR(100)
  • age — INT
  • gender — VARCHAR(10)
  • join_date — DATE