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? I'm curious if relational DB is the way to go, if the current relationships in the diagram make sense, and whether it will bode well for coding.
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.