ST_TOPICS

This table contains the list of topics.

Column Field Type Length Primary Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

ObjectID

3

CreatedTime

datetime

8

N

ObjectID of the root object

4

CreatedUserID

varchar

254

N

Creation time

5

ModifiedTime

datetime

8

N

Creation user

6

ModifiedUserID

varchar

254

N

Time last modified

7

RevisionNumber

int

4

N

Number of revisions

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_TOPICS

ServerID

ST_LINKS

ServerID

2

ST_TOPICS

ID

ST_LINKS

ServerID

1

ST_TOPICS

ServerID

ST_LINKS

ServerID

2

ST_TOPICS

ID

ST_LINKS

ChildObjectID

1

ST_TOPICS

ServerID

ST_OBJECTACLS

ServerID

2

ST_TOPICS

ID

ST_OBJECTACLS

ServerID