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
itemid BIGINT 19 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

Close relationships within degrees of separation