Any time I use a piece of software that I know has a database and that I have the ability to access that database directly I like to poke around in that just to see how things work. While I'm not a fan of case sensitive tables/columns in the PeerTube database, things otherwise look reasonable.

Contrast with say, QuickBooks for Mac. The awfulness in their schema design (if you can even call it that) explains a lot of the problems with that program.