Proposition de la base de donnée d'une application de quiz

Nombre de table : 8

Identification des tables :

users

• id primary key autoincrement
• nom varchar
• prenom varchar
• email varchar
• password varchar

niveau

• id primary key autoincrement
• nom varchar
• recompense varchar

theme

• id primary key autoincrement
• nom varchar

question

• id primary key autoincrement
• id_theme foreign key references theme(id)
• id_solution foreign key references solution(id)
• description varchar

solution

• id primary key autoincrement
• nom varchar
• id_question foreign key references question(id)
• valeur varchar

quiz_question

• id primary key autoincrement
• id_quiz foreign key references quiz(id)
• id_question foreign key references question(id)

quiz_valide

• id primary key autoincrement
• id_quiz foreign key references quiz(id)
• id_user foreign key references user(id)
• date_validation date

quiz

• id primary key autoincrement
• id_quiz foreign key references quiz(id)
• id_question foreign key references question(id)
• id_user foreign key references user(id)