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 | | |
|