This table is used to store information on the Portal discussion board messages. Discussion board messages are tied to content published to the Portal Library to provide a forum for discussing published content.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectkey | integer | not null | |
| pathid | nvarchar(100) | not null | This column holds a tree structure of the message postings
in a "file system like" path.
For example, a top level message has a path of "/1". A reply to the posting has a path of "/1/1". Type: |
| childcounter | integer | not null | This column defines the number of children for a particular posting. (Analogues to seeing the number of files and folders in Windows Explorer) |
| ownerid | integer | not null | Represents the UID of a Portal user that ownes the discussion. |
| subject | nvarchar(100) | not null | This column persists the message subject text. |
| content | long nvarchar | not null | This column persists the body of the posted message or reply. |
| datemodified | integer | not null | This column persists the date the message was modified as a Unix epoch (number of seconds since 1/1/1970) |
| depth | integer | not null | This column represents how many postings "deep" a message
is from the root.
Example: A message has a depth=1 A reply to the message has a depth=2 |
| changed | integer | not null | This column is a flag used to denote a message has been
updated.
The value in this column is not actively used by Portal. (The value is always "1".) |
Product Name: Portal
Table Type: Table