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)