Table: aspnet_Users

Description

Used to store information regarding users, including user names and IDs.

Columns

Name	Type	Required?	Defaults To	Description
ApplicationId	uniqueidentifier	Yes		Application ID
UserId	uniqueidentifier	Yes	(newid())	User ID
UserName	nvarchar(256)	Yes		User name
LoweredUserName	nvarchar(256)	Yes		User name (lowercase)
MobileAlias	nvarchar(16)	No	(NULL)	User's mobile alias (currently not used)
IsAnonymous	bit	Yes	((0))	1=Anonymous user, 0=Not an anonymous user
LastActivityDate	datetime	Yes		Date and time of last activity by this user

Relationships

Primary Table	Primary Key	Foreign Table	Foreign Key
aspnet_Applications	ApplicationId	aspnet_Users	ApplicationId
aspnet_Users	UserId	aspnet_Membership	UserId
aspnet_Users	UserId	aspnet_Profile	UserId
aspnet_Users	UserId	aspnet_UsersInRoles	UserId
aspnet_Users	UserId	aspnet_PersonalizationPerUser	UserId

Indexes

Name	Type	Columns
aspnet_Users_Index	Unique, Clustered	ApplicationId, LoweredUserName
aspnet_Users_Index2	Non-unique	ApplicationId, LastActivityDate
PK__aspnet_Users__03317E3D	Unique	UserId

Referencing Views

Name
vw_aspnet_MembershipUsers
vw_aspnet_Users

Definition

CREATE TABLE [aspnet_Users]
(
    [ApplicationId] uniqueidentifier NOT NULL,
    [UserId] uniqueidentifier NOT NULL DEFAULT ((newid())),
    [UserName] nvarchar(256) NOT NULL,
    [LoweredUserName] nvarchar(256) NOT NULL,
    [MobileAlias] nvarchar(16) NULL DEFAULT ((NULL)),
    [IsAnonymous] bit NOT NULL DEFAULT (((0))),
    [LastActivityDate] datetime NOT NULL
    CONSTRAINT [PK_aspnet_Users] PRIMARY KEY
    (
        [UserId]
    )
)

---

ASP.NET 2.0 Provider Database