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