AgilePoint BPMS v5.0 R2 for .NET 3.5, .NET 4.0, and Genesis Edition
AgilePoint BPMS v5.0 SP3 for Universal Edition and Azure
© 2014 AgilePoint, Inc. All rights reserved.
| AgilePoint Database Schema / Tables | |
Contains information about user roles.
For the descriptions in this table, the term item refers to a user role.
| Column Name | Data Type | Size | Description |
|---|---|---|---|
| NAME | nvarchar | 64 | The name of the item as it was entered (can include both upper and lower case characters). |
| NAME_UPCASE | nvarchar | 64 | (Primary key) Represents the uppercase name of the item. |
| DESCRIPTION | nvarchar | 2048 | A free text description of the item. |
| CREATED_DATE | datetime | 8 | The date the item was created. |
| CREATED_BY | nvarchar | 64 | The user who created the item. |
| LAST_MODIFIED_DATE | datetime | 8 | The date the item was last modified. |
| LAST_MODIFIED_BY | nvarchar | 64 | The user who last updated, or modified, the item. |
| RIGHT_FLAGS | varchar | 256 | A sequence of (Y/N) flags that represent the access rights assignment to the role. |
| ENABLED | varchar | 3 | Indicates whether the item is enabled. |
| Table Name | Relationship |
|---|---|
| WF_ASSIGNED_OBJECTS | 1 – n |