UserGroup
Fields
| Field name | Ordinal | Native type | Length | Precision | Scale | Is Nullable | Is PK | Is FK | Is Identity | Is Computed | Default value | Default sequence |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| UserId | 1 | varchar | 15 | 0 | 0 | Yes | Yes | |||||
| GroupId | 2 | int | 0 | 10 | 0 | Yes | Yes |
Foreign key constraints
FK_UserGroup_Group
| Aspect | Value |
|---|---|
| Primary key table | dbo.Group |
| Delete rule | NoAction |
| Update rule | NoAction |
| Foreign key field | Primary key field |
|---|---|
| GroupId | dbo.Group.Id |
FK_UserGroup_User
| Aspect | Value |
|---|---|
| Primary key table | dbo.User |
| Delete rule | Cascade |
| Update rule | Cascade |
| Foreign key field | Primary key field |
|---|---|
| UserId | dbo.User.UserID |
Model elements mapped on this table
None.