CREATE TABLE `poll_questions` ( `id` int PRIMARY KEY, `body` varchar(255), `created_at` datetime, `updated_at` datetime ); CREATE TABLE `poll_answers` ( `id` int PRIMARY KEY, `body` varchar(255), `votes` varchar(255), `question_id` int, `created_at` datetime, `updated_at` datetime, FOREIGN KEY(`question_id`) REFERENCES `poll_questions` (`id`) ); CREATE TABLE `poll_voting_history` ( `id` int PRIMARY KEY, `question_id` int, `answer_id` int, `user_cookie` varchar(255), `timestamp` time, `ip` varchar(255), `user_agent` varchar(255), FOREIGN KEY(`question_id`) REFERENCES `poll_questions` (`id`), FOREIGN KEY(`answer_id`) REFERENCES `poll_answers` (`id`) );