title: Booking system for timeslots
body: <p>I need to create an online booking system with PHP and MYSQL, but I keep getting stuck when it comes to creating the database tables structure.</p>
  
  <p>This is the table structure I have so far: (pseudo)</p>
  
  <pre><code>TABLE: 'times'
  
  time_id | int | AI
  time | datetime? (is this the best approch, if so how would the PHP code look for the datetime format?)
  available | boolean
  
  
  TABLE: 'bookings'
  
  booking_id | int | AI
  client_id | int | foreign key
  manager_id | int | foreign key
  time_id | int | foreign key
  </code></pre>
  
  <p>Within the system, I want to be able to:</p>
  
  <ul>
  <li>Create a new date within the admin panel, and then the users of the system can create a booking time slot if it is available.</li>
  </ul>
  
  <p>Times can only be one of the following choices: (this is where i'm confused on if I should store one of the times below as a DATETIME, or Unix Timestamp etc...)</p>
  
  <p>3:05
  3:10
  3:15
  3:20
  3:25
  3:30
  3:35
  3:40
  3:45
  3:50
  3:55
  4:00
  4:05
  4:10
  4:15
  4:20
  4:25
  4:30
  4:35
  4:40
  4:45
  4:50
  4:55
  5:00
  5:05
  5:10
  5:15
  5:20
  5:25
  5:30
  5:35
  5:40
  5:45
  5:50
  5:55
  6:00</p>
  
  <p>Can somebody assist me please?</p>
  
  <p>Thanks in advance.</p>