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