MrChrxs
205
9
General

Database design for a product with lots of fields

Posted 8 months ago by MrChrxs

Hello, I'm looking for assistance on how to layout tables for products that will have lots of fields.

I was thinking, 3 tables... A product table, a specifications table, and an images table.

Product table would have columns names of: id, name, price.. etc Spec table: id, product_id, spec_name(eg. Seats), spec_value(eg. 5) Image table: id, product_id, img_name(eg. banner_1), img_url(eg. /img/myimg.jpg)

There are about 18 Specifications per product. And about 4 image types(banner, product etc), with about 5-10 images for each.

I'm quite new to database design, and don't really know the best way to store a lot of data for products without creating a table with about 30 columns in it.

For a reference of what fields I'll be needing Imgur Img.

Please sign in or create an account to participate in this conversation.

Reply to

Use Markdown with GitHub-flavored code blocks.