ST_TOPICHISTORY
This table lists the topic history - one record for each revision.
Column | Field | Type | Length | Primary | Description |
---|---|---|---|---|---|
1 |
ServerID |
int |
4 |
Y |
Server ID |
2 |
ID |
int |
4 |
Y |
ObjectID |
3 |
RevisionNumber |
int |
4 |
Y |
Number of revisions |
4 |
CreatedTime |
datetime |
8 |
N |
ObjectID of the root object |
5 |
CreatedUserID |
varchar |
254 |
N |
Creation time |
6 |
ModifiedTime |
datetime |
8 |
N |
Creation user |
7 |
ModifiedUserID |
varchar |
254 |
N |
Time last modified |
8 |
RevisionFlags |
int |
4 |
N |
Revision Flags |
9 |
StComment |
text |
16 |
N |
Comment |
10 |
ParentTopicID |
int |
4 |
N |
ObjectID of Parent Topic |
11 |
Title |
varchar |
254 |
N |
Title |
12 |
Description |
text |
16 |
N |
Description |
13 |
AttachmentCount |
int |
4 |
N |
Attachment Count |
14 |
AttachmentNames |
text |
16 |
N |
Names of all attachments |
15 |
Status |
varchar |
254 |
N |
Status |
16 |
Priority |
varchar |
254 |
N |
Priority |
17 |
TopicNumber |
int |
4 |
N |
Topic Number |
18 |
RecipientCount |
int |
4 |
N |
Number of Recipients |
19 |
RecipientNames |
text |
16 |
N |
List of all Recipients |
20 |
DotNotation |
varchar |
254 |
N |
Dot Notation |
Table Joins
Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
---|---|---|---|---|
1 |
ST_TOPICHISTORY |
ServerID |
ST_VIEWMEMBER |
ServerID |
2 |
ST_TOPICHISTORY |
ID |
ST_VIEWMEMBER |
ID |
3 |
STTOPICHISTORY |
RevisionNumber |
STVIEWMEMBER |
RevisionNumber |