Probably will need to live in the public schema, but shouldn't be openly queryable
Logged in users will have the ability to create reports for any post
Q: Should users have the authorization to query/update/delete any reports they created?
New backend role for moderators (mods)
Mods can view any report
Mod status should be queryable, but need to make sure users can't make themselves moderators
Q: Come up with a way to allow an undoable "remove post" action for mods that only mods have the permissions to perform and prevents the post from being fetchable through the API. Possibly create a table for removed posts that posts can be copied to and restored from.
Since the gripe posting will be anonymous, we want to be able to prevent and monitor abuse of the system as well as abuse in the gripes themselves.
Will need further investigation, but a mod mail bot will probably be one part of the process.
Tasks list:
n
reports