ASPNETDB Database

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