title: CakePHP: Translating database 'inheritance' into app models/controllers
body: <p>I am currently designing a database for a system containing a number of different user types. My schema look like this:</p>
  
  <pre><code>## Users
  
  id INT
  name VARCHAR(60)
  email VARCHAR(60)
  
  ## Doctors
  
  id INT
  user_id INT
  specialism VARCHAR(60)
  qualification_id INT
  </code></pre>
  
  <p>Essentially, the Doctors table is a child of the Users table. </p>
  
  <p>Now, when i'm creating my models and controllers and models in Cake, I thought it was logical to create a User model and then <strong>subclass it with a Doctor model</strong>. But this doesn't seem to work when testing with the $scaffold (the <strong>'has one'</strong> and <strong>'belongs to'</strong> relationships work relatively well, but this way I would not be subclassing the Users classes).</p>
  
  <p><em>What approach would you suggest for a database designed in this way?</em></p>