I created a DB schema for a project relating to collecting comments for web pages, is relational the way to go and how are my relationships?
A couple of cmments:

CommentReplies seems to be implementing many-to-many.  I would expect it to be one-to-many -- as in, each comment has one 'parent'.  One-to-many does not need an extra table; you simply have parent_id as a column in Comments.

Consider using ENUM datatype instead of adding a XxTypes table.