workout-routine

Tables (4)

exercise

  • id — BIGINT
  • name — VARCHAR(128) — NOT NULL

session_order

  • id — BIGINT
  • workout_session_id — BIGINT — Foreign key → workout_session.id
  • exercise_no — INT
  • exercise_id — BIGINT — Foreign key → exercise.id

set_log

  • id — BIGINT
  • session_order_id — BIGINT — Foreign key → session_order.id
  • set_no — INT
  • weight — INT
  • reps — INT
  • complete — VARCHAR(256)

workout_session

  • id — BIGINT
  • title — VARCHAR(128) — NOT NULL