2.2.5.7 UserInfo Table
The UserInfo table stores information about each user that is added to the site. 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 tSystemID NOT NULL, tp_Deleted int NOT NULL, tp_SiteAdmin bit NOT NULL, 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_SiteID: The Site Collection Identifier (section 2.2.1.17) of the site collection that is associated with the principal (1).
tp_ID: The User Identifier (section 2.2.1.24) of the principal (1). This value MUST be unique.
tp_DomainGroup: A bit flag that specifies whether the account is a domain group account. A bit set to 1 if the principal (1) is a domain group. Otherwise, the bit is set to 0, specifying that the principal (1) is a user.
tp_GUID: A GUID for indexing with the UserInfo table.
tp_SystemID: The SystemID (section 2.2.1.20) of the principal (1).
tp_Deleted: A value specifying whether the principal (1) is marked as deleted. If tp_Deleted is 0, the principal (1) is not deleted. If tp_Deleted is not 0, the principal (1) is marked as deleted, and the value is the User Identifier that was associated with this principal.
tp_SiteAdmin: A bit set to 1 if the principal (1) is a site administrator for the site collection.
tp_Login: The login name for the principal (1).
tp_Title: The display name for the principal (1).
tp_Email: The email address for the principal (1).
tp_Notes: A descriptive text about the principal.