Database - Create jokes table
Opened this issue · 0 comments
Sv443 commented
Requirements:
- The schema follows the type
Joke
defined insrc/types/jokeapi/jokes.ts
- Categories are always kept updated with
data/categories.json
- Flags are always kept updated with
data/flags.json
-
lang
property should allow for any valid combination of language and country code (bothen
anden-US
are valid but notde-US
) -
id
property is a randomly generated UUID, unique across all jokes from all languages -
dateAccepted
property should keep track of when the submission was accepted into the pool of jokes - Each joke has a reference to the user who submitted it
- Categories are always kept updated with