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)