dd

Tables (10)

Average_by_age_gender

  • age_group — NUMBER
  • gender — NUMBER(1)
  • avg_sleep_time — INTERVAL
  • avg_steps — NUMBER
  • avg_weight — NUMBER
  • avg_height — NUMBER

Food

  • food_name — VARCHAR2(255)
  • calories_per_gram — NUMBER

Food_log

  • user_id — VARCHAR2(255)
  • food_name — VARCHAR2(255)
  • food_weight — NUMBER
  • food_calories — NUMBER
  • time — TIMESTAMP
  • recorded_at — TIMESTAMP

User

  • user_id — VARCHAR2(255) — Primary key
  • user_password — VARCHAR2(255)
  • user_name — VARCHAR2(255)
  • email — VARCHAR2(255)

body_info

  • user_id — VARCHAR2(255)
  • gender — NUMBER(1)
  • age — NUMBER
  • birth — TIMESTAMP
  • height — NUMBER
  • activity_factor — NUMBER
  • blood_pressure_systolic — NUMBER
  • blood_pressure_diastolic — NUMBER

heart_rate

  • user_id — VARCHAR2(255)
  • heart_rate — NUMBER
  • time — TIMESTAMP
  • recorded_at — TIMESTAMP

sleep_actual

  • user_id — VARCHAR2(255)
  • actual_start_sleep_time — TIMESTAMP
  • actual_end_sleep_time — TIMESTAMP
  • actual_sleep_time — INTERVAL
  • recorded_at — TIMESTAMP

steps

  • user_id — VARCHAR2(255)
  • steps — NUMBER
  • time — TIMESTAMP
  • recorded_at — TIMESTAMP

target

  • user_id — VARCHAR2(255)
  • weight — NUMBER
  • sleep — INTERVAL
  • steps — NUMBER
  • food — NUMBER

weight_log

  • user_id — VARCHAR2(255)
  • weight — NUMBER
  • bmi — NUMBER
  • time — TIMESTAMP
  • recorded_at — TIMESTAMP