Discussions (ComMd) Table
There is only one Discussions table per database, which holds all the discussion items for all discussion types.
The following table indicates the fields and data types that are used in the Discussions table.
Column Name | Data Type | Description |
---|---|---|
ID | Integer | Primary key for the table. |
UrlID | Integer | The ID of the document URL for the page being commented and to which this discussion item refers (a lookup to the DocMd table). |
ParentID | Integer | The parent discussion item in the threading of the comments, tracking who replied to whom. |
CommentID | Text | Not used. |
Bookmark | Text | The anchor point within a document for the discussion item, providing a hash that tracks where the comment goes in the document. |
Author | Text | The display name of the user who created the comment. |
LoginName | Text | The domain name of the user, in other words, the Windows NT account of the person who created the comment (for example, REDMOND\Somebody). |
Subject | Text | The subject line of the comment. |
Created | DateTime | The date and time that the comment was created. |
Status | Choice | The status of the discussion item, which tracks open versus resolved comments. |
Comment | Note | The body or text of the comment. |
There are two types of database discussions:
- Document Discussions: an extension of the Microsoft Office 2000 functionality. Users can make threaded comments on any internal or external URL, including list URLs. Document discussions store their data in the Discussions system list (ComMd).
- Discussion Forums: stand-alone discussion forums. Discussion forums each have their own table, and they can contain any arbitrary field as well (e.g., Due Date). Each discussion forum has an entry in the List of Lists table.