33
Tables (8)
Diet_Record
- diet_id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- record_date — DATE
- content — TEXT
- memo — TEXT
Inbody
- inbody_id — INT — NOT NULL
- member_id — INT — NOT NULL
- record_date — DATE
- weight — FLOAT
- muscle_mass — FLOAT
- fat_percent — FLOAT
- note — TEXT
Member
- member_id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- phone — VARCHAR(20)
- email — VARCHAR(100)
- join_date — DATE
PT_History
- history_id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- total_count — INT
- used_count — INT
- remain_count — INT
- expire_date — DATE
PT_Reservation
- reservation_id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- trainer_id — INT — Foreign key → Trainer.trainer_id — NOT NULL
- date — DATE
- time — TIME
- weekday — VARCHAR(20)
PT_Schedule
- schedule_id — INT — Primary key — NOT NULL
- date — DATE
- trainer_id — INT — Foreign key → Trainer.trainer_id — NOT NULL
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- reservation_time — TIME
- note — TEXT
Trainer
- trainer_id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- phone — VARCHAR(20)
Workout_Plan
- plan_id — INT — Primary key — NOT NULL
- schedule_id — INT — Foreign key → PT_Schedule.schedule_id — NOT NULL
- workout_name — VARCHAR(100)
- sets — INT
- reps — INT
- volume — VARCHAR(50)