Untitled

CREATE TABLE Users(
    UserID int NOT NULL PRIMARY KEY,
    FirstName varchar(255) NOT NULL,
    LastName varchar(255) NOT NULL,
    Email varchar(255) NOT NULL,
    Score int
);

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,
    OpenQuestionAnswear varchar(8000) NOT NULL,
	FOREIGN KEY (QuestionID) REFERENCES Questions(QuestionID);
)

CREATE TABLE ClosedQuestionAnswears(
	ClosedQuestionAnswearID INT NOT NULL PRIMARY KEY,
	ClosedQuestionAnswear varchar(1024) NOT NULL,
	Correctness BOOLEAN NOT NULL,
    FOREIGN KEY(QuestionID) REFERENCES Questions(QuestionID);
)

CREATE TABLE CorrectOpenQuestionAnswears(
	CorrectOpenQuestionAnswearID int NOT NULL PRIMARY KEY,
	CorrectOpenQuestionAnswear varchar(8000) NOT NULL,
	FOREIGN KEY(QuestionID) REFERENCES Questions(QuestionID)
)

CREATE TABLE UserClosedAnswears(
    UserClosedAnswearID int NOT NULL PRIMARY KEY,
    UserClosedAnswear int,
    FOREIGN KEY (UserID) REFERENCES User(UserID),
    FOREIGN KEY (QuestionID) REFERENCES Questions(QuestionID)
)

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