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`) );