CREATE TABLE Question
(
    questiontext TEXT,
    questionid   INTEGER
        constraint Question_pk
            primary key
);
Question
CREATE TABLE Survey
(
    SurveyID    INTEGER
        constraint Survey_pk
            primary key,
    Description TEXT
);
Survey
CREATE TABLE "Answer"
(
    AnswerText TEXT,
    SurveyID   INTEGER
        constraint Answer_Survey_SurveyID_fk
            references Survey,
    UserID     INTEGER,
    QuestionID INTEGER
        constraint Answer_Question_questionid_fk
            references Question,
    constraint Answer_pk
        primary key (UserID, QuestionID)
);
Answer
original_column_name,column_name,column_description,data_format,value_description
questiontext,question text,The detailed text of the question.,text,
questionid,question id,The unique id of the question.,integer,Each questiontext can only have one unique questionid
Question
original_column_name,column_name,column_description,data_format,value_description
SurveyID,Survey ID,The unique id of each survey ,integer,"commonsense evidence: 
Each SurveyID is unique. And SurveyID is simply survey year ie 2014, 2016, 2017, 2018, 2019."
Description,,The Description of the specific survey.,text,
Survey
original_column_name,column_name,column_description,data_format,value_description
AnswerText,Answer Text,The specific and detailed answer text of each question.,text,The content is highly depend on the question.
SurveyID,Survey ID,The id of each survey.,integer,"The SurveyID is simply survey year i.e., 2014, 2016, 2017, 2018, 2019."
UserID,User ID,The id of different user.,integer,"commonsense evidence: 
Some questions can contain multiple answers, thus the same user can appear more than once for that QuestionID."
QuestionID,Question ID,The id of different questions.,integer,"commonsense evidence: 
Some questions can contain multiple answers, thus the same user can appear more than once for that QuestionID."
Answer