title: How do I use multiple foreign keys in one table referencing another table in cakephp
body: <p>Using cakephp, I have a generic address table, which I want to link to customers, vendors, contacts. most of the tables only have a 1 to 1 relationship, but I want my customers table to have 2</p>
  
  <p>perhaps for clarification:
  I have a customers table</p>
  
  <pre><code>id, int
  mailing_address_id, int
  billing_address_id, int
  </code></pre>
  
  <p>and an addresses table</p>
  
  <pre><code>id,int
  addr, varchar
  city, varchar
  etc....
  </code></pre>
  
  <p>Now I know I could put a <code>customer_id</code> in the addresses table. But I don't want to do that because I have a vendors table, and contacts table, and other tables that all are going to use the addresses table. the <code>customer_id</code> would not really be relavant to those other tables.</p>
  
  <p>I'd like the Customer model to automatically link in the two addresses </p>