我应该在db-PHP和Mysql中为产品创建2个表吗？

Question

I've got some question(s) How many tables should i create for my products ?

2???=products & products pics???

if yes then my mysql tables will be like that ? 1.products= p_id, p_name, p_descr, p_pieces, p_categ, p_subcateg(??) &

2.products_pics= pp_id, product_id, thumb, image, type (???)

Well im a little bit confused cause i think its not so necessary to use products_pics into the db anymore .

My product entries will be around 3.000 for the beginning . Can someone tell me what im going to write-do ??? Thank you very much !

Answer 1

You should make 3 tables

• products
• images
• products_images

In table products you have id_prod (primary key), name_prod, and other.

In table images you have id_img (primary key), name_img or img_src.

In table products_images you link images with products, and structure should be like id (primary), id_prod, id_img.

This way you will not have a duplicate content in tables.