This table provides the list of user groups relationships.
Column |
Field |
Type |
Length |
Primary |
Description |
---|---|---|---|---|---|
1 |
ServerID |
int |
4 |
Y |
Server ID |
2 |
GroupID |
int |
4 |
Y |
Group ID |
3 |
UserID |
int |
4 |
Y |
User ID |
Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
---|---|---|---|---|
1 |
ST_GROUPS |
ServerID |
ST_GROUPUSERS |
ServerID |
2 |
ST_GROUPS |
ID |
ST_GROUPUSERS |
GroupID |
1 |
ST_USERS |
ServerID |
ST_GROUPUSERS |
ServerID |
2 |
STUSERS |
ID |
STGROUPUSERS |
UserID |