ㅁㄴㅇ
Tables (6)
ExerciseDetail
- id — INT — Primary key — NOT NULL
- scheduleId — INT — NOT NULL
- exerciseName — VARCHAR(255) — NOT NULL
- reps — INT — NOT NULL
- sets — INT — NOT NULL
- weight — FLOAT
- duration — INT
Member
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
Schedule
- id — INT — Primary key — NOT NULL
- date — DATETIME — NOT NULL
- location — VARCHAR(255)
- status — ENUM('MEMBER_PROPOSED', 'TRAINER_PROPOSED', 'REJECTED', 'SCHEDULED', 'COMPLETED', 'CANCELED')
- trainingTarget — VARCHAR(255) — NOT NULL
- comment — TEXT
- memberId — INT — NOT NULL
- trainerId — INT — NOT NULL
Trainer
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
TrainerMember
- memberId — INT — Primary key — NOT NULL
- trainerId — INT — Primary key — NOT NULL
- ptStartDate — DATETIME — NOT NULL
User
- id — INT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- role — ENUM('TRAINER', 'MEMBER')
- profileImage — VARCHAR(255)
- phoneNumber — VARCHAR(20)
- createdAt — DATETIME