healthcare

Tables (4)

Untitled2 (food_record)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • Field2 (date)
  • Field3 (name)
  • Field (calories_eaten)

exercise_log

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • Field2 (date)
  • Field3 (name)
  • Field (calories_burned)
  • Field2 (duration_minutes)

user_profile

  • id — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • target_daily_calories (target_calories)

users (user)

  • id — Primary key — NOT NULL
  • username (name)
  • password
  • email
  • first_name (user_firstname)
  • last_name (user_lastname)