Custom Lists

All custom lists contain the fields and data types listed in the following table.

Column Name Data Type Description
tp_ID Counter The primary key for the list.
tp_Title Text The title of an item in the list. The display name of the title field may vary in different lists, for example, Task Name.
tp_Modified DateTime The time that the item was last modified.
tp_Created DateTime The time that the item was created.
tp_Author Lookup A lookup to the UserInfo table that identifies the user who created the item.
tp_Editor Lookup A lookup to the UserInfo table that identifies the user who last edited the item.
tp_Version Integer A version stamp used for concurrency checking.

See Also

Overview of the SharePoint Team Services Database

List Data Types

Using SQL with the SharePoint Team Services Database