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