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