Fields for storing and retrieving file (image) information from database to display on web
<p>When uploading images through a web application</p>

<p><strong>For example:</strong><br>
Photo Galleries and Photos</p>

<p>I have a Photo table that contains the following properties:</p>

<p>Id<br>
ImageName - image1.jpg<br>
ImagePath - uploads/photogallery/photogallery1/image1.jpg<br>
Description - this will most likely be the title and alt text  </p>

<p>My goal is to be able to save the proper information that will make retrieval of these photos very easy. Do I even need those fields? I feel like I simply just need the ImageName and then can figure the path out by looking up the gallery and getting the gallery name.</p>

<p>Any suggestions?</p>