ㅁㄴㅇ

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