Appendix C   SilverStream System Tables and URLs

SilverStream stores application and system data in a database called the SilverMaster (the SilverMaster is described in Database Configuration) and in application databases. This appendix provides a listing of system tables and database URLs.

NOTE   The items listed are reserved for SilverStream's use. This listing is provided for informational purposes only.

SilverStream internal system tables   

The following are the SilverStream internal tables. The information in these tables controls major server functions such as application data storage and management, security, and server clustering for load balancing. Some tables are used in each database connected to the server. The remainder of the tables exist in the SilverMaster only.

Tables in all databases

The following tables exist in or in conjunction with each database connected to the SilverStream Server (including SilverMaster).

Database system table	Purpose
AgAccessRights	Contains security access information on resources.
AgAgents	Contains business object information.
AgContents	Contains the contents of application resources, such as pages and forms.
AgInfo	Contains a catalog of known databases and their system information.
AgResources	Manages details of all objects stored in SilverStream databases.

Tables only in SilverMaster

The following tables exist in the SilverMaster database only.

SilverMaster table	Description
AgCacheMgr	Contains Cache Manager information.
AgCacheMgrGroup	Contains Cache Manager group information.
AgCertificates	Contains certificate information.
AgCluster	Contains SilverStream cluster information. Used with load balancing software.
AgClusterEnv	Contains SilverStream cluster information. Used with load balancing software.
AgDispatcherMgr	Contains Dispatcher information. Used with SilverStream clusters.
AgDispatcherMgrGrp	Contains Dispatcher group information. Used with SilverStream clusters.
AgErrorLog	Contains SilverStream error log information.
AgGroupMembers	Contains a list of members of SilverStream groups in UUID format.
AgLoadMgr	Contains Load Manager information. Used with SilverStream clusters.
AgLoadMgrGroup	Contains Load Manager group information. Used with SilverStream clusters.
AgLog	Contains SilverStream log information.
AgObjects	Contains SilverStream object information.
AgPasswords	Contains SilverStream password information.
AgProperties	Contains SilverStream Server properties
AgPrincipals	Contains a list of SilverStream users and groups in UUID format.
AgServer	Contains SilverStream Server information
AgTraceLog	Contains trace log information.
AgUserLicense	Contains SilverStream user license information.

SilverStream database URLs   

The following table lists the directory structure for SilverStream applications that contain SilverStream tables and objects. By default, these items are located in /database/SilverStream/. This listing is provided for informational purposes only.

Database URL	Description
Administration	Server administration settings.
Classes	Compiled Java class subdirectories and files.
ClusterAdmin	Administrative functions (server clusters only).
Downloads	Temporary communication endpoints.
ErrorLogs	Error messages.
Login	Forces user login access.
Logout	Logs user out of session.
Meta/... Agents Certificates Entities Forms Licenses Reports ServerCertificate Tables UUIDTranslator Views Webbases	Corresponds to... Business object definitions Certificates resource Table names resource Forms Licenses Not used Certificates resource Table names and contents Internal resource Views Databases
Objectstore/	Uploaded media files.
Pages	HTML pages (active presentation & static).
Resources	Directory of system files.
Security	Endpoint for security administration.
Sessions	Displays current session information, including session number, user, host, and state.
SilverJRunnerInstall	SilverJRunner installation.
Statistics	Displays server statistics.
Timestamps	Displays time stamped events (internal only).
VersionCheck	Displays SilverStream version number.