UserData Table
The UserData table stores the data that is displayed in the lists.
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_ID | int | ID of the data. |
| tp_ListId | uniqueidentifier | GUID of the list with which the data is associated. Found in the Lists table. |
| tp_SiteId | uniqueidentifier | GUID of the SharePoint site to which the data belongs. Found in the Sites table. |
| tp_Version | int | Value that indicates the version of the data. |
| tp_Author | int | tp_ID from the UserInfo table of the user who entered the data. |
| tp_Editor | int | tp_ID from the UserInfo table of the user who last modified the data. |
| tp_Modified | datetime | Date and time the data was modified. |
| tp_Created | datetime | Date and time the data was created. |
| tp_Ordering | varchar | Field that specifies the order for threading Web discussion comments. |
| tp_HasAttachment | bit | Value that specifies whether the item has an associated attachment. |
| tp_ModerationStatus | int | Value that specifies the status of a list if it is moderated. 0 is approved; 2 is pending; 1 is rejected. |
| tp_IsCurrent | bit | Value indicating whether the item is the current item in the issue tracking list. |
| tp_ItemOrder | float | Sort criterion for an ordered list. |
| tp_InstanceID | int | ID for an occurrence in a Meeting Workspace site that has a recurring event or multiple single events linked to it. |
| tp_GUID | uniqueidentifier | GUID value used in full-text search. |
| tp_Size | int | Size of the data. |
| nvarchar1 | nvarchar | Available field for custom information using the Microsoft SQL Server nvarchar data type. |
| nvarchar2 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar3 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar4 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar5 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar6 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar7 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar8 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar9 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar10 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar11 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar12 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar13 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar14 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar15 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar16 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar17 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar18 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar19 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar20 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar21 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar22 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar23 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar24 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar25 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar26 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar27 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar28 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar29 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar30 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar31 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar32 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar33 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar34 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar35 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar36 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar37 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar38 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar39 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar40 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar41 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar42 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar43 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar44 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar45 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar46 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar47 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar48 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar49 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar50 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar51 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar52 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar53 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar54 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar55 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar56 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar57 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar58 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar59 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar60 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar61 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar62 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar63 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| nvarchar64 | nvarchar | Available field for custom information using the SQL Server nvarchar data type. |
| int1 | int | Available field for custom information using the SQL Server int data type. |
| int2 | int | Available field for custom information using the SQL Server int data type. |
| int3 | int | Available field for custom information using the SQL Server int data type. |
| int4 | int | Available field for custom information using the SQL Server int data type. |
| int5 | int | Available field for custom information using the SQL Server int data type. |
| int6 | int | Available field for custom information using the SQL Server int data type. |
| int7 | int | Available field for custom information using the SQL Server int data type. |
| int8 | int | Available field for custom information using the SQL Server int data type. |
| int9 | int | Available field for custom information using the SQL Server int data type. |
| int10 | int | Available field for custom information using the SQL Server int data type. |
| int11 | int | Available field for custom information using the SQL Server int data type. |
| int12 | int | Available field for custom information using the SQL Server int data type. |
| int13 | int | Available field for custom information using the SQL Server int data type. |
| int14 | int | Available field for custom information using the SQL Server int data type. |
| int15 | int | Available field for custom information using the SQL Server int data type. |
| int16 | int | Available field for custom information using the SQL Server int data type. |
| float1 | float | Available field for custom information using the SQL Server float data type. |
| float2 | float | Available field for custom information using the SQL Server float data type. |
| float3 | float | Available field for custom information using the SQL Server float data type. |
| float4 | float | Available field for custom information using the SQL Server float data type. |
| float5 | float | Available field for custom information using the SQL Server float data type. |
| float6 | float | Available field for custom information using the SQL Server float data type. |
| float7 | float | Available field for custom information using the SQL Server float data type. |
| float8 | float | Available field for custom information using the SQL Server float data type. |
| float9 | float | Available field for custom information using the SQL Server float data type. |
| float10 | float | Available field for custom information using the SQL Server float data type. |
| float11 | float | Available field for custom information using the SQL Server float data type. |
| float12 | float | Available field for custom information using the SQL Server float data type. |
| float13 | float | Available field for custom information using the SQL Server float data type. |
| float14 | float | Available field for custom information using the SQL Server float data type. |
| float15 | float | Available field for custom information using the SQL Server float data type. |
| float16 | float | Available field for custom information using the SQL Server float data type. |
| float17 | float | Available field for custom information using the SQL Server float data type. |
| float18 | float | Available field for custom information using the SQL Server float data type. |
| float19 | float | Available field for custom information using the SQL Server float data type. |
| float20 | float | Available field for custom information using the SQL Server float data type. |
| float21 | float | Available field for custom information using the SQL Server float data type. |
| float22 | float | Available field for custom information using the SQL Server float data type. |
| float23 | float | Available field for custom information using the SQL Server float data type. |
| float24 | float | Available field for custom information using the SQL Server float data type. |
| float25 | float | Available field for custom information using the SQL Server float data type. |
| float26 | float | Available field for custom information using the SQL Server float data type. |
| float27 | float | Available field for custom information using the SQL Server float data type. |
| float28 | float | Available field for custom information using the SQL Server float data type. |
| float29 | float | Available field for custom information using the SQL Server float data type. |
| float30 | float | Available field for custom information using the SQL Server float data type. |
| float31 | float | Available field for custom information using the SQL Server float data type. |
| float32 | float | Available field for custom information using the SQL Server float data type. |
| datetime1 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime2 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime3 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime4 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime5 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime6 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime7 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime8 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime9 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime10 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime11 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime12 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime13 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime14 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime15 | datetime | Available field for custom information using the SQL Server datetime data type. |
| datetime16 | datetime | Available field for custom information using the SQL Server datetime data type. |
| bit1 | bit | Available field for custom information using the SQL Server bit data type. |
| bit2 | bit | Available field for custom information using the SQL Server bit data type. |
| bit3 | bit | Available field for custom information using the SQL Server bit data type. |
| bit4 | bit | Available field for custom information using the SQL Server bit data type. |
| bit5 | bit | Available field for custom information using the SQL Server bit data type. |
| bit6 | bit | Available field for custom information using the SQL Server bit data type. |
| bit7 | bit | Available field for custom information using the SQL Server bit data type. |
| bit8 | bit | Available field for custom information using the SQL Server bit data type. |
| bit9 | bit | Available field for custom information using the SQL Server bit data type. |
| bit10 | bit | Available field for custom information using the SQL Server bit data type. |
| bit11 | bit | Available field for custom information using the SQL Server bit data type. |
| bit12 | bit | Available field for custom information using the SQL Server bit data type. |
| bit13 | bit | Available field for custom information using the SQL Server bit data type. |
| bit14 | bit | Available field for custom information using the SQL Server bit data type. |
| bit15 | bit | Available field for custom information using the SQL Server bit data type. |
| bit16 | bit | Available field for custom information using the SQL Server bit data type. |
| uniqueidentifier1 | uniqueidentifier | Available field for custom information using the SQL Server uniqueidentifier data type. |
| ntext1 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext2 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext3 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext4 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext5 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext6 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext7 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext8 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext9 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext10 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext11 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext12 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext13 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext14 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext15 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext16 | ntext | Available field for custom information using the SQL Serverntext data type. |
| ntext17 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext18 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext19 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext20 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext21 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext22 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext23 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext24 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext25 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext26 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext27 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext28 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext29 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext30 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext31 | ntext | Available field for custom information using the SQL Server ntext data type. |
| ntext32 | ntext | Available field for custom information using the SQL Server ntext data type. |
| sql_variant1 | sql_variant | Available field for custom information using the SQL Server sql_variant data type. |
| sql_variant2 | sql_variant | Available field for custom information using the SQL Server sql_variant data type. |
| sql_variant3 | sql_variant | Available field for custom information using the SQL Server sql_variant data type. |
| sql_variant4 | sql_variant | Available field for custom information using the SQL Server sql_variant data type. |
| sql_variant5 | sql_variant | Available field for custom information using the SQL Server sql_variant data type. |
| sql_variant6 | sql_variant | Available field for custom information using the SQL Server sql_variant data type. |
| sql_variant7 | sql_variant | Available field for custom information using the SQL Server sql_variant data type. |
| sql_variant8 | sql_variant | Available field for custom information using the SQL Server sql_variant data type. |