The modApplications Table
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
The modApplications table is a directory table that is stored in the modSystem database. It holds a list of all the properties associated with each application registered on the server. The Workflow Manager for SQL Server uses this information.
**Note **You should not alter the modApplications table manually. Use the Workflow Designer for SQL Server and the Workflow Manager to make changes. Schema integrity is not guaranteed if you make manual changes to any Workflow Designer system tables.
The following table lists the modApplication columns and their data types and provides a brief description of each.
| Column | Data type | Description |
|---|---|---|
| Id | identity (int) | Unique identifier for each workflow project. |
| Caption | nvarchar(256) | Friendly name of the workflow project used by the administration components (for example, "Issue Tracking Sample"). |
| Description | ntext | Textual explanation of what the application is. |
| Server | nvarchar(128) | Name of the server where the SQL Server database is deployed. |
| Database | nvarchar(128) | Name of the SQL Server database (for example, "Issues"). |
| WebServer | nvarchar(512) | URL for the server that contains the Web site. |
| Folder | nvarchar(512) | Name of the Microsoft® FrontPage® Web folder on the Web server that contains the Web files. |
| Start_page | nvarchar(512) | URL for the start page for the application. |
| Summary_page | nvarchar(512) | URL for the summary page for the application. |
| Owner | nvarchar(128) | Name of the user who created the application. |
| Available | bit | Reserved for future implementation. |
| Properties | ntext | Reserved for user-defined properties. |
See Also
ModSystem Database Tables | The modTemplates Table | The Individual Template Tables | The modUserList Table | The modProperties Table (modSystem Database)