Is this unpractical?

Hello, i am building a simple e-commerce application with laravel and i have like 3 columns for each image location for products table. Is it unpractical to have seperate columns for image or is it best to have one column and fill it with information?

Tray2

6 years ago

Best Answer

Level 73

I would have a table called products with all the information about the product and another table with product images with four columns. Something like this

products

id
name
product_type_id
description
price

product_images

id
product id
path
description

2 likes

Snapey

6 years ago

Level 122

have a look at spatie media library. this will seriously simplify things

https://docs.spatie.be/laravel-medialibrary/v7/introduction/

2 likes

Please or to participate in this conversation.