Untitled

CREATE TABLE Users
(
    UserID        INT          NOT NULL PRIMARY KEY,
    UserFirstName varchar(255) NOT NULL,
    UserLastName  varchar(255) NOT NULL,
    UserEmail     varchar(255) NOT NULL,
);

CREATE TABLE Questions
(
    QuestionID   INT           NOT NULL PRIMARY KEY,
    QuestionType varchar(255)  NOT NULL,
    Question     varchar(4096) NOT NULL
);

CREATE TABLE OpenQuestionsHints
(
    OpenQuestionHintID INT           NOT NULL PRIMARY KEY,
    Hint               varchar(8000) NOT NULL,
    FOREIGN KEY (QuestionID) REFERENCES Questions (QuestionID)
);

CREATE TABLE ClosedQuestionAnswears
(
    ClosedQuestionAnswearID INT           NOT NULL PRIMARY KEY,
    Answear                 varchar(1024) NOT NULL,
    FOREIGN KEY (QuestionID) REFERENCES Questions (QuestionID)
)

CREATE TABLE CorrectOpenAnswears
(
    CorrectOpenAnswearID INT           NOT NULL PRIMARY KEY,
    Answear              varchar(8000) NOT NULL,
    FOREIGN KEY (QuestionID) REFERENCES Questions (QuestionID),
)

CREATE TABLE CorrectClosedAnswears
(
    FOREIGN KEY (ClosedQuestionAnswearID) REFERENCES ClosedQuestionAnswears (ClosedQuestionAnswearID),
    FOREIGN KEY (QuestionID) REFERENCES Questions (QuestionID)
)


CREATE TABLE UserClosedAnswears
(
    UserClosedAnswearID INT NOT NULL PRIMARY KEY,
    FOREIGN KEY (UserID) REFERENCES User (UserID),
    FOREIGN KEY (ClosedQuestionAnswearID) REFERENCES ClosedQuestionAnswears (ClosedQuestionAnswearID),
    FOREIGN KEY (QuestionID) REFERENCES Questions (QuestionID)
)

CREATE TABLE UserOpenAnswears
(
    UserOpenAnswearID INT NOT NULL PRIMARY KEY,
    Answear           varchar(8000),
    FOREIGN KEY (UserID) REFERENCES User (UserID),
    FOREIGN KEY (QuestionID) REFERENCES Questions (QuestionID)
)