Photo Organizer

photo_keywords

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

• photo references photo(identifier)

None.

• photo

None.

• photo_keywords_photo

None.

None.

Version 2.33

Still in use

= Version 2.33 =

-- Split out keywords...
 
CREATE TABLE photo_keywords (
	photo INTEGER NOT NULL REFERENCES photo(identifier),	
	keyword text NOT NULL
);