Table: aspnet_Users

Description

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

Columns

Name	Type	Description
ApplicationId	uniqueidentifier	Application ID
UserId	uniqueidentifier	User ID
UserName	nvarchar(256)	User name
LoweredUserName	nvarchar(256)	User name (lowercase)
MobileAlias	nvarchar(16)	User's mobile alias (currently not used)
IsAnonymous	bit	1=Anonymous user, 0=Not an anonymous user
LastActivityDate	datetime	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

---

ASP.NET 2.0 Provider Database