title: B2B ecommerce customer special price database design
body: <p>I am currently building an B2B ecommerce site.
  Currently i am stuck at defining special price for a customer for a specific item.</p>
  <p>I have two tables which is:</p>
  <ul>
  <li>Customer (Regular customer details, like name, password etc)</li>
  <li>Items (With default price listed)</li>
  </ul>
  <p>A customer can have special prices for some products. Like:</p>
  <p>Item A (costs $10 (default price))
  Customer A got a discount for Item A (costs $7 for Customer A)</p>
  <p>What i had in my mind, was just a middle table with (Customer (FK), Item (FK), Special price)</p>
  <p>Will that be a good practice?</p>
  <p>Thanks!</p>