groups_members

0 rows


Description

Link a user to a group.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
groupid BIGINT 19 0
groups.id groumemb_gro2_fkR
userid BIGINT 19 0
user.id groumemb_use2_fkR
timeadded BIGINT 19 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 19 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).

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
groumemb_gro4_ix Performance Asc groupid
groumemb_use4_ix Performance Asc userid
groumemb_usegro2_uix Must be unique Asc/Asc userid + groupid

Relationships