ODK backend database - _CORE table split into 2 tables


I design dashboards on top of ODK by connecting it to the ODK database directly. For a recent form, I noticed that ODK has created two XXX_CORE tables (XXX_CORE and XXX_CORE2). I am wondering how/why this has happened. Is it because the form is hitting some variable threshold? I just added few variables and this has happened, previously it was just one table XXX_CORE.

Any help would be appreciated.


See https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure for an explanation of how this works.

1 Like