WF_APPLICATION_FOLDER
Description
Contains information about the folders in an application.
Columns
For the descriptions in this table, the term item refers to an application folder.
| Column Name | Data Type | Size | Description |
|---|---|---|---|
| FOLDER_ID | varchar | 32 | (Primary key) The unique item ID. |
| FOLDER_NAME | nvarchar | 128 | The file name associated with the item. |
| APP_ID | varchar | 32 | (Foreign key to WF_ENABLED_APPS table) The ID (GUID) associated with the item. |
| DESCRIPTION | nvarchar | 2048 | A free text description of the item. |
| PROC_GROUP_ID | varchar | 32 | The ID (GUID) of the item. |
| PARENT_FOLDER_ID | varchar | 32 | (Foreign key to WF_APPLICATION_FOLDER table) The ID (GUID) of an item. |
| CONTENT_TYPE | nvarchar | 128 | The content type of the item. |
| CREATED_BY | nvarchar | 64 | The user who created the item. |
| CREATED_DATE | datetime | 8 | The date the item was created. |
| LAST_MODIFIED_BY | nvarchar | 64 | The user who last updated, or modified, the item. |
| LAST_MODIFIED_DATE | datetime | 8 | The date the item was last modified. |
| DISPLAY_NAME | nvarchar | 128 | The display name of the item. |
Relationships
| Table Name | Relationship |
|---|---|
| WF_ENABLED_APPS | n – 1 |
| WF_APPLICATION_FILE | 1 – n |