I want to create an online store database. I want to give users the ability to 'add to cart' and 'check out' without login.
My idea is that if the user logs in, then I can save the information in tables
ex(bag, order), but if the user wants to check out as guest than I can create a
guest_unique_id and set up
bag that way. Guest bag will be mannually deleted after 10 days.
The only issue I see is that sometimes
account_id will be empty. I guess I can check to see if
NULL then user has an account, if not then it is a guest.
What you guys think about this structure, is there a better way to do this?