CREATE TABLE "Questionaire" (
	"idQuestionaire" int PRIMARY KEY,
	"nmQuestionaire" varchar(255)
);
CREATE TABLE "Question" (
	"idQuestion" varchar(255),
	"questionaire_id" int CONSTRAINT Questionaire_idQuestionaire 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 CONSTRAINT user_idUser REFERENCES user(idUser),
	"question_id" int CONSTRAINT Question_idQuestion 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 CONSTRAINT user_idUser REFERENCES user(idUser),
	"questionHistory_id" int CONSTRAINT QuestionHistory_idQuestionHistory REFERENCES QuestionHistory(idQuestionHistory),
	"txAnswer" varchar(255)
);