aspnet_Applications
| Column Name | Data Type | Nullable | Key | Description |
| ApplicationName | nvarchar(512) | no | ||
| LoweredApplicationName | nvarchar(512) | no | ||
| ApplicationId | uniqueidentifier | no | ||
| Description | nvarchar(512) | yes |
aspnet_Membership
| Column Name | Data Type | Nullable | Key | Description |
| ApplicationId | uniqueidentifier | no | ||
| UserId | uniqueidentifier | no | ||
| Password | nvarchar(256) | no | ||
| PasswordFormat | int | no | ||
| PasswordSalt | nvarchar(256) | no | ||
| MobilePIN | nvarchar(32) | yes | ||
| nvarchar(512) | yes | |||
| LoweredEmail | nvarchar(512) | yes | ||
| PasswordQuestion | nvarchar(512) | yes | ||
| PasswordAnswer | nvarchar(256) | yes | ||
| IsApproved | bit | no | ||
| IsLockedOut | bit | no | ||
| CreateDate | datetime | no | ||
| LastLoginDate | datetime | no | ||
| LastPasswordChangedDate | datetime | no | ||
| LastLockoutDate | datetime | no | ||
| FailedPasswordAttemptCount | int | no | ||
| FailedPasswordAttemptWindowStart | datetime | no | ||
| FailedPasswordAnswerAttemptCount | int | no | ||
| FailedPasswordAnswerAttemptWindowStart | datetime | no | ||
| Comment | ntext(3000) | yes |
aspnet_Profile
| Column Name | Data Type | Nullable | Key | Description |
| UserId | uniqueidentifier | no | ||
| PropertyNames | ntext(6000) | no | ||
| PropertyValuesString | ntext(6000) | no | ||
| PropertyValuesBinary | image | no | ||
| LastUpdatedDate | datetime | no |
aspnet_Roles
| Column Name | Data Type | Nullable | Key | Description |
| ApplicationId | uniqueidentifier | no | ||
| RoleId | uniqueidentifier | no | ||
| RoleName | nvarchar(512) | no | ||
| LoweredRoleName | nvarchar(512) | no | ||
| Description | nvarchar(512) | yes |
aspnet_SchemaVersions
| Column Name | Data Type | Nullable | Key | Description |
| Feature | nvarchar(256) | no | ||
| CompatibleSchemaVersion | nvarchar(256) | no | ||
| IsCurrentVersion | bit | no |
aspnet_Users
| Column Name | Data Type | Nullable | Key | Description |
| ApplicationId | uniqueidentifier | no | ||
| UserId | uniqueidentifier | no | ||
| UserName | nvarchar(512) | no | ||
| LoweredUserName | nvarchar(512) | no | ||
| MobileAlias | nvarchar(32) | yes | ||
| IsAnonymous | bit | no | ||
| LastActivityDate | datetime | no |
aspnet_UsersInRoles
| Column Name | Data Type | Nullable | Key | Description |
| UserId | uniqueidentifier | no | ||
| RoleId | uniqueidentifier | no |
