Share this page
ST_GROUPS
This table provides the list of groups.
| Column | Field | Type | Length | Primary | Description |
|---|---|---|---|---|---|
|
1 |
ServerID |
int |
4 |
Y |
Server ID |
|
2 |
ID |
int |
4 |
Y |
Group ID |
|
3 |
Name |
varchar |
254 |
N |
Group Name |
|
4 |
Description |
varchar |
762 |
N |
Description |
|
5 |
Parent |
varchar |
254 |
N |
Name of Parent group |
|
6 |
IsBuiltIn |
int |
4 |
N |
Whether this is a built in group |
|
7 |
IsRoot |
int |
4 |
N |
Whether this is the root group |
|
8 |
IsDeleted |
int |
4 |
N |
Whether this is deleted |
|
9 |
SubGroups |
text |
16 |
N |
List of all subgroups |
|
10 |
Users |
text |
16 |
N |
List of all user names in this group |
Table Joins
| Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
|---|---|---|---|---|
|
1 |
ST_SERVER |
ServerID |
ST_GROUPS |
ServerID |
|
1 |
ST_GROUPS |
ServerID |
ST_GROUPUSERS |
ServerID |
|
2 |
ST_GROUPS |
ID |
ST_GROUPUSERS |
GroupID |
|
1 |
ST_GROUPS |
ServerID |
ST_OBJECTACLS |
ServerID |
|
2 |
ST_GROUPS |
ID |
ST_OBJECTACLS |
ID |
