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