groups_users

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_id uuid 2147483647 null
groups.id FK_groups_users_groups_group_id C
user_id uuid 2147483647 null
users.id FK_groups_users_users_user_id C
tenant_id uuid 2147483647 null
tenants.id FK_groups_users_tenants_tenant_id C

Indexes

Constraint Name Type Sort Column(s)
PK_groups_users Primary key Asc/Asc group_id + user_id
IX_groups_users_tenant_id Performance Asc tenant_id
IX_groups_users_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation