Database Storage Engine Project M1 Database Design

About the milestone

This milestone includes creating documentation and descriptions of the database schemes explained at Database Storage Engine Project.

Survey, section, question

Below you find the design to store survey, section and question information and metadata.

Todo

• Design flat DB layout
• Design normalized DB layout
• Design section-flat DB layout
• Keep in mind all the Question types supported by Limesurvey1 : Question types

Discussions

Comments and ideas here please:

Metadata requirements for databases

- time question displayed/made available to participant (added by Jason)

this may be an indication of when the page was served to the participants browser (time can be generated by web server/php) or in the case of conditional questions, it may need to indicate the time that the question became visible on the page (in which case it may need to be generated by javascript, with all those inherent problems.. maybe it should indicate how many seconds since the page was loaded, and that can be added to the page-load time?)

- time question answered by participant (added by Jason)

this may be a recording of the time that the data in the question was posted (time could be generated by web serer/php) or the time that the question lost focus (after having gained it) - which would be a javascript issue

Any other metadata requirements?