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 |
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 |