ST_ITEMLINKS

This table lists the list of links with the pinned revision and with respect to itemID.

Column

Field

Type

Length

Primary

Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

Link ID

3

ItemID

int

4

Y

4

LinkEnd

int

4

N

5

ObjectID

int

4

N

Object ID

6

RevisionNumber

int

4

N

Revision Number

7

IsPinned

int

4

N

Whether link is pinned

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_VIEWMEMBER

ServerID

ST_ITEMLINKS

ServerID

2

STVIEWMEMBER

ItemID

STITEMLINKS

ItemID