practice

Tables (3)

BodyInfo

  • player_id — PK — Foreign key → Player.player_id — NOT NULL
  • height — INT
  • weight — INT

Player

  • player_id — PK — Primary key — NOT NULL
  • team_id — PK — Foreign key → Team.team_id — NOT NULL
  • number — INT
  • name — VARCHAR(50)
  • age — INT
  • position — VARCHAR(30)

Team

  • team_id — PK — Primary key — NOT NULL
  • team_name — VARCHAR(50)
  • home_city — VARCHAR(50)
  • mascot — VARCHAR(50)
  • coach_name — VARCHAR(50)