List of Lists Table
The List of Lists table stores all the metadata information about the lists in the database. There is only one List of Lists table per database, even if the database supports multiple Web sites. In general, all fields referring to URLs in global lists are actually lookups into the URLs (DocMd) table (except where noted below). This allows fix-up when files are renamed.
The following table describes the columns and data types that are used in the List of Lists table.
| Column Name | Data Type | Description |
|---|---|---|
| tp_ID | Counter | Primary key for the table that uniquely identifies each list. |
| tp_Name | Text | The internal name of the list, which never changes. |
| tp_Title | Text | The display name of the list, which can be changed by the user. |
| tp_TableName | Text | The name of the SQL Server table that contains the data for the list. |
| tp_Modified | DateTime | The date and time that the list was most recently modified. |
| tp_Created | DateTime | The date and time that the list was created. |
| tp_Version | Integer | The version number of the row. Used for concurrency checking, which prevents simultaneous users from overwriting each other's changes to the list. |
| tp_BaseType | Integer | The base type that defines the default schema for a list (for example, custom list, document library, calendar, and so forth). |
| tp_ServerTemplate | Text | The list template (for example, for tasks, announcements, and so forth). |
| tp_Fields | Note | The CAML metadata that describes the fields in a list. |
| tp_Project | Lookup | Determines which SharePoint team Web site the list belongs to (a lookup to the Projects table). Each list is assigned to one and only one Web site. |
| tp_RootFolder | URL | The URL of the folder that contains the list. |
| tp_Template | Integer | The template used to create the list. This is only used for document libraries (NULL for all other lists) and is a lookup to the URLs (DocMd) table that references the document library template. This field pertains to client-side templates originating in Microsoft FrontPage, as well as to using the New Document button on the Shared Documents page in SharePoint Team Services, and to using the Templates on my Web Sites feature on the Task Pane in Microsoft Office XP applications. |
| tp_Description | Note | A long text string that specifies the description of the list. |
| tp_ImageURL | Text | Specifies the URL of the image used to display the list in List of Lists view.
Note This field is not a lookup to the URLs (DocMd) table, but is instead a text field containing the Web-relative URL of the image for this list (for example, "_layouts/images/iddl.gif" for the standard document library). |
| tp_ReadSecurity | Integer | Determines who can read items in the list. |
| tp_WriteSecurity | Integer | Determines who can update items in the list. |
| tp_SchemaSecurity | Integer | Determines who can change the list schema (for example, adding fields). |
| tp_Author | Lookup | Specifies the ID of the user who created the list. This field is a lookup to the People (UserInfo) table. |
| tp_Editor | Lookup | Specifies the ID of the user who last edited the list. This field is a lookup to the People (UserInfo) table.
Note This refers to the person who last edited the metadata of the list, and not to the last person who modified items in the list. |