Table: aspnet_UsersInRoles

Description

Used by the SQL Role Provider to map roles to users.

Columns

Name	Type	Required?	Defaults To	Description
UserId	uniqueidentifier	Yes		User ID
RoleId	uniqueidentifier	Yes		Role ID

Relationships

Primary Table	Primary Key	Foreign Table	Foreign Key
aspnet_Users	UserId	aspnet_UsersInRoles	UserId
aspnet_Roles	RoleId	aspnet_UsersInRoles	RoleId

Indexes

Name	Type	Columns
aspnet_UsersInRoles_index	Non-unique	RoleId
PK__aspnet_UsersInRo__35BCFE0A	Unique, Clustered	UserId, RoleId

Referencing Views

Name
vw_aspnet_UsersInRoles

Definition

CREATE TABLE [aspnet_UsersInRoles]
(
    [UserId] uniqueidentifier NOT NULL,
    [RoleId] uniqueidentifier NOT NULL
    CONSTRAINT [PK_aspnet_UsersInRoles] PRIMARY KEY
    (
        [UserId],
        [RoleId]
    )
)

---

ASP.NET 2.0 Provider Database