fitu
Tables (16)
friendships
- id — BIGINT — Primary key — NOT NULL
- user_id_a — BIGINT — Foreign key → users.id
- user_id_b — BIGINT — Foreign key → users.id
media_files
- id — BIGINT — Primary key — NOT NULL
- uploader_id — BIGINT — Foreign key → users.id
- url — VARCHAR(500)
- uploaded_at — DATETIME
- category — VARCHAR(50)
physical_infos
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- recorded_at — DATETIME
- body_fat — INT
- muscle — INT
- height — INT
- weight — INT
post_comments
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → posts.id
- writer_id — BIGINT — Foreign key → users.id
- root_id — BIGINT
- contents — TEXT
- created_at — DATETIME
- is_secret — TINYINT(1)
posts
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50)
- university_id — BIGINT — Foreign key → universities.id
- writer_id — BIGINT — Foreign key → users.id
- title — VARCHAR(255)
- contents — TEXT
- created_at — DATETIME
reports
- id — BIGINT — Primary key — NOT NULL
- reporter_id — BIGINT — Foreign key → users.id
- target_id — BIGINT
- target_type — VARCHAR(50)
- created_at — DATETIME
session_exercises
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id
- workout_id — BIGINT — Foreign key → workouts.id
- order_index — INT
sessions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- start_time — DATETIME
- end_time — DATETIME
- exercise_image_id — BIGINT — Foreign key → media_files.id
sets
- id — BIGINT — Primary key — NOT NULL
- session_exercise_id — BIGINT — Foreign key → session_exercises.id
- set_index — INT
- weight — INT
- reps — INT
universities
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- domain_name — VARCHAR(255)
users
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- gender — VARCHAR(50)
- kakao_email — VARCHAR(255)
- role — VARCHAR(50)
- friend_code — VARCHAR(255)
- status — VARCHAR(50)
- suspend_end_at — DATETIME
- university_id — BIGINT — Foreign key → universities.id
- university_email — VARCHAR(255)
- profile_img_id — BIGINT — Foreign key → media_files.id
- profile_visibility — TINYINT(1)
workout_categories
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
- priority — INT
workout_detail_logs
- id — BIGINT — Primary key — NOT NULL
- workout_log_id — BIGINT — Foreign key → workout_logs.id
- workout_id — BIGINT — Foreign key → workouts.id
- weight — INT
- num_of_sets — INT
- reps_per_set — INT
workout_logs
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- date — DATETIME
workout_verifications
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- video_id — BIGINT — Foreign key → media_files.id
- workout_type — VARCHAR(50)
- request_date — DATETIME
- status — VARCHAR(50)
- weight — INT
workouts
- id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → workout_categories.id
- equipment_id — BIGINT
- name — VARCHAR(50)
- workout_name — VARCHAR(255)
- description — VARCHAR(1000)
- image_id — BIGINT — Foreign key → media_files.id
- image_url — VARCHAR(500)
- gif_id — BIGINT — Foreign key → media_files.id
- gif_url — VARCHAR(500)