I am planning a photo album. It is Admin only. No users will be uploading photos. I have 100% control over everything and will be inputting it myself.
Here are the specs:
They go by year and month all the way back to 1999.
They are numbered sequentially within their respective folders. Ex:
The number of photos varies each month.
Some months may be skipped.
Each photo is related to a UserID (users may submit multiple photos each month).
Each photo has an image title and image description.
There is a first name and last name.
There is a location string.
(Maybe a boolean if they want their location hidden.)
Each month has a theme title and theme description.
I was thinking about doing the following: dbo.Person