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 bit(1),
     difficultyid tinyint unsigned not null references difficulty(id));