The matrix synapse database is a weird mess. Missing primary keys in the postgres db. Foreign keys missing. Sure we can use joins BUT WHY ARE HALF OF THE THINGS USING FOREIGN KEYS, AND HALF ARE MISSING. Also just inconsistent naming of things,
Linux Geeks doing what Linux Geeks do..