Tables

The following is the list of all the tables currently in the AgilePoint Database schema:

Table Name	Description
WF_ACTIVITY_INSTS	Contains information about the activity instances.
WF_ASSIGNED_OBJECTS	Contains information about assignment object for a user role.
WF_AUDIT_TRAILS	Contains audit trail information about a process template.
WF_AUTO_WORKITEMS	Contains information about the automatic work items.
WF_CUSTOM_ATTRS	Contains all the custom attributes. Custom attributes are associated with process instances through custom ID's. Custom ID's is the process instance ID or Work Object ID associated with process instance.
WF_CUSTOM_ATTRS_ITCS	Contains information about interceptors for a custom attribute.
WF_DELEGATIONS	Contains information about the delegation rules.
WF_DOMAIN_VALUES	Contains additional information related to the domain. For example, organizational information including department, title, etc.
WF_EVENTS	This table keeps tracks of individual events and statuses.
WF_GROUP_MEMBERS	Contains information about members association to user groups.
WF_GROUPS	Contains information about the user group definition.
WF_INTEGRATED_APPS	Contains the configuration for AgileConnectors, most importantly for NLB deployments.
WF_LARGE_BINARIES	This table is used to store large binary data.
WF_LARGE_TEXTS	Contains long text for various places and purposes. For example, email template definitions, error messages, etc.
WF_MAIL_DELIVERABLES	Contains information about the email notification.
WF_MANUAL_WORKITEMS	Contains information about the manual work items.
WF_PROC_DEFS	Contains the process definition (process templates).
WF_PROC_DEF_SUPPLEMENTS	Contains supplemental information about process definitions.
WF_PROC_INSTS	One of the main tables which contains information about the process instances.
WF_PROC_TRACKINGS	This table keeps track of the history of how a process moves from one step to another.
WF_REG_USERS	Contains information about the registered users in AgilePoint Server.
WF_REPORT_CFGS	Contains information about the report configuration.
WF_REPOSITIORY_ITEMS	Contains information about repository items.
WF_ROLES	Contains information about user roles.
WF_SCHEDULED_ITEMS	Contains information about interceptors for a custom attribute.
WF_SERIALLIZED_ENTITIES	This table is used to store business entities in a serial format (i.e. XML) for processing.
WF_SPOPERATIONS	This table provides the queuing service for the SharePoint AgileConnector.