ComMd Table

The ComMd table stores Web discussion comments.

Warning  Modifying the database schema or database structures is not supported. Changes that you make to the database contents may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.

Columns

Column name	Data type	Description
SiteId	uniqueidentifier	GUID for the SharePoint site to which the Web discussion belongs. Found in the Sites table.
DocId	uniqueidentifier	GUID for the document. Found in the Docs table.
Id	int	Primary key for the table.
ParentId	int	Primary key of the parent node for a reply in a threaded discussion. Contains 0 for a top-level node.
CommentId	nvarchar	Not used.
Bookmark	nvarchar	Anchor point within a document for the discussion item, providing a hash that tracks where the comment goes in the document.
Author	nvarchar	Display name of the user who created the comment.
UserId	int	Member ID of the Windows SharePoint Services user.
Subject	nvarchar	Subject line of the comment.
Created	datetime	Date and time that the comment was created.
Status	smallint	Status of the discussion item, which tracks open versus resolved comments.
Comment	ntext	Body or text of the comment.
Size	int	Size of the comment.