LoGym2
Tables (7)
equipment_master
- id — UUID
- name — VARCHAR(100) — NOT NULL
- target_muscle — VARCHAR(50) — NOT NULL
- brand — VARCHAR(50)
follows
- follower_id — UUID — Foreign key → users.id — NOT NULL
- following_id — UUID — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
gym_equipment
- id — UUID
- gym_id — UUID — Foreign key → gyms.id — NOT NULL
- equipment_id — UUID — Foreign key → equipment_master.id — NOT NULL
- status — VARCHAR(20)
- requested_by — UUID — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
gyms
- id — UUID
- kakao_place_id — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- latitude — DECIMAL(10, 8) — NOT NULL
- longitude — DECIMAL(11, 8) — NOT NULL
- address — VARCHAR(255) — NOT NULL
users
- id — UUID
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_img_url — VARCHAR(255)
- role — VARCHAR(20)
- active_gym_id — UUID — Foreign key → gyms.id
- active_gym_name — VARCHAR(100)
- created_at — TIMESTAMP
workout_logs
- id — UUID
- user_id — UUID — Foreign key → users.id — NOT NULL
- gym_id — UUID — Foreign key → gyms.id
- start_time — TIMESTAMP — NOT NULL
- end_time — TIMESTAMP — NOT NULL
- total_duration — INTEGER — NOT NULL
- image_url — VARCHAR(255)
- visibility — VARCHAR(20)
- created_date — DATE — NOT NULL
workout_sets
- id — UUID
- log_id — UUID — Foreign key → workout_logs.id — NOT NULL
- equipment_id — UUID — Foreign key → equipment_master.id — NOT NULL
- set_number — INTEGER — NOT NULL
- weight — DECIMAL(5, 2) — NOT NULL
- reps — INTEGER — NOT NULL