Database schema for SharePoint 2010

1.SharePoint Foundation 2010 Database

1) Configuration Database

Configuration: Sharepoint_config

The configuration database contains information about SharePoint databases, Internet information Services (IIS) Web sites, Web applications, trusted solutions, Web Part packages, site templates, and SharePoint 2010 products. b data for application and server farm settings, such as default quota settings and blocked file types.

During a farm-only configuration backup or restore process, many configuration settings are not saved, especially WEB application settings, service application settings, and local server-specific settings. These settings are saved during farm content and configuration backup, but some of these settings, such as service application proxy settings, cannot be restored during farm recovery.

Central Administration content: sharepoint_admincontent

Treats the Central administration content database as a configuration database. It stores all site content, in addition to the user name and permissions for the Central Administration site collection, including site documents or files, list data, and Web Part properties in the document library. If Microsoft SQL Server PowerPivot for Microsoft SharePoint is installed, the EXCEL worksheet and PowerPivot data that are used in the PowerPivot management panel are also stored in the Central Administration content database File.

2) content database: WSS_Content

The content database stores all the content of a site collection, in addition to user names and permissions, including site documents or files in a document library, list data, Web Part properties, audit logs, and sandboxed solutions.

All data for a particular site collection resides only in one content database on a single server. Content databases can be associated with multiple site collections.

If you deployed Office Web apps, the content database also contains the Microsoft Office Web Apps cache. Only one cache is created for each WEB application. If multiple site collections that are stored in different content databases are activated for Office Web Apps, they will all use the same cache. You can configure cache size, expiration, and location.

If PowerPivot for SharePoint is installed in the environment, the content database also stores its user data.

It is strongly recommended that you limit the size of the content databases to a few gigabytes to help ensure system performance.

3) Service Application database

Usage and health Data Collection database: wss_usageapplication
Usage and health Data Collection service applications. It temporarily stores health monitoring and usage data, and can be used for reporting and diagnostics.

Business Data Connection database: Bdc_service_db_

The business Data Connectivity Service application database stores external content types and related objects.

Application Registry database: Application_registry_server_db_
The application Registry Service application database stores backward-compatible information that is used to connect to information used by the Microsoft Office SharePoint Server 2007 Business Data Catalog API.

Subscription settings database: Subscriptionsettings_
Microsoft SharePoint Foundation Subscription Settings Service application database stores the features and settings of a hosted customer. Subscription Settings Service applications and databases are not created through the SharePoint products and Technologies Configuration Wizard, they must be created through the Windows PowerShell cmdlet.

2.SharePoint Server Standard Edition database (the following databases are part of the SharePoint Server standard Edition deployment. ）

Secure Store Database: Secure_store_service_db_
The Secure store Service application database stores and maps credentials, such as account names and passwords.

State database: Stateservice
The State Service application database stores temporary status information for InfoPath Forms services, the chart Web part, and Visio Services.

Web Analytics Staging database: Webanalyticsserviceapplication_stagingdb_
The staging database temporarily stores non-aggregated fact data, asset metadata, and queued batch data for the Web Analytics Service application.

WEB Analytics Reporting Database: webanalyticsserviceapplication_reportingdb_
The reporting database stores aggregated standard reporting tables for Web Analytics Service applications, fact data aggregated by site groups, date and asset metadata, and diagnostic information.

Search Service Application Management database: Search_service_application_db_
The management database hosts the Search Service application configuration and Access control List (ACL), as well as the best match for the crawl component. Access this database for each user and administrative operation.

Search Service Application Crawl database: Search_service_application_crawlstoredb_
The crawl database stores the state and crawl history of the crawled data.

Search Service Application Properties Database: Search_service_application_propertystoredb_
The property database stores information that is associated with crawled data, including properties, history, and crawl queues.

User Profile Service Application configuration file database: User Profiles service Application_profiledb_
The profile database stores and manages users and related information. In addition to membership in distribution lists and sites, it stores information about the user's social network.

User Profile Service Application Synchronization database: User Profile Service Application_syncdb_
Synchronizes the configuration and staging data used by the database to store profile data when synchronizing with directory services, such as Active directory.

User Profile Service Application social tagging database: User Profile Service Application_socialdb_
The social tagging database stores social tags and annotations created by users, as well as their respective URLs.

Managed Metadata database: Managed Metadata service_
The Managed Metadata Service application database stores managed metadata and synthetic content types.

Word Automation Services Database: Wordautomationservices_
The Word Automation Services database stores information about incomplete and completed document conversions.

3.SharePoint Server Enterprise Edition database

In addition to the databases that are included with standard Edition, the following databases are part of the SharePoint Server Enterprise Edition deployment.

PerformancePoint Service Application database: PerformancePoint service Application_
The PerformancePoint Service application database stores temporary objects, persistent filter values, and user comments.

4.Project Server 2010 Database
Project Server 2010 requires SharePoint server Enterprise Edition.

Draft database: Projectserver_draft
The draft database contains data for editing the project. This database also hosts the tables used by the project queue. End users have no direct access to the data in the draft database.

Published database: projectserver_published
The published database contains a copy of all the items that have been published. The published database also contains Project Server-specific tables (timesheets, resources, custom fields, security definitions, and other metadata). This database also hosts the tables used by the timesheet queue. End users have no direct access to the data in the published database.

Archive database: Projectserver_archive_
The Archiving database stores the project, resource, Calendar, enterprise custom fields, enterprise global Project Web Access view definitions, Project Web Access system settings, and the backup data for category and group security settings that are set up by the Project Web Access administrator. End users cannot directly access data in the archive database.

Reporting Database: projectserver_reporting
A reporting database is a repository for the entire portfolio of projects in Project Server. These tables provide a stable snapshot of each project plan based on the time that the last project was published to Project Server, and include unhealthy timephased data to allow advanced reporting capabilities outside of the project client. End users cannot access data in the reporting database.

5.FAST Search Server for SharePoint 2010 databases
FAST Search Server for SharePoint requires SharePoint Server Enterprise Edition.

Search Administration Database: Fastsearchadmindatabase
The search administration database stores and manages data related to the management of FAST search Server for SharePoint. This includes search settings groups, keywords, synonyms, document and site promotion and demotion, term entity extractor inclusions and exclusions, spell check exclusions, Best Bets, visual Best Bets, and search schema metadata.

6.SQL System Database
7.SQL Server Reporting Services Database

Database schema for SharePoint 2010