CREATE TABLE Users (
    id INT UNSIGNED NOT NULL,
    fname VARCHAR(225) NOT NULL,
    lname VARCHAR(225) NOT NULL,
    email VARCHAR(225) NOT NULL,
    username VARCHAR(225) NOT NULL,
    password VARCHAR(225) NOT NULL
);

CREATE TABLE Question (
    question_id auto integer,
    question varchar(225),
    is_active enum(0,1),
);

CREATE TABLE Question_choices (
    choice_id auto integer,
    question_id integer,
    is_right_choice enum(0,1),
    choice varchar(225)
);

CREATE TABLE User_question_answer (
    user_id varchar(20),
    quest1 varchar(30),
    quest2 varchar(30),
    quest3 varchar(30),
    quest4 varchar(30),
    quest5 varchar(30),
    quest6 varchar(30),
    quest7 varchar(30),
    quest8 varchar(30),
    quest9 varchar(30),
    quest10 varchar(30),
    choice_id integer,
    is_right enum(0,1),
    submit_at datetime,
    PRIMARY KEY (firstname, lastname, submit_at)
);


