tblAnimals
| Column | Type | Null | Default | Links to |
Comments |
|---|
| pmkAnimalName (Primary) | varchar(20) | No | | |
|
| fldLevel | int(11) | No | | |
|
tblQuestions
| Column | Type | Null | Default | Links to |
Comments |
|---|
| pmkQuestionId (Primary) | int(11) | No | | |
|
| fnkRightAnswerAnimalId | varchar(20) | No | | |
|
tblQuestionsAnimals
| Column | Type | Null | Default | Links to |
Comments |
|---|
| fnkQuestionId (Primary) | int(11) | No | | |
|
| fnkAnimalName (Primary) | varchar(20) | No | | |
|
tblQuizzes
| Column | Type | Null | Default | Links to |
Comments |
|---|
| pmkQuizId (Primary) | int(11) | No | | |
|
| fldDateCreated | timestamp | Yes | CURRENT_TIMESTAMP | |
|
| fldQuizName | varchar(20) | Yes | NULL | |
|
tblQuizzesQuestions
| Column | Type | Null | Default | Links to |
Comments |
|---|
| fnkQuizId (Primary) | int(11) | No | | |
|
| fnkQuestionId (Primary) | int(11) | No | | |
|
| fnkUserChoseAnimalName | varchar(20) | No | | |
|
tblUsers
| Column | Type | Null | Default | Links to |
Comments |
|---|
| pmkUserId (Primary) | int(11) | No | | |
|
| fldFirstName | varchar(15) | Yes | NULL | |
|
| fldLastName | varchar(15) | Yes | NULL | |
|
| fnkFavoriteAnimalName | varchar(20) | No | tiger | |
|
| fldEmail | varchar(40) | No | | |
|
| fldDateJoined | timestamp | No | CURRENT_TIMESTAMP | |
|
| fldLevel | int(1) | No | 1 | |
|
| fldConfirmed | int(1) | No | 0 | |
|
| fldApproved | int(1) | No | 0 | |
|
tblUsersQuizzes
| Column | Type | Null | Default | Links to |
Comments |
|---|
| fnkUserId (Primary) | int(11) | No | | |
|
| fnkQuizId (Primary) | int(11) | No | | |
|
| fldNumberCorrect | int(3) | No | 0 | |
|
| fldTotalQuestions | int(3) | No | | |
|