과제

테이블 (3)

basketball_player

  • player_id — BIGINT
  • player_no — INT — NOT NULL
  • player_name — VARCHAR(50) — NOT NULL
  • age — INT
  • position — VARCHAR(20)
  • team_id — BIGINT — 외래 키 → basketball_team.team_id — NOT NULL

basketball_team

  • team_id — BIGINT
  • team_name — VARCHAR(50) — NOT NULL
  • hometown — VARCHAR(50) — NOT NULL
  • mascot — VARCHAR(50)
  • founded_year — INT

body_info

  • body_info_id — BIGINT
  • player_id — BIGINT — 외래 키 → basketball_player.player_id — NOT NULL
  • height_cm — DECIMAL(5,2) — NOT NULL
  • weight_kg — DECIMAL(5,2) — NOT NULL
  • wingspan_cm — DECIMAL(5,2)