2.2.7.10 UserInfo Table
The UserInfo Table stores descriptive properties and security information about principals with access to a site collection. The UserInfo Table is defined using T-SQL syntax, as follows.
-
TABLE UserInfo ( tp_SiteID uniqueidentifier NOT NULL, tp_Id int NOT NULL, tp_DomainGroup bit NOT NULL, tp_GUID uniqueidentifier NOT NULL DEFAULT (newid()), tp_SystemID varbinary(512) NOT NULL, tp_Deleted int NOT NULL, tp_SiteAdmin bit NOT NULL, tp_IsActive bit NOT NULL DEFAULT (1), tp_Login nvarchar(255) NOT NULL, tp_Title nvarchar(255) NOT NULL, tp_Email nvarchar(255) NOT NULL, tp_Notes nvarchar(1023) NOT NULL, tp_Token image NULL, tp_ExternalToken image NULL, tp_ExternalTokenLastUpdated datetime NULL, tp_Locale int NULL, tp_CalendarType smallint NULL, tp_AdjustHijriDays smallint NULL, tp_TimeZone smallint NULL, tp_Time24 bit NULL, tp_AltCalendarType uniqueidentifier NULL, tp_CalendarViewOptions uniqueidentifier NULL, tp_WorkDays smallint NULL, tp_WorkDayStartHour smallint NULL, tp_WorkDayEndHour smallint NULL );
tp_SiteID: The Site Collection Identifier (section 2.2.1.9) of the site collection associated with the principal.
tp_Id: The User Identifier (section 2.2.1.13) of the principal, which MUST be unique within both this table and the group identifiers for site groups. Certain User Identifiers are predefined, such as the system account (predefined as 1073741823), the site collection owner (predefined as 1), and the secondary site collection contact (predefined as 2). User Identifier values of 0 and -1 MUST NOT be used in the table.
tp_DomainGroup: A bit set to 1 if the principal is a domain group; otherwise, 0, specifying that the principal is a user.
tp_GUID: A GUID for indexing with the UserInfo table.
tp_SystemID: The SystemID (section 2.2.1.12) of the principal.
tp_Deleted: A value specifying whether the principal is marked as deleted. If tp_Deleted is 0, the principal is not deleted. If tp_Deleted is not 0, the principal is marked as deleted, and the value is the User Identifier that was associated with this principal. The deleted state can be used for user information, rather than dropping entries from the table, to preserve list item ownership information. A user or domain group with the tp_Deleted value set to nonzero can be restored by setting the tp_Deleted value to 0 and updating other fields as necessary.
tp_SiteAdmin: A bit set to 1 if the principal is a site administrator for the site collection.
tp_IsActive: A bit set to 1 if the principal is an active user in the site collection.
tp_Login: The login name for the principal. This value MUST NOT be empty.
tp_Title: The display name for the principal. This value MUST NOT be empty.
tp_Email: The email address for the principal. This value can be empty.
tp_Notes: A descriptive text about the principal. This value can be empty.
tp_Token: A WSS User Token (section 2.2.4.9) value specifying the site group membership of the principal. This can be NULL, indicating that the principal is not a member of a site group.
tp_ExternalToken: An External Group Token (section 2.2.4.2) value encoding information on external group membership derived from an external authentication role provider. This value can be NULL, indicating that this user has never visited any site in the site collection. If this value is NULL, the value in tp_ExternalTokenLastUpdated MUST also be NULL.
tp_ExternalTokenLastUpdated: A datetime containing a time stamp in UTC format specifying the time when the value in tp_ExternalToken for the principal was last updated. This can be NULL if the value in tp_ExternalToken has never been updated.
tp_Locale: An LCID specifying the preferred locale value to be used when displaying messages in the WFE for the principal. This can be NULL, specifying that the system or site default locale can be used instead.
tp_CalendarType: The Calendar Type to be used when processing date values for the principal. This can be NULL, specifying that the site default Calendar Type can be used instead.
tp_AdjustHijriDays: If the tp_CalendarType value is "6", this specifies the number of days to extend or reduce the current month in Hijri calendars for the principal. Otherwise, this value MUST be NULL and MUST be ignored.
tp_TimeZone: The Time Zone Identifier for the time zone to be used when displaying time values for the principal. This can be NULL, specifying that the system or site default time zone can be used instead.
tp_Time24: A bit flag specifying whether a 24-hour time format can be used when displaying time values to the principal. If tp_Time24 is 1, the 24-hour time format will be used; otherwise, the 12-hour time format will be used. This can be NULL, specifying that the system or site default can be used instead.
tp_AltCalendarType: The Calendar Type of an alternate calendar to be used when displaying calendars in views for the principal. This can be NULL, specifying that the tp_CalendarType value can be used instead.
tp_CalendarViewOptions: A Calendar View Options Type that specifies the calendar options for the principal. This can be NULL, specifying that the site default calendar view options can be used instead.
tp_WorkDays: A set of Workdays Flags that specify the weekdays defined as the workweek for the principal. This can be NULL, specifying that the site default Workdays value can be used instead.
tp_WorkDayStartHour: The start time of the workday in minutes after midnight for the principal. This can be NULL, specifying that the site default workday start hour can be used instead.
tp_WorkDayEndHour: The end time of the workday in minutes after midnight for the principal. This can be NULL, specifying that the site default workday end hour can be used instead.