Technical

Database

Existing fields

  • imageId – unique ID for the image (changing this is the same as “moving” an image)
  • sortId – unique value to determine the order in which images are displayed
  • title and description – should be combined into Caption? Have a single caption for each photo, which is what is displayed. A lot of the title should also go into the location. Need to find a way to optimize entering caption and location.
  • Year - Year the picture was taken. Currently also used for classification purposes (“type”?)
  • Orientation - Would become only freeform-p and freeform-l
  • Location - Not currently used. Should become the human-readable location description. Need a way to keep standardization for the location.
  • Persons/Tags - Should really be Persons. Possibly have Tags as a separate field
  • Lat/Long
  • Category Used for classification purposes, which needs to be reconsidered
  • Quality - Number of stars given to a photo, also used for “not yet reviewed” status (“default” quality), which should be separate.
  • Rotation - Should be whether the image should be rotated when generating from the original. Should not be used if there is an edited version, since that should be pre-rotated.
  • Copyright - Copyright statement if not the default copyright. Should be in the format <year> by <name>.

New Fields Round 1

  • origWidth and origHeight
  • editedWidth and editedHeight
  • addedDateTime

New Fields Round 2

  • status which can be New, Available, or Restricted.
  • group for the folders (sets). Each set belongs to exactly one group.

New Fields Round 3

These fields need more thinking.

  • license the optional text stating the license for the photo. No default data; will have to think about how to use it.
  • type although I'm not sure how exactly that would be
  • potdNumber and potdDescription. Or, a separate table that links photos-of-the-day and their description, date of publication, to the actual photo.