Database - Create submissions table - Githubissues

Sv443-Network / JokeAPI

REST API that serves uniformly and well formatted jokes in JSON, XML, YAML or plain text format that also offers a great variety of filtering methods

https://v2.jokeapi.dev

MIT License

253 stars 47 forks source link

Database - Create submissions table #494

Open Sv443 opened 10 months ago

Sv443 commented 10 months ago

Requirements:

[ ] Format should be the smae as that of the jokes table
[ ] Additionally, these properties should be present:
- [ ] dateSubmitted - when the author created this submission
- [ ] upvotesAmount - amount of upvotes received from other users
- [ ] downvotesAmount - amount of downvotes received from other users
- [ ] reportsAmount - amount of users that reported this joke as spam, malformatted or overly offensive

Nice to have:

[ ] Reference to new table "edit proposals" which are submitted by other users
- [ ] These also have the dateSubmitted, upvotesAmount, downvotesAmount and reportsAmount props
- [ ] A moderator can select an edit proposal to be accepted instead of the original submission