연습

테이블 (4)

Class (Untitled2)

  • ClassID (Key) — INT — 기본 키 — NOT NULL
  • class_name (Field) — VARCHAR
  • start_time (Field2) — TIME
  • end_time (Field3) — TIME
  • TrainerID (Key2) — INT — 외래 키 → Trainer.TrainerID — NOT NULL

Enrollment (Untitled4)

  • EnrollmentID (Key) — INT — 기본 키 — NOT NULL
  • MemberID (Key2) — INT — 외래 키 → Member.MemberID — NOT NULL
  • ClassID (Key3) — INT — 외래 키 → Class.ClassID — NOT NULL

Member (Untitled)

  • MemberID (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR
  • address (Field2) — VARCHAR
  • phone (Field3) — VARCHAR

Trainer (Untitled3)

  • TrainerID (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR
  • speciality (Field2) — VARCHAR