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
Is referenced by other tables
None.
Related sequences
Related indexes
Related functions
Related views
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