title: database design issue...for booking app
body: <p>I have 4 tables,one is credentials(it holds an id, email and password), the other 2 are for business users  and regular users of the app.
  The business users table holds crID(foreign key)name,lastname,address etc...
  The regular users table holds crID(foreign key),name,lastname etc...</p>
  
  <p>The 4th is the booking table, it holds a bookingID, bookedfrom,bookedfor(the last 2 being foreign keys that point to the credentials table).</p>
  
  <p>If a regular user registers in the site he closes a bookingslot and that is stored in the booking table, his name,last name are stored in the regular users table and his credentials in the credentials table.</p>
  
  <p>The business user table just holds the business user for which a booking is made by the regular users.</p>
  
  <p>Here is a graph:
  <a href="https://skydrive.live.com/redir?resid=BE27434B2AAC8130!262&amp;authkey=!AIZLc8qIX7DAzwg&amp;v=3" rel="nofollow">db image</a></p>
  
  <p>The question is what to do if a regular user does not choose the web to make the booking but makes a call. The business users are given the option to make the booking "manually" also. I am just having difficulty how to integrate that in the db.</p>
  
  <p>As I see it I need to make the following:</p>
  
  <ol>
  <li>Create a booking slot in the bookings table</li>
  <li>Create a new regular user entry in the regular users table and at the same time create another column that would indicate if the user is registered or not.</li>
  <li>create an entry in the credentials table but without password/email since this he will not be a registered user...he just made a booking using the phone.</li>
  </ol>
  
  <p>WHat is your opinion.If you want I will post some show create statements. I think I made my point.</p>