Photo Organizer

album_content

This table keeps track of what photos are in which albums.

Unlike folders, it's possible for a photo to be in more than one album. This table allows for that.

create table album_content (
  identifier            integer not null primary key,
  photo                 integer not null references photo(identifier),
  album                 integer not null references album(identifier)
);

• album_content_id_sequence

• album_content_album_idx
• album_content_id_idx
• album_content_photo_idx

• count_photos_by_album
• count_photos_by_user

None.

Version 2.5

Still in use

= Version 2.5 =

create table album_content (
  identifier            integer not null primary key,
  photo                 integer not null references photo(identifier),
  album                 integer not null references album(identifier)
);