JokeAPI icon indicating copy to clipboard operation
JokeAPI copied to clipboard
verified publisher icon Sv443-Network

[Epic] Database - all tables and connector functions

Open Sv443 opened this issue 2 years ago • 3 comments

A collection of all database-related stuff that is needed for the initial release.

  • [ ] Set up Postgres database (#521)
  • [ ] Add table schemas and connector functions
    • [ ] Users (#492)
    • [ ] Jokes (#493)
    • [ ] Submissions (#494)
    • [ ] Reports (#518)

Sv443 avatar Jan 11 '24 20:01 Sv443

Might I suggest one table for jokes and submissions, and you can have a column stating whether or not a joke is "verified".

canarado avatar Jan 11 '24 20:01 canarado

I think keeping them separate is a better idea since there could be edits by the original author, moderators and admins and there would be extra data associated with that. It also keeps them logically separate.

Sv443 avatar Jan 11 '24 20:01 Sv443

Example being that submissions are being voted on by users and could have edits proposed. This has nothing to do with jokes that have been fully accepted into the joke pool already.

Sv443 avatar Jan 11 '24 21:01 Sv443