title: Seasonal Pricing for an Entity.
body: <p>I am trying to manage seasonal prices for hotel rooms. </p>
  
  <p>The only way that I can think of doing it would be to use:</p>
  
  <p>A = Room Rate</p>
  
  <p>B = Service Charge for room</p>
  
  <p>Imagine that the table has a roomId column which is omited from below. </p>
  
  <pre><code>| DayDate   |EndDate   |  A  |  B
  -----------------------------------------------
  | 2010/07/1 |2010/07/2 | 200 |  40
  | 2010/07/3 |2010/07/4 | 150 |  40
  | 2010/07/5 |2010/07/5 | 150 |  50
  | 2010/07/6 |2010/07/7 | 200 |  50
  | 2010/07/8 |2010/07/9 | 100 |  60
  </code></pre>
  
  <p>etc.. (table taken from another question).</p>
  
  <p>The problem is: I don't want my seasons to be year specific. 
  Seasons for rooms shouldn't change year on year. I don't want my users to have to enter the seasonal information several times. </p>
  
  <p>I am also going to have thousands of rooms, so I don't know a way to make this easily manageable. </p>
  
  <p>I'm using mysql and php. </p>