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.