🧹 Document database schema in database.py

[hasan-sh]

Description
Currently, we there's some comments describing certain fields, but not all. Also, how do we know which fields a table hold if a some PR adds a field that's needed?

Idea
We should have an organized schema where all fields are described and can be read in their respective table. So, create a catalog for every table of our database. For instance, in one of the following tools:

• https://www.dbvis.com
• https://dbdiagram.io/home
• or simply do it with markdown!

[Felienne]

I think you mean "document" instead of refactor? I think this is a excellent idea! If we go down this road, we should also add a new point to the PR checklist, asking if there are DB changes, and checking if the docs are updated too!

[Felienne]

Not a small issue @hasan-sh but something you can pick up in between other things (one table at a time maybe?)

[rix0rrr]

We can add the types to the Table, which can do things like automatically generate a Markdown report and validate records as they are being inserted into the table.

See a previous attempt for this here: #4862