User Tools

Site Tools


podoc:album_content_sql_table

This is an old revision of the document!


Database Table Description of "album_content"

Name

album_content

Description

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

Purpose

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

Schema

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

References other tables

  • album references album(identifier)
  • photo references photo(identifier)

Is referenced by other tables

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Change history

= 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)
);
podoc/album_content_sql_table.1177068239.txt.gz · Last modified: 2007/04/20 11:23 by Luud