title: How do I store guest checkouts?
body: <p>Ok, so my site is just like "Post Your Order" rather than the usual online payment method since I will be shipping the item first then the cash which is the Cash On Delivery offered by Shipping services here.</p>
  
  <p>I have a users table which have
  user_id, email, password, first and last name, etc.</p>
  
  <p>an user_order table which have
  order_id, user_id_fk, order_status, order_placed, address_id_fk</p>
  
  <p>an order_items table which have
  order_item_id, order_id_fk, product_id, quantity, size_id_fk</p>
  
  <p>address table
  address_id, user_id_fk, street, city, province, etc</p>
  
  <p>So, if the user is registered it's easy to do this since i would just link their user_id to the user_order table and the address from their address_book</p>
  
  <p>My problem is, how do i do that with guest checkouts? I'm trying to avoid them to be forced to register even though it's easy.</p>
  
  <p>What on my mind right now is to just insert them to the users table too, but with their password as NULL and just make a guest group and put them to that group.</p>
  
  <p>But that may cause a problem, email in my users table must be unique, guest checkouts may happen more than once from the same email soo... now what?</p>
  
  <p>should i just add column to the orders table? another, name, email, address? so it's not tied to the users? that's possible but there's a feature i would like the registered user to have... to track their Order History.</p>
  
  <p>Help please... Thanks :D ;)</p>