Refactor: Remove unused collaboration and notification tables

Commit notes

This commit removes unused tables related to comments, collections, notifications, and activity feeds. It also removes the corresponding routes and API endpoints.

Co-authored-by: armin.naimi <[email redacted]>