title: Oracle foreign key relation
body: <p>I have a composite primary key in my <code>Candidate</code> table</p>
  
  <pre><code>CREATE TABLE CANDIDATE(
  CANDIDATE_ID VARCHAR(5),
  NAME VARCHAR(30),
  TELEPHONE NUMBER,
  PRIMARY KEY(CANDIDATE_ID, NAME));
  </code></pre>
  
  <p>When I create a child table, I get an error saying the number of referencing columns must match referenced columns when I create a foreign key for the CANDIDATE_ID</p>
  
  <pre><code>CREATE TABLE JOB(
  POSITION_ID VARCHAR(5) PRIMARY KEY,
  CANDIDATE_ID VARCHAR(5),
  DATE2 DATE,
  FOREIGN KEY(CANDIDATE_ID) REFERENCES CANDIDATE); 
  </code></pre>