To provide better statistics about the reports, we'd need to store the score of a report and maybe even the reasons.
Table reason:
| reason_id |
name |
creation_date |
| 1 |
String similarity |
timestamp of the first post with that reason |
Table reason_for_post:
| post_id |
reason_id |
score |
| 34 |
1 |
Score, this reason reached (for example StringSimilarity has scores between 0 and 1) |
To provide better statistics about the reports, we'd need to store the score of a report and maybe even the reasons.
Table reason:
Table reason_for_post: