I am rather new to databases and I have made plans to make a small database to manage my photos.

I will have a table for picture which contains the base information for the photo like date taken, date imported.

Now a digital photo can have several formats. For me they will be jpg and nef (a raw photo format with a bit more information). In the future I might make some image setting tables to those files which will be different for the different formats.

There will only ever be 1 raw file for each picture (there might be zero). There might be zero or more jpg files.

So should my database look like:

picture -> file_jpg
-> file_nef

or should it look like

picture -> file_jpg_nef

cheers,

David