Math4Team/RIT/Projects

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, the ID of a Questionnaire class or category of Questionnaire
Notes		Description, Image link, rich format data
StartDate		Effective date for this instance of the Questionnaire
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
ChangeDate		DateTime that this instance of the Survey was changed, i.e., initial response, update by Student, override by Teacher, etc.
ChangePerson		ID of Person who changed this Response instance, i.e., Student, Teacher
ChangeReason		text reason this Response instance was changed, i.e., initial response, update by Student, override reason

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