숙제

테이블 (3)

BASKETBALL_PLAYER

  • player_id — INT — 기본 키 — NOT NULL
  • team_id — INT — 외래 키 → TEAM.team_id — NOT NULL
  • player_name — VARCHAR(50) — NOT NULL
  • age — INT
  • position — VARCHAR(20)
  • join_date — DATE

PHYSICAL_INFO

  • player_id — INT — 외래 키 → BASKETBALL_PLAYER.player_id — NOT NULL
  • height — DECIMAL(5,2)
  • weight — DECIMAL(5,2)
  • body_fat — DECIMAL(4,2)
  • wingspan — DECIMAL(5,2)

TEAM

  • team_id — INT — 기본 키 — NOT NULL
  • team_name — VARCHAR(50) — NOT NULL
  • home_city — VARCHAR(50) — NOT NULL
  • mascot — VARCHAR(50)
  • founded_year — INT
  • coach_name — VARCHAR(50)