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