CREATE TABLE "album" ( "id" int, "title" varchar(255), "date_created" varchar(255) CONSTRAINT date_created REFERENCES date(created) ); CREATE TABLE "photo" ( "id" varchar(255), "album_id" varchar(255) CONSTRAINT album_id REFERENCES album(id), "title" varchar(255), "order" int );