user_usergroup

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id INT 10 null
users.id FK_4A84F5F3A76ED395C
usergroup_id VARCHAR 36 null
usergroup.id FK_4A84F5F3D2112630C

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc user_id + usergroup_id
IDX_4A84F5F3A76ED395 Performance Asc user_id
IDX_4A84F5F3D2112630 Performance Asc usergroup_id

Relationships

Close relationships within degrees of separation