Math4Team/RIT/Projects/Question Support API/Data Model: Difference between revisions
No edit summary |
repeat table definitions with each table |
||
| Line 5: | Line 5: | ||
====Table Dictionary==== | ====Table Dictionary==== | ||
{{Definition_table | {{Definition_table | ||
|Questionnaire |A collection of questions that might be used in a Survey, Quiz, Exam, etc. | |Questionnaire |A collection of questions that might be used in a Survey, Quiz, Exam, etc., or when its key appears in the Category field, a group, class, or category of Questionnaires (a recursive entity) | ||
|Question | A problem seeking an answer | |Question | A problem seeking an answer | ||
|Answer | A potential solution to the problem | |Answer | A potential solution to the problem | ||
|AnswerType | The class of answer suitable for the problem or question | |AnswerType | The class of answer suitable for the problem or question | ||
|Survey | An event instance | |Survey | An event in time instance, at which Answers to Questions or problems are gathered | ||
|Response | An event instance | |Response | An event in time instance, at which the Student provides an answer to a question on a Survey or Quiz, etc. | ||
|School | An organization | |School | An organization | ||
|Person | An individual, such as a Teacher, Student, etc. | |Person | An individual, such as a Teacher, Student, etc. | ||
}} | }} | ||
====Questionnaire==== | ====Questionnaire==== | ||
: '''''A collection of questions that might be used in a Survey, Quiz, Exam, etc.''''', | |||
:: or when its key appears in the Category field, | |||
: '''''a group, class, or category of Questionnaires''''' | |||
{{Definition_table | {{Definition_table | ||
|ID | primary key | |ID | primary key | ||
|Title | Short name for questionnaire | |Title | Short name for questionnaire | ||
|Category | | |Category | Category ID, the ID of a Questionnaire group, class, or category of Questionnaire (the parent of a recursive relationship with other Questionnaire records) | ||
|Notes | Description, Image link, rich format data | |Notes | Description, Image link, rich format data | ||
|StartDate | Effective date for this instance of the Questionnaire | |StartDate | Effective date for this instance of the Questionnaire | ||
| Line 25: | Line 28: | ||
====Question==== | ====Question==== | ||
: '''''A problem seeking an answer''''' | |||
{{Definition_table | {{Definition_table | ||
|ID | primary key | |ID | primary key | ||
| Line 37: | Line 41: | ||
}} | }} | ||
====Answer==== | ====Answer==== | ||
: '''''A potential solution to the problem''''' | |||
{{Definition_table | {{Definition_table | ||
|ID | primary key | |ID | primary key | ||
| Line 47: | Line 52: | ||
}} | }} | ||
====AnswerType==== | ====AnswerType==== | ||
: '''''The class of answer suitable for the problem or question''''' | |||
{{Definition_table | {{Definition_table | ||
|ID | primary key | |ID | primary key | ||
| Line 53: | Line 59: | ||
}} | }} | ||
====Survey==== | ====Survey==== | ||
: '''''An event in time instance, at which Answers to Questions or problems are gathered''''' | |||
{{Definition_table | {{Definition_table | ||
|ID | primary key | |ID | primary key | ||
| Line 65: | Line 72: | ||
}} | }} | ||
====Response==== | ====Response==== | ||
: '''''An event in time instance, at which the Student provides an answer to a question on a Survey or Quiz, etc.''''' | |||
{{Definition_table | {{Definition_table | ||
|ID | primary key | |ID | primary key | ||
| Line 79: | Line 87: | ||
====School==== | ====School==== | ||
: '''''An organization''''' | |||
{{Definition_table | {{Definition_table | ||
|ID | primary key | |ID | primary key | ||
| Line 84: | Line 93: | ||
}} | }} | ||
====Person==== | ====Person==== | ||
: '''''An individual, such as a Teacher, Student, etc.''''' | |||
{{Definition_table | {{Definition_table | ||
|ID | primary key | |ID | primary key | ||