Membership table structure

 

Table Name: aspnet_applications

Note: stores application information.

Field name	Type	Attribute	Description
Applicationname	Nvarchar (256)		Application name
Loweredapplicationname	Nvarchar (256)		Lower-case Application name
Applicationid	Uniqueidentifier	PK	Application ID, guid Value
Description	Nvarchar (256)	Nullable	Application description

Table Name: aspnet_paths

Description: path information.

Field name	Type	Attribute	Description
ApplicationId	Uniqueidentifier	FK: appnet_Applications.ApplciationId	Application Id
PathId	Uniqueidentifier	PK	Path Id
Path	Nvarchar (256)		Path information
LoweredPath	Nvarchar (256)		Lowercase path information

Table Name: aspnet_users

Note: user information

Field name	Type	Attribute	Description
ApplicationId	Uniqueidentifier		Application Id
UserId	Uniqueidentifier	PK	User ID
UserName	Nvarchar (256)		User Name
LoweredUserName	Nvarchar (256)		Lowercase User Name
MobileAlias	Nvarchar (16)		Mobile phone pin code (not used)
IsAnonymous	Bit		Anonymous user?
LastActivityDate	Datetime		Last activity date

Table Name: aspnet_membership

Description: member information

Field name	Type	Attribute	Description
ApplicationId	Uniqueidentifier	FK: appnet_App Lications. ApplciationId	Application Id
UserId	Uniqueidentifier	FK: aspnet_Users. UserID	User ID
Password	Nvarchar (128)		Password
PasswordFormat	Int		Password Storage Format
PasswordSalt	Nvarchar (128)		Password Hash value
MobilePIN	Nvarchar (16)		Mobile phone PIN code
Email	Nvarchar (256)		Email Address
LoweredEmail	Nvarchar (256)		Lowercase email address
PasswordQuestion	Nvarchar (256)		Forgotten Password
PasswordAnswer	Nvarchar (128)		Forgot password answer
IsApproved	Bit
IsLockedOut	Bit		Locked or not
CreateDate	Datetime		Creation Time
LastLoginDate	Datetime		Last Logon Time
LastPassword ChangedDate	Datetime		Last Password Change Time
LastLockoutDate	Datetime		Last account lock time
FailedPassword AttemptCount	Int		Number of failed password attempts
FailedPassword AttemptWindowStart	Datetime		Password failed attempt window opening time
FailedPassword AnswerAttemptCount	Int		Password loss attempts
FailedPasswordAnswer AttemptWindowStart	Datetime		Password loss question input window opening time
Comment	Ntext		Remarks

Table Name: aspnet_roles

Description: Role table

Field name	Type	Attribute	Description
Applicationid	Uniqueidentifier	FK: appnet_applications.applciationid	Application ID
Roleid	Uniqueidentifier	PK	Role ID
Rolename	Nvarchar (256)		Role name
Loweredrolename	Nvarchar (256)		Small role name
Description	Nvarchar (256)	Nullable	Description

Table Name: aspnet_usersinroles

Description: User Role Relationship table.

Field name	Type	Attribute	Description
Userid	Uniqueidentifier	FK: aspnet_users.userid	User ID
Roleid	Uniqueidentifier	FK: aspnet_roles.roleid	Role ID

Table Name: aspnet_profile

Description: profile Object Storage table

Field name	Type	Attribute	Description
Userid	Uniqueidentifier	FK: aspnet_users.userid	User ID
Propertynames	Ntext		Attribute name
PropertyValuesString	Ntext		String Value
PropertyValuesBinary	Image		Binary Value
LastUpdatedDate	Datetime		Last update date

 

Table Name: aspnet_personalizationallusers

Field name	Type	Attribute	Description
PathId	Uniqueidentifier	FK: aspnet_Paths.PathId	Path ID
PageSetting	Ntext		Personalized settings
LastUpdatedDate	Datetime		Last update date

Table Name: aspnet_personalizationperuser

Field name	Type	Attribute	Description
Id	Uniqueidentifier	PK	ID
PathID	Uniqueidentifier	FK: aspnet_Paths.PathId	Path ID
UserID	Uniqueidentifier	FK: aspnet_Users.UserId	User ID
PageSetting	Ntext		Personalized settings
LastUpdatedDate	Datetime		Last update date