setup products table mysql database
I need a hand with my app, i have users who register and can be assigned to multiple clients however i have multiple products which have different criteria so would i create a table for each product then create a product table also which relates to the individual products?
so say i have:
would i then have a product table which relates to these products individually and the clients table relating to individual products tables or just the product table which would say have:
hope someone can help me deisgn this as i have not got a great understanding of designing the db and creating relationships and when and where to sue these.