usergrouprel


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
groupId INT 10 null
usergroup.id FKp4d0f4tvu89b2accb697ghey R
userId INT 10 null
sysuser.id FKs5ox33341k8uindk5oqecnke9 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKp4d0f4tvu89b2accb697ghey Performance Asc groupId
UK3whbuakb6d6s4nne96xfrbwot Must be unique Asc/Asc userId + groupId

Relationships

Close relationships within degrees of separation