Add flag table to backend via schemas

[andrewtavis]

Terms

• [X] I have searched open and closed feature requests
• [X] I agree to follow activist's Code of Conduct

Description

This issue would add in the flag table to the backend within the backend/content directory. The schemas for the table can be found in the designs on Figma. Another thing that would need to happen is that the total_flags columns should be removed from the tables in which they're found as we need to have unique identifiers for who is flagging what to avoid repeats.

Contribution

We first need to discuss whether the schema is correct, and then happy to implement or support implementation!

[andrewtavis]

@to-sta, general idea here was that we follow the support table so there's a shared logic. Only difference is that users are the only entities who can flag, so we don't need to do any entity matching for "flagger".

[andrewtavis]

Assigning this to myself, @to-sta. Let me make a PR for this and you can review :)

[to-sta]

Yeah, sure thing. Happy to see you joining the backend 🥳