Table: aspnet_Profile

Description

Used by the SQL Profile Provider to store individual instances of property values.

Columns

Name	Type	Required?	Defaults To	Description
UserId	uniqueidentifier	Yes		ID of the user to which this profile data pertains
PropertyNames	ntext	Yes		Names of all property values stored in this profile
PropertyValuesString	ntext	Yes		Values of properties that could be persisted as text
PropertyValuesBinary	image	Yes		Values of properties that were configured to use binary serialization
LastUpdatedDate	datetime	Yes		Date and time this profile was last updated

Relationships

Primary Table	Primary Key	Foreign Table	Foreign Key
aspnet_Users	UserId	aspnet_Profile	UserId

Indexes

Name	Type	Columns
PK__aspnet_Profile__286302EC	Unique, Clustered	UserId

Referencing Views

Name
vw_aspnet_Profiles

Definition

CREATE TABLE [aspnet_Profile]
(
    [UserId] uniqueidentifier NOT NULL,
    [PropertyNames] ntext NOT NULL,
    [PropertyValuesString] ntext NOT NULL,
    [PropertyValuesBinary] image NOT NULL,
    [LastUpdatedDate] datetime NOT NULL
    CONSTRAINT [PK_aspnet_Profile] PRIMARY KEY
    (
        [UserId]
    )
)

---

ASP.NET 2.0 Provider Database