Questionnaires: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{| class="wikitable" !Field Name !!Type !!Description |- !id |int(11) |This object's unique ID value. One per object. |- !name |varchar(64) |name of the questionnaire ...") |
(Added QuizQuestionnaire as a subclass of Questionnaire) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 40: | Line 40: | ||
!type | !type | ||
|varchar(255) | |varchar(255) | ||
|Subclassing for the questionnaire. Possible types are ReviewQuestionnaire, MetareviewQuestionnaire, AuthorFeedbackQuestionnaire, SurveyQuestionnaire, CourseEvaluationQuestionnaire, TeammateReviewQuestionnaire, GlobalSurveyQuestionnaire | |Subclassing for the questionnaire. Possible types are ReviewQuestionnaire, MetareviewQuestionnaire, AuthorFeedbackQuestionnaire, QuizQuestionniare, SurveyQuestionnaire, CourseEvaluationQuestionnaire, TeammateReviewQuestionnaire, GlobalSurveyQuestionnaire | ||
|- | |- | ||
!display_type | !display_type | ||
|varchar(255) | |varchar(255) | ||
|Character representation of type used in tree display. Possible values are Review, Metareview, AuthorFeedback, Survey, CourseEvaluation, TeammateReview GlobalSurvey | |Character representation of type used in tree display. Possible values are Review, Metareview, AuthorFeedback, Survey, CourseEvaluation, TeammateReview GlobalSurvey | ||
|- | |||
!instruction_loc | |||
|TEXT | |||
| | |||
|} | |} | ||
Back to [http://wikis.lib.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | Back to [http://wikis.lib.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | ||
Latest revision as of 20:09, 29 October 2019
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | This object's unique ID value. One per object. |
| name | varchar(64) | name of the questionnaire |
| instructor_id | int(11) | id of instructor who created the questionnaire |
| private | tinyint(1) | whether questionnaire is visible to other instructors |
| min_question_score | int(11) | the minimum score that the reviewer can give for a question in this questionnaire |
| max_question_score | int(11) | the maximum score that the reviewer can give for a question in this questionnaire |
| created_at | datetime | the date and time at which the questionnaire was created at |
| updated_at | datetime | the date and time at which the questionnaire was last updated |
| default_num_choices | int(11) | default number of scoring increments |
| type | varchar(255) | Subclassing for the questionnaire. Possible types are ReviewQuestionnaire, MetareviewQuestionnaire, AuthorFeedbackQuestionnaire, QuizQuestionniare, SurveyQuestionnaire, CourseEvaluationQuestionnaire, TeammateReviewQuestionnaire, GlobalSurveyQuestionnaire |
| display_type | varchar(255) | Character representation of type used in tree display. Possible values are Review, Metareview, AuthorFeedback, Survey, CourseEvaluation, TeammateReview GlobalSurvey |
| instruction_loc | TEXT |
Back to Database Tables Main page.