title: Missing Left Parenthesis Error - Creating Foreign Keys
body: <p>I'm a bit confused where my missing left parenthesis is coming into play (ORA-00906: missing left parenthesis). Any suggestions? Below is an example of similar syntax with obvious test names. Thanks for any suggestions!</p>
  
  <pre><code>CREATE TABLE rosters (
          rosterid    NUMBER(5) PRIMARY KEY,
          playerid    NUMBER(5) NOT NULL,
          teamid      NUMBER(5) NOT NULL,
          seasonid    NUMBER(5) NOT NULL,
  CONSTRAINT fk_player FOREIGN KEY playerid REFERENCES players(playerid),
  CONSTRAINT fk_team FOREIGN KEY teamid REFERENCES teams(teamid),
  CONSTRAINT fk_season FOREIGN KEY seasonid REFERENCES season(seasonid);
  </code></pre>