선택2

테이블 (5)

Class (class)

  • Class id (class_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)
  • Region id (region_id) — INT(11) — 외래 키 → Region.Region id — NOT NULL

Pro (pro)

  • Pro id (pro_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Number (number) — INT(11)
  • Class id (class_id) — INT(11) — 외래 키 → Class.Class id — NOT NULL
  • Team id (team_id) — INT(11) — 외래 키 → Team.Team id — NOT NULL

Region (region)

  • Region id (region_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)

Team (team)

  • Team id (team_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)
  • Class id (class_id) — INT(11) — 외래 키 → Class.Class id — NOT NULL

Training (training)

  • Training id (training_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)
  • Buy (buy) — CHAR(8)
  • Rent (rent) — CHAR(8)
  • Return (return) — CHAR(8) — NOT NULL