System Database Tables

See Also

The Access Workflow Designer server components include a special database called modSystem that acts as the registry for the system. The modSystem database is a repository for team templates and other system-level components, such as stored procedures and solution properties. The name modSystem is used by internal components; therefore, the name cannot be used by other databases on the same server.

The system database stores a list of all solutions, templates, and information about database users created on the server. Initially, the system database contains the Issue Tracking template provided by Access Workflow Designer. When you create new team templates in the Access Workflow Designer, they are registered in the modTemplates table in the modSystem database. When the administrator creates a new solution from a template, the solution is registered in the modApplications table in the modSystem database.

Caution   You should not alter the modSystem database manually. Use the Access Workflow Designer and the Team Solutions Manager to make changes. Schema integrity is not guaranteed if you make manual changes to any Access Workflow Designer system database tables.

The modSystem database contains a number of tables used by the team solutions. The following table lists those database tables and provides a brief description. For more information about each table, select the following link.

Table name Number of tables Description
modApplications 1 Directory of all the team solutions that are on the server. Each row contains attributes associated with one individual solution.
modProperties 1 Name/value pairs of server properties.
modTemplates 1 Directory of all the team templates in the database. Each row contains attributes associated with one individual template.
modUserList 1 List of users associated with all the team solutions on the server.
Individual Template 1+ Description of template. There is one template table for each row in the modTemplates table (for example, the Issue Tracking Template).