헬스ERD
테이블 (10)
Diet_Logs
- diet_id — INT
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
- date — DATE — NOT NULL
- meal_time — ENUM('BREAKFAST', 'LUNCH', 'DINNER', 'SNACK')
- calories — INT
- description — TEXT
Equipment_Reports
- report_id — INT
- equipment_id — INT — 외래 키 → Gym_Equipment.equipment_id — NOT NULL
- reporter_id — INT — 외래 키 → Users.user_id — NOT NULL
- assignee_id — INT — 외래 키 → Users.user_id
- issue_detail — TEXT — NOT NULL
- report_status — ENUM('PENDING', 'IN_PROGRESS', 'RESOLVED')
- created_at — TIMESTAMP
Exercise_Logs
- log_id — INT
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
- exercise_id — INT — 외래 키 → Exercises.exercise_id — NOT NULL
- date — DATE — NOT NULL
- weight — FLOAT
- sets — INT
- reps — INT
- distance — FLOAT
- speed — FLOAT
- duration — INT
Exercises
- exercise_id — INT
- name — VARCHAR(100) — NOT NULL
- category — ENUM('WEIGHT', 'CARDIO') — NOT NULL
Gym_Equipment
- equipment_id — INT
- gym_id — INT — 외래 키 → Gyms.gym_id — NOT NULL
- exercise_id — INT — 외래 키 → Exercises.exercise_id — NOT NULL
- serial_number — VARCHAR(50)
- status — ENUM('NORMAL', 'BROKEN', 'REPAIRING')
- purchase_date — DATE
- last_check_date — DATE
Gyms
- gym_id — INT
- gym_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255)
- created_at — TIMESTAMP
Missions
- mission_id — INT
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- category — ENUM('WEIGHT', 'CARDIO', 'ATTENDANCE') — NOT NULL
- base_exp_reward — INT
Trainer_Student
- id — INT
- trainer_id — INT — 외래 키 → Users.user_id — NOT NULL
- member_id — INT — 외래 키 → Users.user_id — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE')
- start_date — DATE
User_Missions
- user_mission_id — INT
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
- mission_id — INT — 외래 키 → Missions.mission_id — NOT NULL
- target_value — FLOAT — NOT NULL
- current_value — FLOAT
- status — ENUM('PROGRESS', 'COMPLETED', 'FAILED')
- exp_reward — INT
- assigned_at — TIMESTAMP
- completed_at — TIMESTAMP
Users
- user_id — INT
- gym_id — INT — 외래 키 → Gyms.gym_id
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — ENUM('MEMBER', 'TRAINER', 'ADMIN')
- level — INT
- exp — INT
- created_at — TIMESTAMP