Math4Team/RIT/Projects
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Question Support API
http://git.sugarlabs.org/projects/question-support-api
Data Model
A possible data model I built for a corporate medical department's medical records: (I've already renamed Clinic and Provider to School and Teacher.)
Table Dictionary
Questionnaire | A collection of questions that might be used in a Survey, Quiz, Exam, etc. | |
Question | A problem seeking an answer | |
Answer | A potential solution to the problem | |
AnswerType | The class of answer suitable for the problem or question | |
Survey | An event instance of collecting Answers to Questions or problems | |
Response | An event instance of the Student providing an answer to a question on a Survey or Quiz, etc | |
School | An organization | |
Person | An individual, such as a Teacher, Student, etc. |
Questionnaire Field Dictionary
ID | primary key | |
Questionnaire | Title of questionnaire | |
Category | Classifier ID | |
Notes | Description, Image link, rich format data | |
StartDate | Effective date for this instance | |
EndDate | Expiry date of this instance |
Question Field Dictionary
ID | primary key | |
Questionnaire | ID of parent questionnaire | |
Sequence | number to order question among questions on questionnaire | |
Question | text problem statement | |
AnswerType | ID of the suitable answer type | |
Jump | conditional number to redirect survey question sequence | |
Notes | Description, images, rich format data | |
StartDate | Effective date of this question instance | |
EndDate | Expiry date of this instance |
Answer Field Dictionary
ID | primary key | |
Question_ID | ID of parent question | |
Sequence | number to order answer among answer choices for question | |
Answer | text of solution or answer | |
Notes | Description, images, rich format data | |
StartDate | Effective date of this answer instance | |
EndDate | Expiry date of this instance |
AnswerType Field Dictionary
ID | primary key | |
AnswerType | text for the class of answer. Example, text, numeric, multiple choice, tabular, yes/no, etc. | |
Category | ID for class of answer type |
Survey Field Dictionary
ID | primary key | |
BaseID | ID of parent Survey. Used to identify families of Surveys, such as version | |
School | ID of the School or organization sponsoring this Survey instance | |
Teacher | ID of Person extending this instance of the survey or quiz | |
Student | ID of the Person taking this instance of the survey or quiz | |
Notes | Description, images, rich format data for this instance of the survey or quiz | |
DateTime | DateTime that this Survey instance was taken | |
ReviewDate | Date that this Survey instance was reviewed by the Teacher | |
ChangeDate | Date that this instance of the Survey was changed (reasons are provided in the Response record). |
Response Field Dictionary
ID | primary key | |
Answer_ID | ID of selected answer (when one of a choice) | |
Question_ID | ID of the Question instance for this Response instance | |
Survey_ID | ID of the parent Survey or Quiz instance for this Response | |
Response | text of Response | |
ResponseValue | numerical Response | |
Notes | Description, images, rich format data for this Response | |
DateTime | DateTime for this Response | |
ChangeDate | Date that this instance of the Survey was changed | |
ChangePerson | ID of Person who changed this Response instance | |
ChangeReason | Reason this Response instance was changed. |
School Field Dictionary
ID | primary key | |
School | School or organizational name |
Person Field Dictionary
ID | primary key | |
Last Name | Family name for Person | |
First Name | Primary name for Person |