Our notifications table does not contain notifications and that's confusing everyone, especially as we are about to look into the Comment Subscription infrastructure, which will eventually lead to a proper notifications implementation.

We should rename it and make sure that we update all queries in the API plus metabase.