LevelUpFit

Tables (17)

Users (Untitled)

  • user_id — SERIAL — Primary key — NOT NULL
  • Email — VARCHAR(255)
  • nicknamen (nickname) — VARCHAR(50)
  • dob — DATE
  • level — INTEGER
  • gender — VARCHAR(10)
  • profile — VARCHAR(255)
  • access_token — VARCHAR(200)
  • refresh_token — VARCHAR(200)

Video (Untitled2)

  • video_id — SERIAL — Primary key — NOT NULL
  • exercises_id — int — Foreign key → exercises.exercise_id — NOT NULL
  • url — char
  • type — char

exercise_items (Untitled7)

  • exercise_items_id — SERIAL — Primary key — NOT NULL
  • routinelogs_id — SERIAL — Foreign key → exercise_records.routinelogs_id — NOT NULL
  • exercise_type — char(100)
  • sets — int
  • reps — int
  • weight_kg — int
  • rest_sec — int
  • duration_sec — int
  • order_index — int

exercise_records (Untitled6)

  • routinelogs_id — SERIAL — Primary key — NOT NULL
  • user_id — int — Foreign key → Users.user_id — NOT NULL
  • date — DATE
  • memo — VARCHAR(255)

exercise_type (Untitled14)

  • exercisetype_id — SERIAL — Primary key — NOT NULL
  • exercisetype — VARCHAR(255)
  • level — int
  • example_video — VARCHAR(255)

exercises (Untitled3)

  • exercise_id — SERIAL — Primary key — NOT NULL
  • user_id — int — Foreign key → Users.user_id — NOT NULL
  • exercisetype_id — SERIAL — Foreign key → exercise_type.exercisetype_id — NOT NULL

feedback_criteria (Untitled15)

  • criteria_id — SERIAL — Primary key — NOT NULL
  • exercisetype_id — SERIAL — Foreign key → exercise_type.exercisetype_id — NOT NULL
  • body_part — VARCHAR(255)
  • angle_range — JSON
  • feedback_msg — VARCHAR(255)

feedbacks (Untitled4)

  • exercises_id — int — Foreign key → Video.exercises_id — NOT NULL
  • pose_accuracy — float
  • incorrect_parts — TEXT or JSON
  • feedback_text — TEXT
  • feedback_url — char
  • created_at — date

form_user (Untitled10)

  • user_id — int — Foreign key → Users.user_id — NOT NULL
  • passwd — VARCAHR(255)

routine_exercise (Untitled17)

  • routine_exercise_id — SERIAL — Primary key — NOT NULL
  • name — VARCHAR(100)
  • category — VARCHAR(50)
  • image — VARCHAR(255)

routine_item_logs (Untitled9)

  • routineitem_logs — SERIAL — Primary key — NOT NULL
  • exercise_id — int — Foreign key → exercises.exercise_id — NOT NULL
  • exercise_items_id — SERIAL — Foreign key → exercise_items.exercise_items_id — NOT NULL
  • exercisetype_id — SERIAL — Foreign key → exercises.exercisetype_id — NOT NULL

routine_item_sets (Untitled16)

  • item_set_id — SERIAL — Primary key — NOT NULL
  • routine_items_id — SERIAL — Foreign key → routine_items.routine_items_id — NOT NULL
  • set_num — int
  • reps — int
  • weight — float
  • rest_time — int

routine_items (Untitled12)

  • routine_items_id — SERIAL — Primary key — NOT NULL
  • routine_id — int — Foreign key → routines.routine_id — NOT NULL
  • routine_exercise_id — SERIAL — Foreign key → routine_exercise.routine_exercise_id — NOT NULL
  • order_num — int

routine_records (Untitled13)

  • record_id — SERIAL — Primary key — NOT NULL
  • user_id — int — Foreign key → Users.user_id — NOT NULL
  • routine_id — int — Foreign key → routines.routine_id — NOT NULL
  • performed_at — DATE
  • total_duration_min — int
  • total_weight — int

routines (Untitled5)

  • routine_id — SERIAL — Primary key — NOT NULL
  • user_id — int — Foreign key → Users.user_id — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • is_default — BOOLEAN
  • is_public — BOOLEAN
  • level — int
  • created_at — DATE
  • image — VARCHAR(255)

social_user (Untitled11)

  • user_id — int — Foreign key → Users.user_id — NOT NULL
  • provider_type — ENUM
  • email — VARCHAR(255)

user_strength (Untitled8)

  • user_id — SERIAL — Foreign key → Users.user_id — NOT NULL
  • Squat — int
  • BenchPress — int
  • Deadlift — int