Groups Members Table Schema (groups_members)


Description

Link a user to a group.

groups_members table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
groupid bigint 10 0
groups.id groumemb_gro2_fk R
userid bigint 10 0
user.id groumemb_use2_fk R
timeadded bigint 10 0
component varchar 100

Defines the Moodle component which added this group membership (e.g. 'auth_myplugin'), or blank if it was added manually. (Entries which are created by a Moodle component cannot be removed in the normal user interface.)

itemid bigint 10 0

If the 'component' field is set, this can be used to define the instance of the component that created the entry. Otherwise should be left as default (0).

Table contained -1 rows

groups_members table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
groumemb_gro_ix Performance Asc groupid
groumemb_use_ix Performance Asc userid

groups_members table relationships