Having all data in a single comments table will be difficult to scale as we add features. The general sense is that breaking out a few more tables would be a Good Idea and we should do it sooner rather than later before we accrue more data and build more features on top of the current model layer.
Proposed structure:
Article
path (default: location.path)
title (default: document.title)
author
belongs_to Site
Thread
name (generated from paragraph content from client-side)
belongs_to Article
Comment
body
created
belongs_to Thread
belongs_to User
Having all data in a single comments table will be difficult to scale as we add features. The general sense is that breaking out a few more tables would be a Good Idea and we should do it sooner rather than later before we accrue more data and build more features on top of the current model layer.
Proposed structure: