fitness

Tables (4)

class

  • class_id — BIGINT — Primary key
  • trainer_id (trainer_id2) — BIGINT — Foreign key → trainer.trainer_id
  • title — VARCHAR(100) — NOT NULL
  • schedule_time — DATETIME — NOT NULL

enrollment

  • enrollment_id — BIGINT — Primary key
  • member_id (member_id2) — BIGINT — Foreign key → member.member_id
  • class_id — BIGINT — Foreign key → class.class_id
  • trainer_id (trainer_id2) — BIGINT — Foreign key → class.trainer_id

member

  • member_id — BIGINT — Primary key
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)

trainer

  • trainer_id — BIGINT — Primary key
  • name — VARCHAR(50) — NOT NULL
  • specialty — VARCHAR(50)