CREATE TABLE `Questionaire` (
	`idQuestionaire` int PRIMARY KEY,
	`nmQuestionaire` varchar(255)
);
CREATE TABLE `Question` (
	`idQuestion` varchar(255),
	`questionaire_id` int,
	`txQuestionPreamble` varchar(255),
	`txQuestion` varchar(255),
	`txQuestionPostamble` varchar(255),
	`typeAswerField` varchar(255),
	`txAnswerDefault` varchar(255),
	`idOrderQuestion` varchar(255),
	`txAnswerRadioValues` varchar(255),
	FOREIGN KEY(`questionaire_id`) REFERENCES `Questionaire` (`idQuestionaire`)
);
CREATE TABLE `QuestionHistory` (
	`idQuestionHistory` int PRIMARY KEY,
	`dtEntryHistory` datetime,
	`user_id` int,
	`question_id` int,
	`txQuestionPremableNew` varchar(255),
	`txQuestionNew` varchar(255),
	`txQuestionPostambleNew` varchar(255),
	`typeAnswerFieldNew` varchar(255),
	`txAnswerDefaultNew` varchar(255),
	`idOrderQuestionNew` varchar(255),
	FOREIGN KEY(`user_id`) REFERENCES `user` (`idUser`),
	FOREIGN KEY(`question_id`) REFERENCES `Question` (`idQuestion`)
);
CREATE TABLE `user` (
	`idUser` int PRIMARY KEY
);
CREATE TABLE `Answer` (
	`idAnswer` int PRIMARY KEY,
	`user_id` int,
	`questionHistory_id` int,
	`txAnswer` varchar(255),
	FOREIGN KEY(`user_id`) REFERENCES `user` (`idUser`),
	FOREIGN KEY(`questionHistory_id`) REFERENCES `QuestionHistory` (`idQuestionHistory`)
);