The modObjects table is the repository for solution objects. It complements the information in the sysObjects table that exists in each SQL Server database. Objects are entered in the modObjects table only if they have Access Workflow Designer-specific attributes that are not stored in sysObjects.
The modObjects table stores information about user tables and their hierarchy. It also stores other objects such as SQL views, user views, triggers, or stored procedures if they require Access Workflow Designer-specific properties.
The object ID for each object is an identity column in modObjects and is used throughout the team solution schema tables. The Name column is used to link modObjects with sysObjects. If the table name is changed in sysObjects, you should explicitly propagate the name change in modObjects.
Caution You should not alter the modObjects table 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 solutions system tables.
The following table provides descriptions for the types of objects registered in the modObjects table.
Objects | Description |
Workflow tables | For each table, modObjects stores a Script flag that indicates whether the code for conditions and actions should be run by a script engine and the progID for the code execution component. |
User tables | The modObjects table provides a list of the user tables in a team solution. This information is required by the design-time and run-time user interface. For each detail user table, it stores its parent and defines the user table's hierarchy. It also associates a caption string with each user table. |
Lookup tables | A lookup table should be entered in the modObjects table if is used by other tables in the hierarchy. |
Workflow triggers | The modObjects table keeps track of auto-generated triggers that must be managed by the Access Workflow Designer. A trigger entry contains the trigger object ID and its type. |
Code Library | The solution code library is a database that is globally available to all the workflow functions in the solution. |
Auto-generated objects | A list of SQL objects (views, stored procedures, triggers, and so on) that must be managed by the Access Workflow Designer is generated. A view entry will contain the view object ID and its type. |
The modObjects database table contains a number of columns used by the team solutions. The following table lists those columns and their data types and provides a brief description of each.
Column | Data type | Description |
Id | identity (int) | Unique identifier for a table. |
Name | nvarchar(128) | Table name. |
Type | char(2) | Type of object:
main user table main database view detail user table detail database view lookup table relation table other user tables workflow table permission table stored procedure trigger code library
|
Parent_id | int | Parent object ID. This column is Null for main user tables and holds parent table ID for detail user tables. |
Permission | bit | 1 if permissions are enabled on this table; otherwise, 0. |
WFOutOfProcess | bit | 1 if the workflow engine runs out of processes (default); otherwise, 0. |
WFEnable | bit | 1 if workflow is enforced (default); otherwise, 0. |
WFOriginalValues | bit | 1 if the original column values of the Issue being changed should be available at run time. In this case, the original values are returned by the Session.OriginalItem recordset; otherwise, 0 (default). Note that making available the original values slows down the performance of data changes to the Issues table. |
Script | bit | 1 if the workflow associated with the user table uses a scripting engine; 0 if it uses an active designer. |
Prog_id | nvarchar(64) | The progID of the component used to execute workflow code. It can indicate a scripting engine or an active designer. |
Code | text | Common script code for a workflow table. |
Caption | nvarchar(256) | Friendly name of the object component used as the caption for tables or columns (for example, "Issue due date"). |
Properties | ntext | Reserved for user-defined properties. |
Diagram | image | Persisted the workflow diagram for workflow user tables. |
LockedBy | sysname | Current computer and user that have taken the lock on the table |
rowguid | uniqueidentifier | Unique identifier used for solution objects. |