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