CREATE TABLE players (
  player_id INTEGER NOT NULL PRIMARY KEY,
  firstname VARCHAR (20) NOT NULL,
  lastname  VARCHAR (20) NULL,
  ... more stuff here ...
)

CREATE TABLE foo (
  foo_id    INTEGER NOT NULL PRIMARY KEY,
  player_id INTEGER NOT NULL REFERENCES players (player_id),
  stuff     VARCHAR(30) NOT NULL
)