after the SPS installation is complete, there are four databases associated with it in SQL Server:
sps01_config_db, SPS configuration information Database
Site name 1_prof, storing SPS personal information
Site name 1_serv, Storage server-related information
Site name 1_site, the SPS master database, the documents in the site, the list, and the pictures are basically stored in this database.
(where "site name" refers to the SPS server name specified when you install SPS)
1, sps01_config_db, Configuration Information database table (10 tables)
antivirusvendors antivirus software provider.
customtemplates Template (template selection) that appears in the list of global templates.
Databases content database and related settings.
the settings that are applied to all physical sites in the Globals schema.
installedwebpartpackages The Web Component package that is available for the virtual server.
Servers A physical computer in a SharePoint schema.
Services in a service SharePoint schema, such as databases, sites, messages, and so on.
Sites A site in the SharePoint schema.
virtualservers the virtual server and its associated settings.
webpartpackages The Web Component package that is installed in the schema.
2. Website name 1_site, website content database table (29 tables)
Categories document and its assigned area collaboration.
COMMD Document discussions.
Deps document attachments.
diskwarningdate The date and time that the disk quota was last warned.
Docs files and folders.
docversions The document version history from the document library.
eventcache Alert cache.
EventLog alert log.
Ht_cache Browser Document conversion view cache.
ht_settings HTML view configuration.
immedsubscriptions Notification of changes immediately sent
links in the link recalculation process to recalculate.
Lists site list.
Navnodes The set of nodes displayed by the navigation bar.
personalization a custom Web component.
schedsubscriptions a daily or weekly scheduled notification.
Sitegroupmembership Cross-site group members.
sitegroups Cross-site groups.
Sites the content database site.
Timerlock determines the locking scheme of the server lock lock database.
UserData list data.
UserInfo The information that each user adds to the site.
Webcat links between the site and the area.
webgroupmembership A list of site group members.
webgroups site groups (such as Administrators, site designers).
webmembers site members.
the Web Components available to the WebParts site. A view of a Web component.
Webs and a subweb associated with a site.
welcomenames site Default document.
This article from "Bo shen" blog, reproduced please contact the author!
-----database table Structure Analysis of SPS technology system