© 2011 AgilePoint, Inc. All rights reserved.
| AgilePoint Database Schema / Tables |
For the descriptions in this table, the term item refers to an event.
| Column Name | Data Type | Size | Description |
|---|---|---|---|
| EVENT_ID | varchar | 32 | (Primary key) The unique item ID. |
| EVENT_NAME | varchar | 32 |
The name of the event. CreateProcessInstance: Create process instance. StartProcessInstance: Start process instance ( status of process instance from 'Initiated' to 'Running'. PromoteProcessInstance: Move process instance forward. CancelProcessInstance: Cancel process instance. TerminateProcessInstance: Clean up process instance from memory. SuspendProcessInstance: Suspend process instance. ResumeProcessInstance: Resume suspended process instance. RollbackProcessInstance: Rollback or forward process instance. RollbackActivityInstance: Reset activity instance. CompleteWorkItem: Mark work item completed. AssignWorkItem: Take assignment of a work item in a pool (from 'New' to 'Assigned'). UndoAssignWorkItem: Put work item back into the pool. CancelWorkItem: Cancel work item. ReassignWorkItem: Reassign work item to other participant. CreateWorkItem: Create work item. CompleteProcedure: Mark an automatic work item completed. CancelProcedure: Cancel an automatic work item. |
| STATUS | nvarchar | 16 |
The status of the event. Sent: Indicates event has been sent to engine for processing. Failed: Indicates event failed to process. Processed: Indicates event has been processed successfully. Canceled: Indicates email was canceled. Deferred: Indicates email does not need to be sent immediately. |
| PROC_INST_ID | varchar | 32 | (Foreign key to WF_PROC_INSTS table) The process instance ID. |
| SENDER | nvarchar | 64 | Represents the person who sent the item. |
| SENT_DATE | datetime | 8 | The date the event was sent. |
| END_DATE | datetime | 8 | The date the item ends. |
| PARAMS_XML | ntext | The XML string that contains parameters about the event such as: WORKITEMID, ActivityInstID, UserID, etc. |
| Table Name | Relationship |
|---|---|
| WF_PROC_INSTS | n – 1 |
© 2011 AgilePoint, Inc. All rights reserved.