8,288
edits
Changes
Jump to navigation
Jump to search
Line 6:
Line 6: − + Line 16:
Line 16: + + + + + + + + + + + + + + + + + + + + +
no edit summary
(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.
|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
}}
}}