UserRole

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 int 0 10 0 Yes Yes
RoleID 2 int 0 10 0 Yes Yes

Foreign key constraints

FK_UserRole_Role

Aspect Value
Primary key table dbo.Role
Delete rule NoAction
Update rule NoAction
Foreign key field Primary key field
RoleID dbo.Role.RoleID

FK_UserRole_User

Aspect Value
Primary key table dbo.User
Delete rule NoAction
Update rule NoAction
Foreign key field Primary key field
UserID dbo.User.UserID

Model elements mapped on this table

Model Element Element type
UserRole Entity