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