Questions we'd like to answer as part of this investigation:
- How will we store participants' PII data:
- We know it can only be kept for 90 days then needs to be aggregated (i.e., decoupled from usernames) - how will this work?
- What about for instances where the registration is enabled for events that are greater than 90 days in the future?
- Are we expecting a weird data type that will change the way we approach storing the data?
- Will we limit the time before an event that an organizer may collect PII?
- Option 1: you can collect PII anytime, but it is not visible in UI until 60 days ahead of event start date
- Option 2: registration can only be enabled 60 days ahead of start date, along with PII collection
{F36924338}
More detail/consultation with Legal/Trust & Safety in [[ https://docs.google.com/document/d/1tjkqV2r_a8bkF6XA02xJK5wxfwDd4e4Het7jghigsWA/edit | this doc ]]
**Decisions:**
- We will aggregate the date only after the event is ended for the MPV
- Aggregated date will be shown to organizer only:
- After the event is ended
- If there is at least 10 participants
- The MPV will have the tables below:
```
ce_question_answers
{
ceqa_id: bigint, autoincrement,
ceqa_user_id: integer,
ceqa_event_id: integer,
ceqa_question_id: integer,
ceqa_answer_option: integer | nullable,
ceqa_answer_text: string | nullable
}
ce_question_aggregation
{
ceqag_id: bigint | autoincrement,
ceqag_question_id: integer,
ceqag_event_id: integer,
ceqag_qustion_option_id: integer,
ceqag_answers_amount: integer
}
ce_event_questions
{
ceeq_id: bigint | autoincrement,
ceeq_event_id: integer,
ceeq_question_id: integer
}
```
**To be decided:**
- When should we delete the PII data
- After the event is over?
- After x days counting from when we start collecting the PII data