Setting up the Database

quizschema.sql

CREATE TABLE user (
  id INTEGER PRIMARY KEY,
  first_name TEXT,
  email TEXT
);

CREATE TABLE quiz (
  id INTEGER PRIMARY KEY,
  user_id INTEGER,
  name TEXT
);

CREATE TABLE question (
  id INTEGER PRIMARY KEY,
  content TEXT
);

CREATE TABLE quiz_question (
  id INTEGER PRIMARY KEY,
  quiz_id INTEGER,
  question_id INTEGER
);

CREATE TABLE choice (
  id INTEGER PRIMARY KEY,
  content TEXT,
  question_id INTEGER,
  correct BOOLEAN
);

CREATE TABLE answer (
  id INTEGER PRIMARY KEY,
  user_id INTEGER,
  question_id INTEGER,
  choice_id INTEGER
);