ST_LINKS

This table provides the list of links.

Column

Field

Type

Length

Primary

Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

Link ID

3

ParentObjectID

int

4

N

Object ID of Parent Item

4

ParentClassID

int

4

N

ClassID of Type of Parent Item

5

ParentType

varchar

254

N

Type of Parent Item

6

ChildObjectID

int

4

N

ObjectID of Child Item

7

ChildClassID

int

4

N

ClassID of Type of Child Item

8

ChildType

varchar

254

N

Type of Child Item

9

CreatedOn

datetime

8

N

Time Link was created

10

CreatedBy

varchar

254

N

User who created Link

11

StComment

varchar

762

N

Comment

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field

1

ST_LINKS

ServerID

ST_ITEMLINKS

ServerID

2

ST_LINKS

ID

ST_ITEMLINKS

ID

1

ST_CRS

ServerID

ST_LINKS

ServerID

2

ST_CRS

ID

ST_LINKS

ParentObjectID

1

ST_CRS

ServerID

ST_LINKS

ServerID

2

ST_CRS

ID

ST_LINKS

ChildObjectID

1

ST_FILES

ServerID

ST_LINKS

ServerID

2

ST_FILES

ID

ST_LINKS

ParentObjectID

1

ST_FILES

ServerID

ST_LINKS

ServerID

2

ST_FILES

ID

ST_LINKS

ChildObjectID

1

ST_FOLDERS

ServerID

ST_LINKS

ServerID

2

ST_FOLDERS

ID

ST_LINKS

ParentObjectID

1

ST_FOLDERS

ServerID

ST_LINKS

ServerID

2

ST_FOLDERS

ID

ST_LINKS

ChildObjectID

1

ST_REQS

ServerID

ST_LINKS

ServerID

2

ST_REQS

ID

ST_LINKS

ParentObjectID

1

ST_REQS

ServerID

ST_LINKS

ServerID

2

ST_REQS

ID

ST_LINKS

ChildObjectID

1

ST_TASKS

ServerID

ST_LINKS

ServerID

2

ST_TASKS

ID

ST_LINKS

ParentObjectID

1

ST_TASKS

ServerID

ST_LINKS

ServerID

2

ST_TASKS

ID

ST_LINKS

ChildObjectID

1

ST_TOPICS

ServerID

ST_LINKS

ServerID

2

ST_TOPICS

ID

ST_LINKS

ParentObjectID

1

ST_TOPICS

ServerID

ST_LINKS

ServerID

2

STTOPICS

ID

STLINKS

ChildObjectID