Database for E-commerce site

0

Good day first, some doubts arose when I was developing the database of my online sales site (only for context of classes ...). This is the following, I have the products table, then I have the cart, invoice and orders, all I have to save the products, just add another field in them where I save the product code? or how do we have another table linking them by having a many-to-many relationship works the other way? , I'm kind of confused ... whelp

    
asked by anonymous 13.04.2016 / 15:44

1 answer

0

You can make a table with product codes that refer to a specific id and in the cart you pull those ids and put them there, and on the invoice you pull the invoice code only. NOTE: Be careful when pulling so you do not have string conflict!

    
13.04.2016 / 16:17