title: Have constraints such that foreign key is in table 1 is not foreign key in table 2
body: <p>I have a table Property, now there are two tables Rent and sale, each having property_id as the foreign key. How can I assure that whatever property_id is in Rent must not be repeated in sale? If it does MySQL should throw an error.</p>
  
  <p>This is the Rent Table, exactly similar is Sale </p>
  
  <pre><code>CREATE TABLE Rent
  (
    /*some data*/
    Property_id INT NOT NULL,
    PRIMARY KEY (Property_id),
    FOREIGN KEY (Property_id) REFERENCES Property(Property_id) ON DELETE CASCADE
  );
  </code></pre>