Math4Team/RIT/Projects: Difference between revisions

No edit summary
Line 6: Line 6:
(I've already renamed Clinic and Provider to School and Teacher.)
(I've already renamed Clinic and Provider to School and Teacher.)
[[Image:QuestionERDiagram.PNG]]
[[Image:QuestionERDiagram.PNG]]
====Data 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.
Line 16: Line 16:
|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 Field Dictionary====
{{Definition_table
|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====
{{Definition_table
|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
}}
}}