UserInfo Table
The UserInfo table stores information about each user added to the site.
Warning Modifying the database schema or database structures is unsupported.
Changes that you make to the database contents may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.
Columns
| Column name | Data type | Description |
|---|
| tp_SiteID | uniqueidentifier | ID of the site to which the user belongs. Found in the Sites table.
|
| tp_ID | int | ID of the user. Incremented numerically. |
| tp_DomainGroup | bit | Value that specifies whether the account is a domain group
account. |
| tp_GUID | uniqueidentifier | GUID for the user. |
| tp_SystemID | varbinary | Security token
for the user. |
| tp_Deleted | int | Value that specifies whether the user was deleted. Note: The user is not removed
because the user data is referenced in many other tables.
|
| tp_SiteAdmin | bit | Value that specifies whether the user is a site administrator. |
| tp_Login | nvarchar | Value that specifies the logon name of the
user. |
| tp_Title | nvarchar | Value that specifies the display name of the user. |
| tp_Email | nvarchar | Value that specifies the e-mail address of the user. |
| tp_Notes | nvarchar | Notes about the user. |