health mate v2

Tables (14)

Copy Of user_records (CopyOfuser_records)

  • record_id — INTEGER
  • weight — NUMERIC(6,2)
  • reps — INTEGER
  • time — INTEGER
  • distance — NUMERIC(6,2)
  • score — INTEGER — NOT NULL
  • verified — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

Copy Of users (CopyOfusers)

  • user_id (id) — INTEGER — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • profile_image — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • rank_tier — rank_tier_enum
  • birth — DATE

challenge_exercises

  • challenge_exercise_id (id) — INTEGER — Primary key — NOT NULL
  • challenge_id (id2) — INTEGER — Foreign key → challenges.challenge_id — NOT NULL
  • exercise_id (id3) — INTEGER — Foreign key → exercises.exercise_id — NOT NULL
  • weight_factor — NUMERIC(3,2)
  • rep_factor — NUMERIC(3,2)
  • time_factor — NUMERIC(3,2)
  • distance_factor — NUMERIC(3,2)

challenges

  • challenge_id (id) — INTEGER — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — challenge_status_enum — NOT NULL

exercise_muscle_mapping

  • mapping_id (id) — INTEGER — Primary key — NOT NULL
  • exercise_id (id2) — INTEGER — Foreign key → exercises.exercise_id — NOT NULL
  • muscle_group_id (id3) — INTEGER — Foreign key → muscle_groups.muscle_group_id — NOT NULL
  • impact_level — NUMERIC(3,2) — NOT NULL

exercises

  • exercise_id (id) — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • measurement_type — VARCHAR(50) — NOT NULL
  • muscle_focus_area — VARCHAR(50)
  • exercise_type — VARCHAR(20) — NOT NULL
  • image — VARCHAR(255)

friendships

  • friendship_id (id) — INTEGER — Primary key — NOT NULL
  • user_id (id2) — INTEGER — Foreign key → users.user_id — NOT NULL
  • friend_id — INTEGER — NOT NULL
  • status — friendship_status_enum — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

muscle_groups

  • muscle_group_id (id) — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • body_position — VARCHAR(100)
  • image — VARCHAR(255)

muscle_rankings

  • muscle_ranking_id (id) — INTEGER — Primary key — NOT NULL
  • muscle_group_id (id2) — INTEGER — Foreign key → muscle_groups.muscle_group_id — NOT NULL
  • user_id (id3) — INTEGER — Foreign key → users.user_id — NOT NULL
  • score — INTEGER — NOT NULL
  • overall_rank — INTEGER
  • friend_rank — INTEGER
  • last_calculated_at — TIMESTAMP — NOT NULL

rankings

  • ranking_id (id) — INTEGER — Primary key — NOT NULL
  • challenge_id (id2) — INTEGER — Foreign key → challenges.challenge_id — NOT NULL
  • user_id (id3) — INTEGER — Foreign key → users.user_id — NOT NULL
  • total_score — INTEGER — NOT NULL
  • overall_rank — INTEGER
  • friend_rank — INTEGER

user_body_stats

  • body_stat_id (id) — INTEGER — Primary key — NOT NULL
  • user_id (id2) — INTEGER — Foreign key → users.user_id — NOT NULL
  • weight — NUMERIC(6,2)
  • height — NUMERIC(5,2)
  • body_fat_percentage — NUMERIC(5,2)
  • recorded_at — TIMESTAMP — NOT NULL

user_muscle_scores

  • user_muscle_score_id (id) — INTEGER — Primary key — NOT NULL
  • user_id (id2) — INTEGER — Foreign key → users.user_id — NOT NULL
  • muscle_group_id (id3) — INTEGER — Foreign key → muscle_groups.muscle_group_id — NOT NULL
  • score — INTEGER — NOT NULL
  • last_calculated_at — TIMESTAMP — NOT NULL

user_records

  • user_id (id2) — INTEGER — Foreign key → users.user_id — NOT NULL
  • challenge_exercise_id (id3) — INTEGER — Foreign key → challenge_exercises.challenge_exercise_id — NOT NULL
  • record_id — INTEGER
  • weight — NUMERIC(6,2)
  • reps — INTEGER
  • time — INTEGER
  • distance — NUMERIC(6,2)
  • score — INTEGER — NOT NULL
  • verified — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • user_id (id) — INTEGER — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • profile_image — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • rank_tier — rank_tier_enum
  • birth — DATE