Report database

[aninek]

Purpose:
We need a repository for cleaning, disaggregating, and analyzing reports.

Conversation:
The following variables should be captured from volunteer reports:

UID	Phone number	Time stamp DD:MM:YYYY HH:MM:SS	Original report	Event	Male <5	Male >5	Female <5	Female >5	Alert UID
1	4741547913	27.09.2017 17:13:04	1#3#8#2#12	1	3	8	2	12
2	4741547913	28.09.2017 15:27:54	3#2#2	3	0	0	0	1	1
3	4741547913	29.09.2017 5:12:33	Hello world

How to replicate UID 2 - #45
Alert UID is attributed to Alert UID variable in all related reports
Constraints:

• Use standard date time format, time based on GMT.
• All text messages are retained in "Original Report" variable, regardless of whether they are accurately reports or trigger alerts/error messages.

Related ticket: #46 #44 #37
Example dataset:

JSON: https://drive.google.com/open?id=0B3JnixYdZxDEaXgwY0o3UUVvNVk

Spreadsheet: https://docs.google.com/spreadsheets/d/1voDFeLxiKjbNpKXtUE4se0-lNqMTZVdA6bv0lSDIwXg/edit#gid=335422100

Confirmation:
Text three examples to SMS shortcode and observe in database.

[karolikl]

Persistance will happen in several steps, so please consider the above description as guidance.

The following will be persisted, but not necessarily in the same document:
The raw SMS
The case report created
Anonymous case reports
Dead letters (not able to parse)