I'm modeling a database, however I'm in doubt as to how I'll handle this part of saving the image in Amazon S3 and referencing it easily in the database.
I want to save the URL of the image (hosted on Amazon S3) in a field called "image_url" from bd.
One of my doubts is:
How do I generate multiple versions of image dimensions (sm, md, lg, original), and are able to save their url in the database? Should I create a column for each version of the image? Ex: image_url_sm, image_url_md, image_url_lg, image_url_original. In my opinion this looks like a bad database practice.
Here is my current table: