create table questionAttempt (
     id int unsigned not null auto_increment,
     studentid int unsigned not null references student(id),
     activityid smallint unsigned not null references activity(id),
     questionTypeId smallint unsigned not null references questionType(id),
     isCorrect tinyint unsigned not null,
     difficultyid tinyint unsigned not null references difficulty(id),
     primary key (id));