ai_fitness_coach

Tables (9)

Untitled (users)

  • Key (user_id) — Primary key — NOT NULL
  • Field (account)
  • Field (password)
  • Field (gender)
  • Field2 (age)
  • Field (address)
  • Field (phone_no)
  • Field (email)
  • Field (create_at)
  • Field (updated_at)
  • Field (status)
  • Field (deleted_at)
  • Field (is_deleted)

Untitled (user_health_info)

  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (goal)
  • Field (height)
  • Field (weight)
  • Field (updated_at)

Untitled (exercise_list)

  • Key (exercise_id) — Primary key — NOT NULL
  • Field (exercise_name)
  • Field (category)

Untitled (exercise_request)

  • Key (request_id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (requested_exercise)
  • Field (description) — text
  • Field2 (status)
  • Field3 (created_at)

Untitled (user_landmark)

  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (landmark_info) — Text

Untitled (sessions)

  • Key (session_id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (exercise_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (status)
  • Field (created_at)

Untitled (user_routine)

  • Key (routine_id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (routine_name)
  • Field (created_at)

Untitled (analysis_details)

  • Key (analysis_id) — Primary key — NOT NULL
  • Key (session_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (result)
  • Field (score)
  • Field (comment) — text

Untitled (chat_logs)

  • Key (chat_id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (question)
  • Field (answer)
  • Field (q_written_at)