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 |