title: Database Design for Rental Listings
body: <p>I'm designing a <strong>simple database for a rental listings website</strong>,<br>
  sort of like classified ads but only for home/room rentals.  <br/><br/>This is what I've come up with thus far:</p>
  
  <p><img src="https://i.stack.imgur.com/10Efl.png" alt="enter image description here"></p>
  
  <p><strong>Question 1</strong><br>
  For the "post" table, I actually wanted more information. For example, there would be a 'facilities' section where the users can select whether there's 'parking' available, do I need a separate table? Or just use 0 for no and 1 for yes?</p>
  
  <p><strong>Question 2</strong><br>
  Here's what I did with the "category" table (sorry I don't know how to pretty print yet)<br/>
  Category_ID 1 is Rent<br/>
  Category_ID 2 is buildingType<br/></p>
  
  <p>For "categoryProperty" table<br/>
  Category_ID 1 categoryPropertyID 1 House<br/>
  Category_ID 1 categoryPropertyID 2 Room<br/>
  Category_ID 2 categoryPropertyID 3 Apartment<br/>
  Category_ID 2 categoryPropertyID 4 Condominium<br/>
  Category_ID 2 categoryPropertyID 5 Detached<br/></p>
  
  <p><strong>Does the above make sense?</strong></p>
  
  <p><strong>Question 3</strong> <br/>
  Users can post whether they are logged in or not.<br/> Just that logged in users/members have the advantage of tracking their ads/adjusting the availability.<br/> 
  How do I record the ads that a member has posted? Like their history. <br/>
  Should I create a "postHistory" table and set the 'postHistory_ID' as FK to "member" table?
  <br/><br/>
  Thanks a lot in advance, I appreciate your help, especially just pointing me to the right direction. </p>