title: Laravel - Database design for a Reservation system
body: <p>I want a database schema that some users (host) come and provide their rooms for some certain date and the users can reserve them so here is how it works.</p>
  
  <p>For example I provide my room from now 3/26/2019 until 3/29/2019 and the user comes and by a datepicker selects a date for example from 3/26/2019 until 3/28/2019 and the user reserve the room.</p>
  
  <p>So I want I did I made a table for my property (room):</p>
  
  <pre><code>Schema::create('properties', function (Blueprint $table) {
          $table-&gt;bigIncrements('id');
          $table-&gt;integer('type');
          $table-&gt;text('title');
          $table-&gt;float('base_price');
          $table-&gt;integer('base_availability');
          $table-&gt;integer('max_occupancy');
          $table-&gt;timestamps();
      });
  </code></pre>
  
  <p>and here i think i should make a prperty calendar table and make some relation between them thats all i could guess so any idea how to do that ??</p>