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 CONSTRAINT poll_questions_id REFERENCES poll_questions(id), "created_at" datetime, "updated_at" datetime ); CREATE TABLE "poll_voting_history" ( "id" int PRIMARY KEY, "question_id" int CONSTRAINT poll_questions_id REFERENCES poll_questions(id), "answer_id" int CONSTRAINT poll_answers_id REFERENCES poll_answers(id), "user_cookie" varchar(255), "timestamp" time, "ip" varchar(255), "user_agent" varchar(255) );