We will want to record submissions from the Incident-Reporting-System in a database table for a few reasons:
- Prevent duplicate submissions
- Ensure we have our own copy in case of Zendesk failure
- For the future: provide the possibility for tracking the resolution of an incident report, for the reporter as well as for users who are able to view the report
- For the future: be able to use report submission metadata in other tooling
The table should be private (not exposed in replicas) and contain provisions for regular purging after X days (to be discussed with L3SC).
Columns would include:
- Unique ID (some kind of UUID so people can't work out how many submissions have been sent)
- Free text comment from the report
- User ID of the reporter
- User ID of who is being reported
- Relevant revision ID
- Which options were selected in the form from emergency/non-emergency flow