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