User Tools

Site Tools


podoc:photo_keywords_sql_table

Database Table Description of "photo_keywords"

Name

photo_keywords

Description

Purpose

Schema

CREATE TABLE photo_keywords (
	photo INTEGER NOT NULL REFERENCES photo(identifier),	
	keyword text NOT NULL
);

References tables

  • photo references photo(identifier)

Is referenced by tables

None.

None.

None.

None.

History

Used first

Version 2.33

Used last

Still in use

Schema change history

= Version 2.33 =

-- Split out keywords...
 
CREATE TABLE photo_keywords (
	photo INTEGER NOT NULL REFERENCES photo(identifier),	
	keyword text NOT NULL
);
Data change history
podoc/photo_keywords_sql_table.txt · Last modified: 2007/04/20 14:06 by Luud