LevelUpFit-exercise

Tables (5)

exercise_logs (Untitled5)

  • exercise_log_id — SERIAL — Primary key — NOT NULL
  • user_id — SERIAL
  • name — VARCHAR
  • target_muscle — VARCHAR
  • feedback — VARCHAR

exercises (Untitled)

  • exercise_id — SERIAL — Primary key — NOT NULL
  • name — VARCHAR(255)
  • description — TEXT
  • thumbnail_url — VARCHAR(255)
  • target_muscle — VARCHAR(100)
  • feedback_available — BOOLEAN

routine_exercises (Untitled3)

  • routines_exercises_id — SERIAL — Primary key — NOT NULL
  • routines_id — SERIAL — Foreign key → routines.routines_id — NOT NULL
  • exercise_id — SERIAL — Foreign key → exercises.exercise_id — NOT NULL
  • sets — INT
  • reps — INT
  • rest_time — INT
  • exercise_order — INT

routine_logs (Untitled4)

  • routine_log_id — SERIAL — Primary key — NOT NULL
  • routines_id — INT — Foreign key → routines.routines_id — NOT NULL
  • user_id — INT
  • performed_date — Date
  • created_at — Date

routines (Untitled2)

  • routines_id — SERIAL — Primary key — NOT NULL
  • user_id — INT
  • name — VARCHAR(100)
  • description — TEXT
  • difficulty — INT
  • created_at — TIMESTAMP