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. |