Multiple sql database tables for one form

Development
1

I have a form with around 100 questions. When its filled from an Android
ODK Collect and sent to the Aggregate server, the data is partitioned and
stored to 7 different tables in MySQL server.
How can I just come up with one table for all the fields in the form
instead of the multiple tables?

Thanks in advance.
Regards,
Phanuel Ayuka.

2

Publishing to Fusion Tables can give you a wide flat view of your data.
Or you might be able to manually CREATE VIEW on top of the data tables (see
MySQL documentation).

We store select-multiple questions in different tables so that each
selected choice is a separate row in that linked table. This can support
filters for those answers.

We store audio, video and image data in separate tables because these are
large.

We store repeat groups in separate tables so that each repeat group is a
separate row in that linked table.

And, finally, MySQL has a 65536-byte limit to how big its rows can be. This
causes larger forms (> 200 questions) to be split across 2 or more linked
tables.

ยทยทยท On Thu, Sep 29, 2016 at 3:38 AM, Ayuka Phanuel wrote:

I have a form with around 100 questions. When its filled from an Android
ODK Collect and sent to the Aggregate server, the data is partitioned and
stored to 7 different tables in MySQL server.
How can I just come up with one table for all the fields in the form
instead of the multiple tables?

Thanks in advance.
Regards,
Phanuel Ayuka.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com