Content Comment

Member comment on community content

Represents member comments on generated content.

Fields

Core Fields

Field	Type	Required	Description
id	UUID	Auto	Primary key
contentId	UUID	Yes	FK to GeneratedContent
memberId	UUID	Yes	FK to Member
body	text	Yes	Comment text (markdown)
parentCommentId	UUID	No	FK for replies

Engagement

Field	Type	Required	Description
reactionCount	integer	Auto	Reactions on comment
replyCount	integer	Auto	Reply count

Moderation

Field	Type	Required	Description
status	enum	Yes	active, hidden, deleted
hiddenBy	UUID	No	Admin who hid
hiddenReason	string	No	Reason for hiding

System Fields

Field	Type	Required	Description
createdAt	datetime	Auto	Creation timestamp
updatedAt	datetime	Auto	Last edit
editedAt	datetime	No	If edited by member

Relationships

Relation	Type	Target Entity
content	ManyToOne	GeneratedContent
member	ManyToOne	Member
parent	ManyToOne	ContentComment (self)
replies	OneToMany	ContentComment (self)
reactions	OneToMany	CommentReaction

Business Rules

• Members can edit own comments within 15 minutes
• Deleted comments show "[deleted]" but preserve thread
• Replies notify parent comment author
• Hidden comments visible to admins only

Features

Content Comment

Acceptance Criteria

Frontend

• Admin/client UI can view and manage Content Comment records where applicable.

Backend / API

• CRUD operations exist for Content Comment (create, read, update, delete/archive).

Permissions

• Access is restricted to appropriate roles (tenant-scoped).

Business Rules

• Fields and relationships documented on this page are enforced for Content Comment.

Error Handling

• Invalid payloads return field-level validation errors.