title: ORA-00904: "ID": invalid identifier
body: <p>Trying to create a table with a foreign key. I keep getting <code>ORA-00904</code> error. What am I doing wrong. Is it because table of the foreign key is not yet created ?</p>
  
  <pre><code>CREATE TABLE ingredients( 
     ingredient_id       number(2,0),
     ingredient          VARCHAR2(55) NOT NULL,
     quantity_required   VARCHAR2(15) NOT NULL,
     optional_ingredient VARCHAR2(30) NOT NULL,
     CONSTRAINT pk_ingr_id PRIMARY KEY(ingredient_id),
     CONSTRAINT fk_ingredient_list FOREIGN KEY(id) REFERENCES ingredient_list(id)
  );
  </code></pre>