gistfile1.txt

FOREIGN KEY(id) REFERENCES player (id), \n\tCHECK (throws IN ((0,), (1,))), \n\tCHECK (bats IN ((0,), (1,)))\n)\n\n'

CREATE TABLE baseball_player (
  id INTEGER NOT NULL,
  number_bats INTEGER,
  throws VARCHAR(1),
  bats VARCHAR(1),
  number INTEGER,
  experience INTEGER,
  PRIMARY KEY (id),
  FOREIGN KEY(id) REFERENCES player (id),
  CHECK (throws IN ((0,), (1,))),
  CHECK (bats IN ((0,), (1,)))
)