I'm the typical Umbraco newbie that is used to designing SQL schemas, so please excuse the basic question.

I have products with prices:

- Products

  - Product1 - $100

  - Product2 - $50

  - Product3 - $150

And I also have locations:

- Locations

  - Location1

  - Location2

  - Location3

All fairly simple.  Now at each location, the product price can be overridden.  If I was designing this in SQL I would have a ProductLocation table with a PriceOverride field:

ProductLocation

  - ProductId

  - LocationId

  - PriceOverride

And for each product at each location I would look up this table to see if the price has been overridden, else use the price from the ProductLocation table.  Again, this is not rocket science, but I'm confused as to how I should design my DocumentTypes and Content in Umbraco to handle this.