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) FOREIGN KEY("album_id") REFERENCES "album" ("id"), "title" varchar(255), "order" int );